Getcellvalue function

This function is used to get the cell value from the specified excel sheet and store that data in a variable defined in element key. This function takes in three values separated by dot(.).

Select SET command from the action dropdown and provide a variable name in Element key, edit parameter section and click on Form, select functions from the dropdown and select GETCELLVALUE function. Provide the values in the form.

First value: alias name (same as defined in load excel function).
Second value: column name.
Third value: index.

Note: It is mandatory to load excel file function before this function to load the file and store file data in a variable(alias) name and then user can use the alias defined in load excel function here in get cell value function.


Example: Sample Script for reading data in an excel sheet using for loop.

Was this page helpful?