Performance degrades when having more than 3 tabs

Aspose.Cells Product Family
1

Hi,

I am using Aspose.Cells 4.5 for .NET and found that the performance degrades exponentially when tab number increases. I use ImportDataTable to copy the dataset.

I need to fill in each tab with 65535 rows. When I have 3 tabs, it's taking 94 seconds, and 4 tabs take 331 seconds. When I have 5 tabs, it throws "OutofMemory" exception in the save() method.

Do you have a limit on the size of the dataset or the output file? Is there anyway to improve?

Thanks!

Miao

2

Hi,

No, we don't place any size restriction for dataset or output file produced. Well, when you fill three or more than three sheets each with 65k+ rows, huge amount of memory would be consumed and the size of the excel file would also be a huge one for your info. I think you should split 65k+ rows into multiple sheets or split your workbook to multiple workbooks (files), it would increase performance.

Thank you.