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.
To enable the feature, enable option
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 is ignored if it is any other type of file or cloud storage.