can I open password-protected excel file using openpyxl lib in python?

[manavp...@gmail.com]

I have many password-protected excel workbooks and I want to open it with openpyxl and modify it. Is it possible. If yes, can you please tell me how?

Please reply asap as I need this very urgently.

Thanks in advance

[Thomas Nygårds]

I think it is just to open them as usual, but I might be wrong...
If they are encrypted in some way then you cannot open them.

Regards
Thomas

[manavp...@gmail.com]

It isn't opening by using openpyxl method. Is there any way I can pass password while opening it via openpyxl?

[Thomas Nygårds]

According to what I understand from Charlie I do not think so. See his comment here:
https://groups.google.com/d/msg/openpyxl-users/o5-MYWnL0OI/eAzOFjEU-qQJ

[manavp...@gmail.com]

Thanks for the reply.. I can set password to an excel file which I modified or created by using openpyxl but my question is how to open a password protected file using openpyxl?

[Charlie Clark]

Am .08.2016, 10:24 Uhr, schrieb <manavp...@gmail.com>:

> Thanks for the reply.. I can set password to an excel file which I
> modified
> or created by using openpyxl but my question is how to open a password
> protected file using openpyxl?

https://stackoverflow.com/questions/39143620/can-i-open-password-protected-excel-file-using-openpyxl-lib-in-python

Duplicate question with a duplicate answer.

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

[cheerag...@gmail.com]

hey manvp did you find anything on this?