1、代码效果
1.1 源数据
1.2 json字符串结构
2、python代码
import win32com.client
import xlwings as xw
import json
import os
from win32com.client import Dispatch
def if_excel_file_is_open(path):
xlApp = Dispatch('Excel.Application')
xlApp.DisplayAlerts = False
bookCount = xlApp.Workbooks.Count
print(f'已打开工作簿的数量为:{
bookCount}个')
if bookCount > 0:
for i in range(1, bookCount + 1):
filePath = xlApp.Workbooks(i).Path + "\\" + xlApp.Workbooks(i).Name
print(f'第{
i}个excel的文件路径为:{
filePath}')
if filePath== path:
xlApp.Workbooks(i).Save()
xlApp.Workbooks(i).Close()
break
del xlApp
excel_path=os.path.join(os.getcwd(),r'Book3.xlsm')
if_excel_file_is_open(excel_path)
app = xw.App(visible = False , add_book = False)
wb = app.books.open(excel_path)