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?