Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Broken XLS files with 3.7

  1. #1
    Join Date
    Mar 2010
    Posts
    6

    Default Broken XLS files with 3.7

    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

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    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.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.