Performance optimization techniques

Aspose.Cells Product Family
1

Howdy,


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?

Thanks,

Peter Wu
United Launch Alliance
2

Hi,

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.