python 可以添加、运行和删除 VBA 宏到 excel 而无需中间保存步骤吗

使用Python在Excel中添加、运行和删除VBA宏

python
pip install pywin32

python
import win32com.client as win32
def add_vba_macro_to_excel(filename, macro_name, vba_code):
    excel = win32.gencache.EnsureDispatch('Excel.Application')
    wb = excel.Workbooks.Open(filename)
    vbproject = wb.VBProject
    module = vbproject.VBComponents.Add(1)
    module.CodeModule.AddFromString(vba_code)
    wb.Save()
    wb.Close()
    excel.Quit()
# 示例代码
filename = "path_to_excel_file.xlsm"
macro_name = "MyMacro"
vba_code = '''
Sub MyMacro()
    MsgBox "Hello, World!"
End Sub
'''
add_vba_macro_to_excel(filename, macro_name, vba_code)

python
import win32com.client as win32
def run_vba_macro_in_excel(filename, macro_name):
    excel = win32.gencache.EnsureDispatch('Excel.Application')
    wb = excel.Workbooks.Open(filename)
    excel.Run(macro_name)
    wb.Close()
    excel.Quit()
# 示例代码
filename = "path_to_excel_file.xlsm"
macro_name = "MyMacro"
run_vba_macro_in_excel(filename, macro_name)

python
import win32com.client as win32
def remove_vba_macro_from_excel(filename, macro_name):
    excel = win32.gencache.EnsureDispatch('Excel.Application')
    wb = excel.Workbooks.Open(filename)
    vbproject = wb.VBProject
    vbcomponent = vbproject.VBComponents.Item(macro_name)
    vbproject.VBComponents.Remove(vbcomponent)
    wb.Save()
    wb.Close()
    excel.Quit()
# 示例代码
filename = "path_to_excel_file.xlsm"
macro_name = "MyMacro"
remove_vba_macro_from_excel(filename, macro_name)