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