Python怎么实现修改Excel文件的元数据

hello2023-04-18T10:00:00Z2023-04-17T10:00:00Zmuskchatgpt我是一个测试文档python测试这是一个运用销售给到用户的应用。

import osimport wxfrom openpyxl import load_workbook# from openpyxl import __version__ as openpyxl_version# from openpyxl import DocumentProperties class PropertyEditor(wx.Frame):    def __init__(self, parent, title):        super(PropertyEditor, self).__init__(parent, title=title, size=(500, 400))         # 创建GUI界面        panel = wx.Panel(self)         author_label = wx.StaticText(panel, label="作者:")        self.author_text = wx.TextCtrl(panel)         created_label = wx.StaticText(panel, label="创建时间:")        self.created_text = wx.TextCtrl(panel)         modified_label = wx.StaticText(panel, label="修改时间:")        self.modified_text = wx.TextCtrl(panel)         last_saved_by_label = wx.StaticText(panel, label="最后一次保存者:")        self.last_saved_by_text = wx.TextCtrl(panel)         computer_label = wx.StaticText(panel, label="计算机:")        self.computer_text = wx.TextCtrl(panel)         title_label = wx.StaticText(panel, label="标题:")        self.title_text = wx.TextCtrl(panel)         subject_label = wx.StaticText(panel, label="主题:")        self.subject_text = wx.TextCtrl(panel)         description_label = wx.StaticText(panel, label="描述:")        self.description_text = wx.TextCtrl(panel, style=wx.TE_MULTILINE)         save_button = wx.Button(panel, label="保存")        save_button.Bind(wx.EVT_BUTTON, self.on_save)         # 添加到Sizer中        sizer = wx.BoxSizer(wx.VERTICAL)        sizer.Add(author_label, flag=wx.ALL, border=5)        sizer.Add(self.author_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(created_label, flag=wx.ALL, border=5)        sizer.Add(self.created_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(modified_label, flag=wx.ALL, border=5)        sizer.Add(self.modified_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(last_saved_by_label, flag=wx.ALL, border=5)        sizer.Add(self.last_saved_by_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(computer_label, flag=wx.ALL, border=5)        sizer.Add(self.computer_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(title_label, flag=wx.ALL, border=5)        sizer.Add(self.title_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(subject_label, flag=wx.ALL, border=5)        sizer.Add(self.subject_text, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(description_label, flag=wx.ALL, border=5)        sizer.Add(self.description_text, proportion=1, flag=wx.EXPAND|wx.ALL, border=5)        sizer.Add(save_button, flag=wx.ALL|wx.CENTER, border=10)         panel.SetSizer(sizer)     def on_save(self, event):        dlg = wx.FileDialog(self, "选择要修改属性的Excel文件", "", "", "*.xlsx", wx.FD_OPEN)        if dlg.ShowModal() == wx.ID_OK:            file_path = dlg.GetPath()             try:                wb = load_workbook(filename=file_path)                 # 修改属性                properties = wb.properties                properties.creator = self.author_text.GetValue()                properties.created = self.created_text.GetValue()                properties.modified = self.modified_text.GetValue()                properties.lastModifiedBy = self.last_saved_by_text.GetValue()                properties.computer = self.computer_text.GetValue()                properties.title = self.title_text.GetValue()                properties.subject = self.subject_text.GetValue()                properties.description = self.description_text.GetValue()                 wb.save(file_path)                wx.MessageBox("属性已成功保存!", "提示", wx.OK|wx.ICON_INFORMATION)             except Exception as e:                wx.MessageBox("修改属性时出错: {}".format(str(e)), "错误", wx.OK|wx.ICON_ERROR)         dlg.Destroy() if __name__ == '__main__':    app = wx.App()    frame = PropertyEditor(None, title="修改Excel文件属性")    frame.Show()    app.MainLoop()