How to create Excel file if datatable has 70000 records using aspose.cells

Aspose.Cells Product Family
1

Hi,


I am using Aspose.cells to create excel file from a datatable. Now I got an issue with datatable with 70000 rows. One sheet in Excel can handle only 65536 rows and I tried to add new sheet to the workbook to put rest of rows. I am not sure how to add new worksheet to the workbook and I am not sure how to handle excel sheets with more than 65536 rows.


Thanks,
Srilakshmi
This message was posted using Email2Forum by ShL77.
2

You saving it as Excel 2003? I understand if you save it as Excel 2007, you can have over million rows.

Add a new workbook.

'Add a new worksheet to the Workbook object
workbook.Worksheets.Add()
'Obtain the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.Worksheets(1)
'Set the name of the newly added worksheet
worksheet.Name = "My Worksheet2"

3

Hi,

Yes, your understanding is correct!

If you have over 70k records, you should import data into Excel 2007 Xlsx file format, you can fill a worksheet and save/generate the file in Xlsx file format using the Aspose.Cells APIs.

…
workbook.Save(“MyFile.xlsx”,FileFormatType.Excel2007Xlsx);


Thank you.