Read Multiple Excel files using Nested Loop

Hi All,

Can you please tell how to read multiple excel files using nested loop.if you have done it please send a screen shot of it with an example.

Thanks & Regards
Veeresh M

Hi,

Use excel loop activity inside the another excel loop activity with different excel files. You can use the same for any number of the files required.

Regards,
Shubham.

Hi Shubham,

I tried the same while adding different excel files, once one file added inside excel loop activity and try to add another excel in other excel loop activity the opened excel file getting closed automatically and after that while execution getting error “Excel Loop Retrieving the COM class factory for component with CLSID”. Please suggest how to resolve it.

Thanks & Regards,
Veeresh M

Hi,

Explain in brief your use case along with relevant process configuration screenshot

Regards,
Amit Anand

Hi Amit,

I have a requirement to fetch the data from different excels and bind the same in mail using data table , now when when I select excel file from location in excel loop activity the sheet name is not appearing. I cant able to proceed further.

Thanks & Regards,
Veeresh M