xlwings 调用vba
时间: 2023-09-25 09:09:17 浏览: 70
xlwings 是一个 Python 库,可以与 Excel 进行交互。要使用 xlwings 调用 VBA,首先需要在 Python 代码中导入 xlwings:
import xlwings as xw
然后,可以使用 xw.Book 函数打开 Excel 文件:
vba_book = xw.Book(r"test.xlsm")
接下来,可以使用 vba_book.macro 函数调用 VBA 宏:
marco1 = vba_book.macro("模块1.宏1")
最后,通过调用 marco1 函数执行该 VBA 宏:
marco1()
这样就可以使用 xlwings 调用 VBA 了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Python xlwings操作Excel(摸鱼划水必备技能)——(2)python xlwings与VBA间的互相调用](https://blog.csdn.net/m0_59160272/article/details/125948932)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [利用xlwings直接调用Excel的xlsm文件中的宏vba](https://blog.csdn.net/woaidianqian/article/details/115711521)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]