Loadexcel function

This function is used to load the excel sheet and store its data in a variable given in the parameters. This function takes in four parameters.
First parameter: Excel sheet path.
Second parameter: Sheet number.
Third parameter: alias name or the variable.
Fourth parameter: Orientation (either H for horizontal or V for vertical).

Syntax: ${__loadexcel(File path,Sheet Number,alias name,orientation)

Example: ${__loadexcel(E:/Book1.xlsx,1,xyz,H)}

Select RUN command from the action drop down, leave Screen name, Element key blank and provide this function in parameter section as shown below:

Was this page helpful?