Free Support Forum -

Performance optimization techniques


I’m generating a large Excel file by writing the data cell by cell. The performance isn’t at all bad. It takes only 4 minutes 10 seconds to generate 10,000 rows. I’d like to bring that down though if possible.

Would it help if I write the data in bulk , e.g. an entire row or page at a time? How can I do this?


Peter Wu
United Launch Alliance


If you want to import data in a bulk, then you should consider this document.

Importing Data to Worksheets

It should increase the performance than writing cell by cell.