Assign Excel Cell Value To Variable Step

Brief description

This step reads excel cell value from a selected 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 path (Required)– existing variable name or value that specifies the full path to excel file
• Sheet name (Required)– existing variable name or value that specifies the sheet name
• Column name (Required)– value that specifies the Excel column letter
• Row index (Required)–  value that specifies the Excel row index

Output parameters

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

Additional comments

If the ‘Upload File’ button is used to select the 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.