1. def update_content(url): #打开word，执行宏命令
2.     ret = ""
3.     docApp = win32com.client.DispatchEx('Word.Application')
4.     try:
5.         doc = docApp.Documents.Open(url)
6.         #print("打开文档")
7.         doc.Application.Run('exportWordComments_Click')
8.         #print("执行宏完成")
9.         doc.Save()
10.         ret = url + " 处理成功"
11.     except Exception as e:
12.         print(e + ", 执行失败")
13.         ret = url + " 处理失败"
14.     docApp.Quit()
15.     return ret
16. pass

1.     output = excel_name #"D:\MyWork\python\get_comments_v2\log\Date_20220602_173646.xlsx"
2.     workbook = xw.Workbook(output)
3.     worksheet1 = workbook.add_worksheet("sheet1")
4.     worksheet1.activate()
5.     title = ['文件名', 
6.              '批注内容', 
7.              '原文', 
8.              '是否解决', 
9.              '批注者', 
10.              '页', 
11.              '行', 
12.              '日期', 
13.              '文件路径']
14.     bold = workbook.add_format({
15.         'bold':  True,  # 字体加粗
16.         'border': 1,  # 单元格边框宽度
17.         'align': 'left',  # 水平对齐方式
18.         'valign': 'vcenter',  # 垂直对齐方式
19.         'fg_color': '#F4B084',  # 单元格背景颜色
20.         'text_wrap': True,  # 是否自动换行
21.     })
22.     worksheet1.write_row('A1', title, bold)

1.     def open_xlsx():
2.         already_open = 0
3.         xl_app = win32com.client.DispatchEx("Excel.Application")
4.         xl_app.Visible = 1
5.         for wb in xl_app.Workbooks:
6.             if(wb.Name == excel_name): #wb.Name只返回文件的名字，不包含路径
7.                 already_open = 1
8.                 break
9.         if(already_open==0):#需要新打开文件
10.             my_wb = xl_app.Workbooks.Open(excel_name)
11.     pass

1.     def thread_open_xlsx():
2.         t2 = threading.Thread(target=open_xlsx,args=())
3.         t2.start()
4.     pass
5. 
6.     button2 = Button(f3, text='开始检查', command=thread_start_check)