Exporting my Report to Excel
Posted on September 22, 2014 at 9:11am
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!
Regards,
Felipe
Joined: Apr 2 2014 - 9:29am
Last seen: 5 years 1 month ago
Posted on September 22, 2014 at 10:06am
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?
Joined: Mar 7 2010 - 9:45pm
Last seen: 5 days 8 hours ago
Posted on September 22, 2014 at 11:55pm
Hi
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.
Thanks
Honey
Joined: Sep 8 2010 - 2:37am
Last seen: 2 years 6 months ago
Posted on September 24, 2014 at 12:31am
Add this property in your XML code.
<property name="net.sf.jasperreports.export.xls.show.gridlines" value="true"/>
Joined: Sep 24 2014 - 12:15am
Last seen: 2 years 6 months ago