+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Reading data from password protected excel (/thread-9360.html)
Reading data from password protected excel - Anirudh_Avantsa - Apr-04-2018
Hello All,
Can you all suggest if we can read the data from password protected excel into a dataframe.
Appreciate your help in advance!
Regards,
Anirudh
RE: Reading data from password protected excel - sparkz_alot - Apr-04-2018
Get the password or remove the protection?
RE: Reading data from password protected excel - nilamo - Apr-04-2018
Absolutely yes you can. Just pass the
Password parameter to the excel opener when opening the file.Here's the docs on using it with the openpyxl module: http://openpyxl.readthedocs.io/en/stable/protection.html
Or, if you're using win32com to dispatch Excel directly, then, https://msdn.microsoft.com/en-us/VBA/Excel-VBA/articles/workbooks-open-method-excel