Erro: There is no row at position 2

I have a table, which has 10 rows, but that table contains a few empty lines, so it includes a filter for when entering For each the robot is not checking for empty lines.

But now an error is occurring, because as the table has a filter the robot cannot find line 2, how can I do to eliminate this error? Or do I need to remove the filter for it to work perfectly?

Hi @lourena.coutinho, have you tried removing the filter? And can you post a screenshot of the workflow?
Thanks!

1 Like

Please make sure you have checked UseFilter option in Excel Read Range

1 Like

So I scored and even then the error continues.

image

image

My workflow:


image

  1. Are you using filter in excel sheet or only the filter activity ?

  2. In the assign activities, you don’t want to traverse through the data table instead you can just use the row object in the for each.

1 Like

Excel sheet

image

I’m sorry, but I don’t understand the second point.

don’t i need to have an accountant in the formula?
image

No problem, It will be easier if you can share your xaml file please.

1 Like

I had two for each, I don’t know why, but now it works. Thank’s for your time.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.