Overview
By default, the Excel XLSX connector creates a new spreadsheet, then creates and populates a worksheet. However, it is possible to configure the Excel XLSX format to update an existing spreadsheet instead.
When this option is enabled, the connector will not create a new spreadsheet but will update the specified worksheet — or create it if it doesn’t exist.
This feature only works when the destination connection is server storage. It is ignored for cloud storage or other types of file storage.
In addition to updating a single worksheet, this feature also allows creating a spreadsheet with multiple worksheets in the same file.
Process
Step 1: Enable Update Existing Spreadsheet
In the Excel XLSX format settings enable option .
Step 2. Use the Format in a Transformation.
IMPORTANT: destination connection must be server storage.
Step 3: (Optional) Set Worksheet Names
If you’re updating or creating multiple worksheets in the same Excel file, specify the worksheet name using the following format in the TO field of the transformation:
filename.xlsx|sheetname
Comments
0 comments
Please sign in to leave a comment.