Hi,
Please try the attached latest fix v2.1.2.18.
If you are exceeding MS Excel 2003 (which is on by default) row/column limitation, you should explicitly set the file format type of the workbook to Excel2007.
Please do add a line of code first, i.e.
workbook.setFileFormatType(FileFormatType.EXCEL2007);
Please do let us know if you still find the issue.
Thank you.
> workbook.setFileFormatType(FileFormatType.EXCEL2007);
Hi,
Well, actually the method setFileFormatType() was included in the recent fixes and was not included in the official release v2.1.2.0, so you will not see this API in the documentation. However, in our next official release this method be included and the documentation would be updated then.
Moreover, as I recommend kindly use my attached version (v2.1.2.18), this version does have the method. Also, kindly let us know it it works fine with this version.
Thank you.
OK the program doesn’t crash anymore but when I open up the Excel file there’s no pivot table in it.
Hi,
I am afraid, PivotTables for Excel 2007 feature is not available by the component. We are scheduled to support the feature in our future releases.
Thank you.