i had an excel file where i need to start executing the data by identifying its last updated based on a column… i am able to fetch the last used row in a column , but by using FOR EACH ROW can we start the iteration from row say11(assuming BOT has processed upto row 10 and breaked due to some unexpected issue)
i saw some posts like we need to use For each but i want to know if we can achieve the same with FOR EACH ROW?
You can use the row index property, with an If inside the For Each Row activity:
Always remember the index is 0 based, so “> 8” means “9 or higher” which means start at the 10th row.
Heck I never even noticed this before but it looks like you can do it right in the For Each Row activity:
Hi,
FYI, another approach using Skip method and ForEach activity instead of ForEachRow.
dt.AsEnumerable.Skip(10)
Regards,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
