GetCellReference function

This function is used to get the value from a specified cell from the excel file.

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select GETCELLREFERENCE function. Provide file path, cell reference and sheet number.

Data fetched from the cell reference will be stored in a variable defined in Element Key, after completing this step test will look as below:

Was this page helpful?