Free Support Forum - aspose.com

Excel 2007 / one million row support

Hello,

Can you tell me when a new version of the Cells library for .NET will be released? We need the row size limitations of Excel 2007 (1,000,000 rows) supported and we have had an outstanding issue that computed columns in pivot tables do not show up in Excel 2007 (if you open the same pivot table in Excel 2003 the computed columns appear). A sample with this issue has been attached.

Thanks,
Justin

Hi Justin,

1). We have already done it, kindly try the attached version. The following code will work fine for Excel 2007 file:

Workbook workbook =new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
Cells cells = worksheet.Cells;
cells.Merge(0, 248, 1, 100);
cells[0,248].PutValue("Hello World!");
cells[1048575,16383].PutValue("Last Cell");
workbook.Save("d:\\test\\mybook.xlsx",FileFormatType.Excel2007Xlsx);

2). For pivot table issue, could you try with the attached version. If you still find any problem, give us all the details and paste your code here to reproduce the issue. We will check it soon.

Thank you.

We released a new version v4.4.1 which support one million rows in Excel2007. Please download and try it at http://www.aspose.com/Community/Files/51/aspose.cells/entry111612.aspx .