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
Best Answer
-
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
Answers
-
Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 114 ✭✭✭✭✭✭✭Options
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.