Exporting my Report to Excel

Hi everyone!

I've benn trying to save my report to excel but when I do the layout gets all messy and some things that are displayed in the ReportViewer just isn't in the excel file, for exemple, some frames...

I'll post both images so you can see what I'm talking about. The first one is the  report on the ReportViewer and the second one is on the Excel file.


So far, so good...

I don't know if this happens because of the layout or I didn't configure something (or did it wrong). 

I hope you can help me!



escalhao3's picture
Joined: Apr 2 2014 - 9:29am
Last seen: 7 years 2 months ago

3 Answers:

Try  net.sf.jasperreports.export.xls.remove.empty.space.between.columns ; this will clean up some of the mess. Refer here for more details, that and google will get you through: http://jasperreports.sourceforge.net/config.reference.html

Also, you need to line up your column witdths in the jrxml as much as possible. See how you've got different widths between POD summary and VESSEL summary? 

darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 1 week 2 days ago



There is nothing wrong with your excel output just you need to take care of little bit of formatting. Just try to make the size of all the columns so that the overlapping is no more there.



honeybakliwal's picture
Joined: Sep 8 2010 - 2:37am
Last seen: 4 years 7 months ago

Add this property in your XML code.

<property name="net.sf.jasperreports.export.xls.show.gridlines" value="true"/>

jaspersoft123's picture
Joined: Sep 24 2014 - 12:15am
Last seen: 4 years 7 months ago