Export to XLS does not include headers

[hectormabilangan]

Hi,

I just upgraded from JasperServer 3.5 to 3.7 to 4.0 as stated in documentation. After upgrading, report headers are not included when exporting to XLS.

Included here is my xlsExportParameters as stated in applicationContext.xml 

I also attached a sample jrxml file that has the issue.

Hope someone can help.

Thanks in advance!

Code:

<property name="detectCellType" value="true"/><property name="onePagePerSheet" value="false"/><property name="removeEmptySpaceBetweenRows" value="true"/><property name="removeEmptySpaceBetweenColumns" value="true"/><property name="whitePageBackground" value="false"/><property name="ignoreGraphics" value="false"/><property name="collapseRowSpan" value="false"/><property name="ignoreCellBorder" value="false"/><property name="fontSizeFixEnabled" value="true"/><property name="maximumRowsPerSheet" value="65000"/><property name="xlsFormatPatternsMap" ref="formatPatternsMap"/>

[ernestoo]

The product ships with XLS headers removed

 

Check webapps/jasperserver4-ce/WEB-INF/classes/jasperreports.properties - see under the comment:

#suppress page and column headers and footers when exporting to XLS

 

[hectormabilangan]

It works! Thanks ernestoo!