LoadTableByIndex function

LoadTableByIndex function  is used to load the excel table data as per user given start and end Index.

Select RUN 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 LOADTABLEBYINDEX function. Provide filePath, sheetNumber, orientation, alias, startIndex and endIndex.

Note: Here alias is the variable in which excel table will be loaded.

Once the table is loaded in the alias name, user can get value or set value in the specified excel sheet using GETCELLVALUE function or SETCELLVALUE function.

After completing the step, it will look as below:

Tabular view : 

Card view :