I have a excel sheet which contains 1000 data, I need to read the data from excel and put that data to web table.
In that web page single page contains 50 rows.
so, for 1st page all 50 data are successfully working , but it doesn’t work for next page. (like when it goes to next page excel sheet should read from 51th row and so on and selector values needs to start from beginning as well).
What u can try is
Split the excel files into multiple files of 50 rows each and store in a folder and iterate through each file and enter the data to the webtable, after iterating through one excel file is over , you can move to next page by clicking and do the same