Python Forum
Reading data from password protected excel
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reading data from password protected excel
#1
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
Reply
#2
Get the password or remove the protection?
If it ain't broke, I just haven't gotten to it yet.
OS: Windows 10, openSuse 42.3, freeBSD 11, Raspian "Stretch"
Python 3.6.5, IDE: PyCharm 2018 Community Edition
Reply
#3
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  trouble reading string/module from excel as a list popular_dog 0 386 Oct-04-2023, 01:07 PM
Last Post: popular_dog
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 1,926 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,048 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,802 Dec-12-2022, 08:22 PM
Last Post: jh67
  Excel file reading problem max70990 1 866 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,620 Dec-01-2022, 01:52 PM
Last Post: deanhystad
  Reading All The RAW Data Inside a PDF NBAComputerMan 4 1,276 Nov-30-2022, 10:54 PM
Last Post: Larz60+
  Appending a row of data in an MS Excel file azizrasul 3 1,139 Nov-06-2022, 05:17 PM
Last Post: azizrasul
  Moving data from one Excel to another and finding maximum profit azizrasul 7 1,412 Oct-06-2022, 06:13 PM
Last Post: azizrasul
  Reading Data from JSON tpolim008 2 1,032 Sep-27-2022, 06:34 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020