python刷新Excel模型数据源

#导入库
import pandas as pd
import numpy as np
import os,openpyxl


def refresh_data(file_path,sheet_name,data):
    book=openpyxl.load_workbook(file_path)
    writer=pd.ExcelWriter(file_path,engine="openpyxl")
    
    #在ExcelWriter的源代码中，它初始化空工作簿并删除所有工作表，
    #writer.book = book将原来表里面的内容保存到writer中
    writer.book=book
    
    #activate激活指定sheet工作表
    ws=book[sheet_name]
    
    #清空当前活动表数据
    for row in ws.iter_rows():
        for cell in row:
            cell.value=None
    
    #dataframe行列数
    idx_num,col_num=data.shape
    
    #新数据写入当前活动表-注意索引偏移
    #ws.append(line)会默认前面清除的地方有数据，从原数据位置下方开始追加
    for i in  range(1,idx_num+1):
        for j in range(1,col_num+1):
            ws.cell(row=i,column=j).value=data.iloc[i-1,j-1]
    
    #保存关闭writer
    writer.save()
    writer.close()
    
    return None

#导入库
import win32com.client
import os,time

def refresh(path):
    application=win32com.client.Dispatch("Excel.Application")#调用WIn中的COM
    workbook = application.Workbooks.Open(path)#打开工作簿
    application.Visible = True
#     application.ScreenUpdating = False #打开屏幕更新
    application.AskToUpdateLinks = False
    workbook.RefreshAll()
#   刷新完成后继续执行
    application.AskToUpdateLinks = True 
    workbook.Save()
    workbook.Close(True)
    application.Quit()