Collecting excel file properties using Python 2

Question

I'd like to collect some information about the properties for an excel file, such as:

The Author, Last saved and Last printed.

Here is the code I used to get access time, modified time, change time and size. print('Access time :', time.ctime(os.path.getatime(file)))

print('Modified time:', time.ctime(os.path.getmtime(__file__)))

print('Change time  :', time.ctime(os.path.getctime(__file__)))

print('Size         :', os.path.getsize(__file__))

information like: author, last saved, last printed

I was looking through these but nothing helpful: https://docs.python.org/2/library/os.path.html

I have the difference between the original date and time of creation/modification (originally) and the date/time of download.

andilabs · Accepted Answer · 2018-03-11 13:52:43Z

1

what about (after pip install openpyxl):

from openpyxl import load_workbook
wb = load_workbook('foo.xlsx')
wb.properties

Parameters: creator='openpyxl', title=None, description=None, subject=None, identifier=None, language=None, created=datetime.datetime(2018, 3, 11, 14, 47, 30, 624845), modified=datetime.datetime(2018, 3, 11, 14, 47, 30, 624851), lastModifiedBy=None, category=None, contentStatus=None, version=None, revision=None, keywords=None, lastPrinted=None

answered Mar 11, 2018 at 13:52

andilabs

23.5k14 gold badges126 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

András P. Over a year ago

openpyxl is working only with .xlsx format and I need those properties for .xls format.

Collectives™ on Stack Overflow

Collecting excel file properties using Python 2

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related