python调用excel中的vba_如何在python中触发excel中的vba宏

import xlwings as xw

import time

from utils import ConvertToFloatList, load_data

import pythoncom

import win32gui

import win32api

import win32con

def all_in_one(x_data, y_data):pythoncom.CoInitialize()

app = xw.App(visible=True, add_book=False)

app.display_alerts = False

app.screen_updating = False

file_path = r'G:\BOE\数据采集\BMTP\55\55_DEMO.xlsm'

wb = app.books.open(file_path)

sheet_demo = wb.sheets['demo']

sheet_demo.range('L5').options(transpose=True).value = x_data

sheet_demo.range('N5').options(transpose=True).value = y_data

offset = sheet_demo.range('X5:Z76').options(transpose=True).value

offset_x = list(set(offset[0]))

offset_x.sort(key=offset[0].index)

offset_x = ConvertT