Password protected excel export

0
Hello All, As I am extracting data from the application using excel Exporter module. As this data is confidential, I am looking for option to make this excel password protected. Has anyone come across this scenario?   Thanks and Regards, Nirmal Kumar
asked
1 answers
0

Creating a password protected excel is not possible with the standard exporter module.

As the module is using apache poi to create the files, reading this thread on stack overflow might help in finding a solution:

https://stackoverflow.com/questions/8817290/create-a-password-protected-excel-file-using-apache-poi

This will not really help you to protect your data from reading, it only protects data being changed.

Have a look at this site to understand the options that poi offers for encryption:

https://poi.apache.org/encryption.html

This will require some changes/ additions to the java code used by the excel exporter though.

answered