Python Forum
Advance properties read from xml files
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Advance properties read from xml files
#1
Hi All,

I am able to read the properties of workbooks using below code.

from openpyxl import Workbook
from openpyxl import load_workbook
wb = load_workbook('sample.xlsx')        
wb.properties
print (wb.properties)

# sample.xlsx is my file and I can able to read the properties of this xml file as below .

creator=u'Sri Ram', title=u'Sample', description=None, subject=None, identifier=None, language=None, created=datetime.datetime(2018
, 4, 24, 14, 40, 32), modified=datetime.datetime(2018, 4, 25, 5, 39, 15), lastModifiedBy=u'Ram rao', category=u'Finance', contentS
tatus=None, version=None, revision=None, keywords=u'HSBC', lastPrinted=None
# But my requirement is I want to read the advanced properties of the same file .

Can any one help me on the code how we can read the advaced properties of the file details.

Note :
1) If we have excel sheet name Sample .
2)Clicked on Info it will show the properties ( I am able to read with above code)
3) click on Properties drop down will see the Advanced propeties
4)if we click on Advanced properties window will popup Sample properties window.
5) if we click on custom tab we have some property values like Name , vale and Type( I want to read these values through python code)

Please help on this python code to read these values

Regards,
SP
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  PDF properties doesn't show created or modified date Pedroski55 4 1,114 Jun-19-2023, 08:09 AM
Last Post: Pedroski55
  code won't advance to next statement MCL169 2 767 Apr-11-2023, 09:44 PM
Last Post: Larz60+
  How to read in mulitple files efficiently garynewport 3 903 Jan-27-2023, 10:44 AM
Last Post: DeaD_EyE
  Read directory listing of files and parse out the highest number? cubangt 5 2,411 Sep-28-2022, 10:15 PM
Last Post: Larz60+
  How do I list properties quarinteen 0 1,070 May-01-2022, 04:15 PM
Last Post: quarinteen
  Python code to read second line from CSV files and create a master CSV file sh1704 1 2,427 Feb-13-2022, 07:13 PM
Last Post: menator01
  Open and read multiple text files and match words kozaizsvemira 3 6,785 Jul-07-2021, 11:27 AM
Last Post: Larz60+
  code to read files in folders and transfer the file name, type, date created to excel Divya577 0 1,873 Dec-06-2020, 04:14 PM
Last Post: Divya577
  How to read csv files parallay Mekala 2 2,012 Oct-24-2020, 07:33 AM
Last Post: Mekala
  API design question: use methods or properties? johsmi96 1 1,692 Oct-12-2020, 02:24 PM
Last Post: buran

Forum Jump:

User Panel Messages

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