-
Notifications
You must be signed in to change notification settings - Fork 0
/
utils_excel.py
30 lines (27 loc) · 1018 Bytes
/
utils_excel.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
import openpyxl
def get_excel_info(path):
"""This will return the doc info infomation from the
Named file."""
data = {}
try:
doc = openpyxl.load_workbook(path)
# get the core properties from the file...
# https://python-docx.readthedocs.io/en/latest/api/document.html#coreproperties-objects
cp = doc.properties
data['author'] = cp.creator
data['category'] = cp.category
data['comments'] = cp.description
data['created'] = cp.created
data['identifier'] = cp.identifier
data['keywords'] = cp.keywords
data['language'] = cp.language
data['last_modified_by'] = cp.lastModifiedBy
data['last_printed'] = cp.lastPrinted
data['modified'] = cp.modified
data['revision'] = cp.revision
data['subject'] = cp.subject
data['title'] = cp.title
data['version'] = cp.version
except Exception as ex:
print("ERROR: {}\n\t>>>{}".format(path,ex))
return data