I am currently developing an automation which reads an excel file and then passes each row of the excel file into a website.
The excel file contains on top 3000 rows ( i believe this is relevant).
When I iterate through the data table it seems that it does not respect the excel file order.
I encounter multiple situations when it starts with row 1 and then jumps to record 2000 then to record 500…and so on. There is no filter applied and the Add Headers option is checked in the read range block.
Why is this an issue you might be wondering? I am dealing with a big number of records and hence there might be runtime unexpected errors which I am not aware of the automation will crash. This will require me to update the table from the last know entered value in the web application -> delete the added rows from xls -> restart the robot.
Steps to reproduce:
Excel application Scope
read range -> output DataTable
for each row in DT
assign to value
catch ( SelectorNotFound exception)
Expected Behavior: Iterate through each row as displayed in the xls file.
Thanks for the help,