How to display the report exported output to single excel sheet ?

0

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.

gopalmehakare's picture
Joined: Mar 23 2017 - 12:11am
Last seen: 1 month 1 week ago

1 Answer:

0

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"/>
shertage's picture
1950
Joined: Sep 26 2006 - 8:06pm
Last seen: 2 days 15 hours ago
Feedback