使用win32com的Python不会使用所需的加载项更新excel工作表

import win32com.client as win32

excel = win32.gencache.EnsureDispatch('Excel.Application')
workbook = excel.Workbooks.Open('path_to_your_excel_file.xlsx')

worksheet = workbook.Worksheets('Sheet1')

worksheet.Update()

workbook.Save()
workbook.Close()

import win32com.client as win32

excel = win32.gencache.EnsureDispatch('Excel.Application')
workbook = excel.Workbooks.Open('path_to_your_excel_file.xlsx')
worksheet = workbook.Worksheets('Sheet1')

worksheet.Update()

workbook.Save()
workbook.Close()