Problem with single page lengthy XLS report

[psoma.cse]

Hi Everyone,

I have a report that needs to be exported to xls format in a single page. Through iReport, I'm able to generate a continuous xls report(with no empty lines between).

But the problem is that the same report comes bad when generated through the application. Many empty lines appear randomly after some set of rows throughout the report. Infact the number of empty lines increases as we go down the report. Please give me some suggestions for this issue.

 

Note:

I have set the foll. parameters in the code:

1. JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE

2.

JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,

Boolean.TRUE

 

Thank you very much for your time!

 

-Somu