how to export "excel compatible" CSV from jasperserver

Posted on October 6, 2015 at 6:28am

Hi,

I'm trying to export a report as CSV that should be openable in Excel.

Right now, excel requires the byte order mark (BOM) to be written in order to recognize UTF-8 files.

I tried using the property net.sf.jasperreports.export.csv.write.bom described here. It works when I do the export from jaspersoft studio but seems to be ignored when I do it from the server. Am I missing something? Is there another point where this should be changed?

Thanks,

Florent

 

Edit to precise: We are using 6.0.1 as 6.1.0 has a blocking bug and we couldn't test 6.1.1 yet. Is this issue really resolved on 6.1?

JasperReports® Server
florent.j's picture
florent.j
118
Joined: Feb 13 2013 - 6:39am
Last seen: 4 years 11 months ago

1 Answer:

Posted on October 6, 2015 at 6:14pm

I just made the modification to WEB-INF/classes/jasperreports.properties and restarted the system. Also, check JasperReports Server version to make sure it's 6.1.0 or above.

hozawa's picture
hozawa
190715
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
Feedback
randomness