PDA

View Full Version : Broken XLS files with 3.7



asabi
03-18-2011, 03:20 PM
Hi,

We have an integration with Pentaho that works with the 3.6 jar files (we are embedding pentaho into a web app).

When I replaced the jar files, PDF files are still showing as they should, but we get the following errors when specifying XLS in the output type:

java.lang.NoClassDefFoundError: org/apache/poi/openxml4j/exceptions/InvalidFormatException
org.pentaho.reporting.engine.classic.core.modules.output.table.xls.FlowExcelOutputProcessor.<init>(FlowExcelOutputProcessor.java:70)
org.pentaho.reporting.engine.classic.core.modules.output.table.xls.ExcelReportUtil.createXLS(ExcelReportUtil.java:282)
ReportExecute.doGet(ReportExecute.java:124)
ReportExecute.doPost(ReportExecute.java:154)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

This is the code we are using in the .java file:


// render in excel
response.setContentType("application/vnd.ms-excel");
ExcelReportUtil.createXLS(report, response.getOutputStream());

Should we change anything for 3.7 ?

please be verbose with your answer, I am not a JAVA developer, my knowledge is quite basic.

Thank you

Alon

Taqua
03-19-2011, 08:23 AM
Yes, upgrade your POI to a more recent version (at least the version the reporting engine ships with). As every other project as well, we depend on third party libraries to do some jobs for us. And when you upgrade you have to upgrade these libraries as well, or face eternal death and peril and terminal extinction and so on. :)