One extra blank row in excel report

[amitksingh]

Hi,

I am using Jasper Report 3.1.4 for excel/pdf report generation in my web application.

In one of the excel reports, I am getting one extra blank row. I have attached the generated report. In the report, two rows (2140 and 2141 are mergedd into one row). If I delete the row 2141, the report looks fine. So I assume that row 2141 is the blank row.

In the java class, I am setting the JExcelApiExporter parameter as

exporter.setParameter(JRxlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

but even then I am getting the empty row.
 

I have attached the jrxml file along with the excel report for reference.

 

[kusi]

 

After doing the following it was working for me properly (no more empty rows in excel export):

1) Set param as mentioned before: exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

 

2) Making the heigh of all fields exactly the same as the band they are located on

 

3) Setting the property "Stretch Type" for all fields on the band to the value "Relative to Band Height" for all fields on the band.