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.
Joined: Mar 23 2017 - 12:11am
Last seen: 3 years 2 weeks ago
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"/>
Joined: Sep 26 2006 - 8:06pm
Last seen: 9 months 2 weeks ago
