Protect xls document

[jmbernal]

How can I configure IReports 1.2.4 to generate a xls File protected against content alterations?

Now, I'm generating the xls document, but user can write on it, and I don't like it.

[jmbernal]

Nobody knows how to do this???

 

I suposse it can't be very difficult, but I have no idea..... Help, help....:(

[marianol]

I have not used JR 1.x but in the 4.x versions you can set the following property:

xlsExporter.setParameter(JRXlsExporterParameter.PASSWORD, "MyPassword");

to protect the spreadsheet, I'm pretty sure that this property was added in v3

 

The property is only available in xml mode and not supported by iReport GUI
To include the password protection you have to go to XML mode and add the following to your JRXML file:

<property name="net.sf.jasperreports.export.xls.password" value="MyPassword"/>

Mariano