Can i create a password protected excel sheet using jasper?

[megha.meghapv]

I have tried the below properties as well. But its not working accordingly.

 

"net.sf.jasperreports.export.xls.password"  value: "test"

net.sf.jasperreports.export.xls.cell.locked=true

 

Thanks in advance

Megha

 

[reportdev]

please check this post. it has already been answered

https://community.jaspersoft.com/questions/852006/locking-protecting-cell-or-column-jaspersoft-studio

[megha.meghapv]

Hi ,

Thank you for the reply.

I tried this as well, But the problem is when i open the excel sheet it displays the data in it.

My requirement is that, the user should not be able to view the data when he opens the excel.

As soon as it is opened, it should prompt for a password and only on entering the password, the user should be able to view the contents in it.

 

Thanks and Best Regards,

Megha

 

[reportdev]

You need encryption for the excel in order to perform that functionality. 

As far as I know, Excel encryption is not possible through Jasper. 

PDF encryption is possible in Jasper, check that out if your requirement is not strict. 

http://jasperreports.sourceforge.net/config.reference.html

 

 

[hozawa]

JasperReports by default does not support encrypted xlsx file but since JasperReports is using Apache POI to generate xlsx file and the version of Apache POI now used in JasperReports does support generating encrypted xlsx file, it is possible to customize JasperReports library to support it.

[megha.meghapv]

Hi ,

Thank you for the reply.

I just wanted to know how to customise the jasper reports library to support this. That means i need to create a jar file?

Thanks and Best Regards,

Megha