Approach Manipulate excel with 10000 plus records

Hi!

Sometimes, handling large Excel Files can be a rather tricky task.
Depending on the size of the file and the number of rows, you might not be able to read it or write it all at once, so you might have to manipulate it in chunks.

Normally, a file with 10000+ rows should be read without issues using the Excel Application Scope . However, files larger than 100000+ rows can present some challenges, so those files should be processed in chunks:

EDIT: I also developed a custom activity that should give you the exact number of rows for an excel file (its been tried and tested a few times and it works on really large files ~ 1 mil. rows or even more). If you consider that you need it for processing your file in chunks, I’d be more than happy to share it with you!

1 Like