Update existing Excel XLSX spreadsheet

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 Update existing spreadsheet.

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