python - pyvot : can I run Excel VBA macros from python script?

Question

假设我已经使用以下代码在report对象中加载了Report WW26blueprint_with_chart_330.xlsm(这里使用print.range来测试工作簿已加载):

import xl
report = xl.Workbook("Report WW26blueprint_with_chart_330.xlsm")
print report
print(report.range("A1:E50").get())

来自pyvot documentation我明白了:

Pyvot is written on top of Excel’s COM API. You can always get the underlying COM object and make COM calls yourself

我的 Excel 文件包含以下宏:

Macro1 
Масго2 
Macro7  

我可以使用 python/pyvot 直接从 python 脚本运行上述任何宏吗？

Answer 1

这对我来说是这样:

report.xlWorkbook.Application.Run('Macro1')