python运行excel宏_从python运行excel宏

我正在使用以下代码从Python运行Excel宏：

import pymysql

import datetime

import csv

import math

import os

import glob

import sys

import win32com.client

import numpy

from tkinter import *

from tkinter import ttk

import tkinter.messagebox

def run_macro():

print('macro')

#this if is here because if an executable is created, __file__ doesn't work

if getattr(sys, 'frozen', False):

name = (os.path.dirname(sys.executable) + '\\Forecast template.xlsm')

else:

name = str(os.path.dirname(os.path.realpath(__file__)) + '\\Forecast template.xlsm')

print(name)

#this part runs the macro from excel

if os.path.exists(name):

xl=win32com.client.Dispatch("Excel.Application")

xl.Workbooks.Open(Filename=