Hi,
It seems that the ExportDataTable method is limited to 65536 rows, but Excel 2007 can have more rows in a sheet.
So you extend this method to support Export in an Excel 2007 sheet.
Thanks
Hi,
It seems that the ExportDataTable method is limited to 65536 rows, but Excel 2007 can have more rows in a sheet.
So you extend this method to support Export in an Excel 2007 sheet.
Thanks
Hi,
No, it's not. I think you are using some previous version of Aspose.Cells for .NET. Kindly try our latest version / hotfix (4.5.1.0): http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry145662.aspx as it is supported.
Following is my sample code which works fine and attached are the input and output files.
Sample code:
Workbook book = new Workbook();
book.Open("f:\\test\\expBook.xlsx",FileFormatType.Excel2007Xlsx);
DataTable dt = book.Worksheets[0].Cells.ExportDataTable(0, 0, 70000, 1);
MessageBox.Show(dt.Rows.Count.ToString()); //displays total no. of records in the table.
book.Worksheets[1].Cells.ImportDataTable(dt, true, "C10");
book.Save("f:\\test\\expBook1.xlsx", FileFormatType.Excel2007Xlsx);
Thank you.
May be it is just a problem with the documentation :
Because, you can read this (in the Aspose.Cells.xml and in the online documentation) :
Number of rows to be imported,no more than 65536.
Number of columns to be imported,no more than 256.
Thanks
Hi,
Yes, the documentation is true for MS Excel 97-2003 but not true if you talk about MS Excel 2007. Anyways, we will update API reference documentation soon.
Thank you.