ZK 7.0.4 Excel Exporter throwing Exception

asked 2015-03-04 02:46:45 +0800

rahulRambo
1

Hi All, Currently I am using ZK 7.0.4.I am trying to export a grid or Listbox to Excel using ExcelExporter.This feature was working properly when I used it with ZK 7.0.0.But when I am using with ZK 7.0.4 I am getting exceptions at the third line of the code ByteArrayOutputStream out = new ByteArrayOutputStream();
ExcelExporter exporter = new ExcelExporter(); exporter.export(lbReportRevenueContributor,out); where lbReportRevenueContributor is the id of my Listbox. The exception is:-

java.lang.IllegalArgumentException: Invalid row number (-1) outside allowable range (0..1048575) at org.zkoss.poi.xssf.usermodel.XSSFRow.setRowNum(XSSFRow.java:343) at org.zkoss.poi.xssf.usermodel.XSSFSheet.createRow(XSSFSheet.java:601) at org.zkoss.poi.xssf.usermodel.XSSFSheet.createRow(XSSFSheet.java:126) at org.zkoss.exporter.excel.ExcelExporter.getOrCreateRow(ExcelExporter.java:298) at org.zkoss.exporter.excel.ExcelExporter.getOrCreateCell(ExcelExporter.java:316) at org.zkoss.exporter.excel.ExcelExporter.exportCellsWithSpan(ExcelExporter.java:268) at org.zkoss.exporter.excel.ExcelExporter.exportAuxhead(ExcelExporter.java:151) at org.zkoss.exporter.excel.ExcelExporter.exportAuxhead(ExcelExporter.java:1) at org.zkoss.exporter.AbstractExporter.exportHeaders(AbstractExporter.java:172) at org.zkoss.exporter.excel.ExcelExporter.exportTabularComponent(ExcelExporter.java:138) at org.zkoss.exporter.AbstractExporter.export(AbstractExporter.java:218) at com.huawei.eip.controller.reports.RevenueContributorController.download(RevenueContributorController.java:106)

Please help me in this regard.

Thanks, Rahul Kumar Sinha