更新时间:2023-01-18 17:51:31
尝试使用 openpyxl
模块以交互方式获取和设置属性.
Try openpyxl
module to get and set properties interatively.
import openpyxl
fh = openpyxl.load_workbook("results.xlsx")
obj = fh.properties #To get old properties
print obj # print old properties
fh.properties.title = "newTitle" # To set title
fh.properties.category = "newCategory" # To set category
fh.properties.subject = "newSubject" # To set subject
##similarly you can set other fields ##
new_obj = fh.properties #Now get new properties
print new_obj # print new properties
fh.save("results.xlsx")