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,102 Jun-19-2023, 08:09 AM
Last Post: Pedroski55
  code won't advance to next statement MCL169 2 765 Apr-11-2023, 09:44 PM
Last Post: Larz60+
  How to read in mulitple files efficiently garynewport 3 899 Jan-27-2023, 10:44 AM
Last Post: DeaD_EyE
  Read directory listing of files and parse out the highest number? cubangt 5 2,379 Sep-28-2022, 10:15 PM
Last Post: Larz60+
  How do I list properties quarinteen 0 1,065 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,415 Feb-13-2022, 07:13 PM
Last Post: menator01
  Open and read multiple text files and match words kozaizsvemira 3 6,772 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,871 Dec-06-2020, 04:14 PM
Last Post: Divya577
  How to read csv files parallay Mekala 2 2,006 Oct-24-2020, 07:33 AM
Last Post: Mekala
  API design question: use methods or properties? johsmi96 1 1,687 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