"For Loop" not working inside "Use Excel File" activity

Help Studio
, ,
1

I am using a “For Each” loop to iterate a range in Excel. However, I have to place the “For Each” activity outside the “Use Excel File” activity or if hangs. Even a simple loop like this
https://docs.uipath.com/activities/other/latest/workflow/for-each
fails unless outside.

Is there a setting or something I am missing?

2

Hi @Phil_Kelsey

Can you give us more details on the issue?

What was the erro you getting?

3

this fails.

image
image588×629 56 KB

image
image868×57 5.24 KB

if i cant fix this then I try to use Python instead

4

@Phil_Kelsey

use for each row in excel for iterating through the each row in excel

and for list or for collections you can use for each activity

cheers

5

i do not need to the loop worksheet. I am extracting a range columns in a single row. I need the For Each loop to iterate the array. But it freezes.

this is range I ultimately want to iterate: excel.sheet(“Sales”).Range(“A1:N1”)

6

Still having this problem. I have a workflow that has been working well for some time. Now it freezes in a “For Each Excel Row” activity when it encounters a “If else” activity or a “For Each” activity. I have tried it with and w/o an “Excel Scope” activity. I had to remove all the ifs and for-each type activities and if runs fine. I checked the UiPath Diagnostics and it may have something to do with threading. I tried reinstalling Studio but still same issue. Has there been an update that is causing this error? It there something I am doing wrong.