Definition and Usage
Import Excel to Data Table command imports data from an Excel worksheet into a data table. This action allows you to extract information from Excel files and convert it into a structured data table format that can be manipulated within your workflow.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
File path | Select the Excel file to import |
| Yes | Use the Select file button to browse for the Excel file |
Select worksheet | Select how to identify the worksheet: by index or by name | Specify sheet name, Specify sheet index | Yes |
|
Worksheet index | Specify the position of the worksheet to be imported |
| Yes (if "Specify sheet index" is selected) | Index starts at 1 |
Worksheet name | Enter the exact worksheet name to import |
| Yes (if "Specify sheet name" is selected) | Case sensitive |
Use first row as headers | Check to use the first row of the worksheet as data table column headers |
| No | When checked, column headers will be derived from the first row |
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 data sheet into: This action produces a data table variable that contains the imported Excel worksheet data.
Using Variables in Conditions
Parameters marked with {x} icon indicate that you can use variables in these fields. For example, you can use a variable for the file path if the Excel file location is determined dynamically during the workflow execution. Similarly, worksheet name or index can also be specified using variables.
Notes
Ensure the Excel file exists and is accessible before executing this command.
If the specified worksheet name or index doesn't exist in the Excel file, an error will be triggered.
For large Excel files, the import process might take some time to complete.
Make sure the Excel file is not corrupted or password-protected, as this may prevent successful import.
When "Use first row as headers" is checked, ensure the first row contains unique and valid column names.