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 parameters separated by dot(.).
First parameter: alias name (same as defined in load excel function).
Second parameter: column name.
Third parameter: index.

Syntax: ${__getcellvalue(alias name.column name.index)}

Note: It is mandatory to load excel file and then user can use the alias defined in load excel function.

Example: ${__getcellvalue(xyz.password.2)}

Was this page helpful?