Update existing Excel XLSX spreadsheet

Overview

By default Excel XLSX connector creates a new spreadsheet, then creates and populates a worksheet. It is possible to configure Excel XLSX Format to update exiting spreadsheet.  If this feature is enabled the connector will not create a new spreadsheet but will update (or create if doesn't exist) the specified worksheet. 

Process

To enable the feature, enable option Update existing spreadsheet for the Excel XLSX Format.  Use this format as a destination in the source-to-destination transformation, when destination format is an Excel XLSX file and the destination connection is server storage.

This option works only when the destination connection is server storage and ignored if it is any other type of file or cloud storage.