Excel Workbook loading into DataTable Takes very long Time

Aspose.Cells Product Family
1
workSheet.Cells.ExportDataTableAsString(0, 0, ws.Cells.MaxRow, ws.Cells.MaxColumn, false);

It is a large workbook 100 MB, but it opens up in 1 minutes on Windows 7 PC. However, function call takes 30+ minutes.

I have extensively researched api and tried to figure out if this can be optimized but haven't had luck so far. Your assistance will be highly appreciated.



2

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version:
Aspose.Cells for .NET 8.7.0 and see if it makes any difference and resolves your issue.

Since your excel file is quite large so it will definitely take some amount of time. Please upload your excel file on http://dropbox.com and share a download link with us for evaluation.

Please also share the sample code you are using for our testing. We will look into it and help you asap.