How to Save Multiple Sheets into the Same Excel File

General
1

How do I configure the Advanced Save Excel Node to output multiple datasets into different sheets/tabs of a single Excel file?

Solution

To save multiple sheets to the same file without overwriting previous data, you must use the AppendSheet save mode in the SaveExcelAdvanced node.

Follow these configuration steps:

  1. File Path: Ensure all output connections point to the exact same file path.

  2. Save Mode: Change the Save Mode dropdown to AppendSheet.

  3. Sheet Name: Provide a unique name for each sheet (e.g., Revenue, Costs, Summary).

Technical Constraints

  • Max Connections: By default, the node supports up to 5 output connections.