Read Value From Excel File Step

Brief description

This step reads excel cell value from a previously connected Excel file and saves the value to the string 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 instance name (Required)– value of the unique connection instance name previously defined in the Open Excel File step
• Upload File – a button that opens the file explorer screen for selecting the Excel file
• Sheet name (Required)– existing variable name or value that specifies the sheet name
• Column name (Required)– existing variable name or value that specifies the Excel column letter
• Row index (Required)– existing variable name or value that specifies the Excel row

Output parameters

Destination variable (Required)– existing or new variable name of string data type that contains the resulting value 

Additional comments

The 'Excel instance name' text box contains the list of the instance names previously defined in the Open Excel File step/s.

If Upload File button is used to select the proper Excel file, the ‘Sheet name’ text box contains the list of the sheet names from the selected file. If a sheet name is selected, the ‘Column name’ text box contains the list of the column letters from the selected file sheet.