We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Exporting large amounts of data

Hi,

I'm having issues exporting a large dataset from database to excel (65 columns, 200.000+ records).

I'm currently generating the Excel xml file format, but this leads to an excel file of 1GB+ (when I open this file in Excel and save it in native excel format it's about 80MB)

Does Aspose.Cells support supporting a large dataset?

Thanks!

Rutger

Hi,

Yes Aspose.Cells does support large dataset/datatable to import to worksheet. This big process will take certain amount of memory and take time a bit to be completed. The output file would have large size too. It is to be noted here, for your large dataset to export please use MS Excel 2007 file formats e.g XLSX to Save the file.

Please check the document for reference:
Import Data into Worksheet

Moreover, we recommend you to try our latest version (e.g v4.9.0.x) in which we have optimized its performance regarding bigger tasks.

Thank you.