How to display the report exported output to single excel sheet ?
Posted on April 17, 2018 at 6:09am
I have created the report in jaspersoft studio after that i have export that report in xlsx sheet it will show the report output but it will show some gap inside after few records. I want to show the whole output in single excel sheet with proper view witout any space between records.
Posted on April 17, 2018 at 6:43am
Try to set the following properties in your report:
<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>