ExportDataTable not compatible with Excel 2007

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.