Excel Automation


I have created an automation to read an Excel with 1000+ records using an Excel loop. But, this automation doesn’t execute and hangs. Any solution?

Hi @anshu.khetarpal

In case you are having more than 1000 rows in your excel, please try increasing the Page Size in Excel Properties.

Refer this link in Knowledge Base for more info.

There’s another option as well in which you can split one excel file in multiple files using File Splitter Activity.
The file splitter can split your excel based on the number of rows.

Refer this link to understand more about File Splitter activity.

PFB the image which can help you.