Read multiple excels

Hi Everyone,

I need to read many excels placed on a folder and do the coding. But in Excel loop i am able to put only one excel.

Please provide a solution for this.

Thanks,
Ankita

Hi,

You can use a nested Excel loop where in outer excel provide the path of excel to be read

Regards,
Amit Anand

Hi Amit,

Can you please provide an example for this with the screenshots of Nested excel loop?

Thanks,
Ankita

Hi Amit,

Can you please provide an example with screenshot of this?

Thanks

Hi,

Kindly refer this post. Here i have explained how nested excel loop works