Definition and Usage
Export multiple data tables to one XLSX file, each as a separate worksheet. This command allows you to consolidate multiple data tables into a single Excel file, making it easier to organize and share related data.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Data table | Multiple data tables to be exported | - | Yes | Multiple data tables can be added using the "Add" button |
Save to | Enter the full path or select the location | - | Yes | You can manually enter a path or use the "Select folder" button |
File name | Enter the name for the exported file | - | Yes | The file extension .xlsx will be automatically added if not specified |
If file exists | Select the action to take if a file with the same name already exists | Use random file name, Overwrite | Yes | - |
Export with header | Include column headers in the exported file | - | No | Check this option to include headers in the exported file |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
Store the exported file path in a new variable. This variable will contain the full path to the newly created Excel file.
Using Variables in Conditions
Parameters with the {x} icon can accept variables as input. You can use previously defined variables to dynamically set parameters such as file paths or names. For example, you could use a variable for the "Save to" parameter to dynamically determine where files are saved based on other workflow conditions.
Notes
Each data table will be exported as a separate worksheet in the Excel file.
Ensure that the data tables are properly structured before exporting.
The destination folder must exist and be accessible with appropriate write permissions.
If "Export with header" is checked, the first row of each worksheet will contain the column names.
When multiple data tables are exported, the worksheet names will be based on the original data table names.