Excel To Data Table Step

Brief description

This step saves data from the excel file into the datatable variable.

Step Information

Step name (Not required) – the custom name of the process step that labels the editor’s process step box

Input parameters

Excel Path (Required)– existing variable name or value that specifies the full path to excel file

Sheet (Required)– existing variable name or value that specifies the sheet name

Has custom columns (Required) - has header columns

• T (true)
• F (false- default value)

Output parameters

Result Datatable (Required)– existing or new variable name of datatable data type that contains the resulting value

Column count (Required)– existing or new variable name of integer data type that contains the resulting data table variable count of columns 

Row count (Required)– existing or new variable name of integer data type that contains the resulting data table variable count of rows