且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用Python编辑.xlsx文件的核心属性?

更新时间: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")