ReportServer Forum

quintg

Member

Registered: 2016-10-19

Excel error with Jasper in 3.0.4

With CE version 3.0.4 when I create an Excel export from a simple Jasper report I get an error when opening with Excel 2016: "We found a problem with some content in '(filename).xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes". After clicking Yes it opens in Excel, with diagnostic message "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.". The result seems to contain everything from the design, including a logo.
In excelexport.cfg I have the defaults:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <xls>
      <format>xlsx</format>
      <stream>true</stream>
   </xls>
</configuration>

quintg

Member

Registered: 2016-10-19

Re: Excel error with Jasper in 3.0.4

The issue seems to be caused by the company logo which is embedded in the template with this piece of code:

new java.io.StringBufferInputStream( new org.w3c.tools.codec.Base64Decoder($V{vLogo}).processString() )

When removing the logo the export is fine.