Saving to excel

Aspose.Cells Product Family
1

We have 80k record so i need to bind as bulk excelSheet.get_Range(“A1:H25”, Type.Missing).Value2 = 

    bidimensionalObjectArray;
Fast Exporting from DataSet to Excel - CodeProject
Above method present in interop so is there any method to do bulk copy in aspose it is taking a lot time to save and open the excel
Thanks in advance 
high priority please

2

Hi,

Thanks for your posting and using Aspose.Cells.

If your data is inside data tables or Array list, then you can import your whole data to worksheets using one of the import methods of Aspose.Cells instead of inserting data cell by cell.

Please see the following documentation article how to import data into worksheets from different data sources.

http://www.aspose.com/docs/display/cellsnet/Importing+Data+to+Worksheets