Nested excel loop issue

1

hi
i need to use nested excel loop. but it s not working fine. sometimes the process is getting success. sometimes it abrubtly fails and when i try to run again it is failing in some other steps. i have provided necessay delays in each step. can’t understand why it is failing abruptly i some step. pls help me in this issue

Thanks and regards
ilakkiya

2

Hi,

What error comes when it fails

Regards,
Amit Anand

3

hi Amit
i just want to write back to the excel.for first iteration it was working fine from second iteration it is showing me this error.pls help me in this issue

image
image885×87 3.23 KB

Thanks and regards
ilakkiya

4

Hi,

Are you closing the excel or killing excel process post 1 iteration

Regards,
Amit Anand

5

No i was not killing or closing the excel process. i am using Write back to excel activity. for first iteration it is writing back to the excel, from second iteration it is showing the above error.
Thanks and regards
ilakkiya.s

6

Hi,

In Nested excel are you using the same excel for inner an outer loop. Or trying to write in outer loop excel when iterating over inner loop

Regards,
Amit Anand