Export To Microsoft Excel

The Export To Microsoft Excel node writes the output of a dataflow to a Microsoft Excel file. The node takes the incoming data and generates an Excel file that is stored in a selected location.

Steps:

1. Select a File source (e.g. OneDrive or Any2Info platform storage).
2. Choose the destination Folder.
3. Define the File name.
4. The node generates an Excel file based on the input data.
5. The file is stored in the selected location.

Configuration

Setting	Required	Description
File source	Yes	The connection where the Excel file will be stored (e.g. Microsoft OneDrive or Any2Info platform).
Folder	Yes	Opens a folder picker to select the destination folder.
File name	Yes	The name of the generated Excel file.

Input

The node uses the incoming dataset from the previous node. Each column becomes a column in Excel, and each row becomes a row in the Excel file.

Output

• An Excel file is created in the selected location, containing all columns and rows from the input dataset.
• The dataflow continues without modifying the dataset.
• The entire dataset is written to a single Excel file.
• Column names are used as headers in the Excel sheet.
• Data types are converted to a compatible Excel format where needed.

Tips

• Use clear and descriptive file names.
• Be mindful of large datasets, as they may impact performance.
• The connection must have permission to write to the selected location.
• Existing files may be overwritten depending on the file source behavior.
• Large Excel files may take longer to generate.