search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 99 forks source link

Excel export fails when there's more than 2 dimensions on the filter axis #165

Closed mysticfall closed 10 years ago

mysticfall commented 10 years ago

Excel export fails when there's more than 2 dimensions on the filter axis, due to duplicated worksheet names : 

Caused by: java.lang.IllegalArgumentException: The workbook already contains a sheet of this name
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:813) ~[poi-3.10-FINAL.jar:3.10-FINAL]
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:85) ~[poi-3.10-FINAL.jar:3.10-FINAL]
    at org.pivot4j.ui.poi.ExcelExporter.createSheet(ExcelExporter.java:318) ~[pivot4j-core-1.0-SNAPSHOT.jar:?]
    at org.pivot4j.ui.poi.ExcelExporter.startTable(ExcelExporter.java:151) ~[pivot4j-core-1.0-SNAPSHOT.jar:?]
    at org.pivot4j.ui.table.TableRenderer.renderFilter(TableRenderer.java:1723) ~[pivot4j-core-1.0-SNAPSHOT.jar:?]
    at org.pivot4j.ui.table.TableRenderer.render(TableRenderer.java:488) ~[pivot4j-core-1.0-SNAPSHOT.jar:?]
    at org.pivot4j.analytics.ui.PivotExportHandler.exportExcel(PivotExportHandler.java:345) ~[PivotExportHandler.class:?]

Related forum post :