We have 80k record so i need to bind as bulk excelSheet.get_Range(“A1:H25”, Type.Missing).Value2 =
bidimensionalObjectArray;
http://www.codeproject.com/Articles/21519/Fast-Exporting-from-DataSet-to-ExcelAbove 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
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