Export data to password-protected xls

Solved!
Jurre
Level 5
Export data to password-protected xls

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

 

0 Kudos
1 Solution
ATsao
Dataiker

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

View solution in original post

2 Replies
ATsao
Dataiker

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
Level 5
Author

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. 

0 Kudos