Definition and Usage
Export a data table to a local XLSX or CSV file. This command allows you to save data table content to either Excel or CSV format with various configuration options such as file location, naming, and header inclusion.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Data table | Select the data table to export | - | Yes | Must be a valid data table variable |
File type | Select the file format for export | Excel, Csv | Yes | - |
Sheet name | Specify the name of the worksheet | - | Yes | Only applicable when exporting to Excel format |
Save to | Enter the full path or select the location | - | Yes | Use the "Select folder" button to browse for a location |
File name | Enter the name for the exported file | - | Yes | Include file extension (.xlsx or .csv) |
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 - Creates a text variable containing the full path to the exported file.
Using Variables in Conditions
Parameters with the {x} icon indicate that you can insert variables created earlier in your workflow. For example, you can use a variable to dynamically determine the file name or save location based on other data in your process. When using variables, ensure that the variable type matches the expected parameter type (e.g., text variables for file paths).
Notes
When exporting to Excel format, ensure that the specified sheet name is valid and doesn't contain characters not allowed in Excel sheet names.
The "Export with header" option is particularly useful when the data needs to be human-readable or imported into other systems that expect column headers.
If using the "Use random file name" option, a unique identifier will be appended to the file name to prevent overwriting existing files.
For CSV exports, be aware that any formatting in the data table will be lost as CSV is a plain text format.
Ensure that the process has proper write permissions to the specified save location.