Python Forum

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

Get the password or remove the protection?

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...ction.html
Or, if you're using win32com to dispatch Excel directly, then, https://msdn.microsoft.com/en-us/VBA/Exc...thod-excel