Export data to password-protected xls

Jurre

Hi!

Does DSS have an option for setting a password on a newly generated xls-file when exporting data ? A general password that is, needed for opening that file.

If a pythonscript is the way to handle this, what would be the preferred library for that ?

Thanks in advance for any thoughts on this!

Jurre

ATsao

Hi Jurre,

It's not currently possible to export a password protected excel file in DSS currently. I will go ahead and capture this feedback for further review by our product team though.

In terms of which library to use, we don't have any specific recommendation as this is more of a python specific exercise. From doing a quick search online, you may want to be looking into using openpyxl (but anything that works in python outside of DSS should also work for python inside of DSS):
https://openpyxl.readthedocs.io/en/stable/protection.html
https://stackoverflow.com/questions/53128388/openpyxl-password-protect-entire-excel-file-xlsx

Thanks,
Andrew

Jurre

Thanks for your reply @ATsao
!

For me it would be a nice and impactful feature to have, possibly combined with an adjustable password-generator. But my usage of DSS is not really typical so if it's worth valuable developer-time is something for you to decide.

Happy with your comments on how to proceed with python, so i'm helped anyhow.

apichery

This feature is available natively in DSS starting with release 13.2.0

Jurre

Great, i look forward to 13.2. Thanx for the effort!