How do I call an Excel macro from Python using xlwings?

by

This is not implemented yet, but there’s an open issue for it, see here. In the meantime, you can work around it like so (this is for Windows, but the Mac version works accordingly, see again in the issue): 

from xlwings import Workbook
wb = Workbook(...)
wb.application.xl_app.Run("your_macro")

update: for more recent versions, you have to do:

from xlwings import Workbook, Application
wb = Workbook(...)
Application(wb).xl_app.Run("your_macro")

update 2: This functionality is now natively supported from >=v0.7.1. Let’s assume, there is a VBA function YourMacro that sums up two numbers:

>>> import xlwings as xw
>>> wb = xw.Book(r'C:\path\to\mybook.xlsm')
>>> your_macro = wb.macro('YourMacro')
>>> your_macro(1, 2)
3.0

More Related Contents:

  1. How to call python script on excel vba?
  2. Running an Excel macro via Python?
  3. Calling python script from excel/vba
  4. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  5. Use Python to Inject Macros into Spreadsheets
  6. Excel, How to split cells by comma delimiter into new cells
  7. Python convert csv to xlsx
  8. Pandas cannot open an Excel (.xlsx) file
  9. How can I open an Excel file in Python?
  10. How to convert a python datetime.datetime to excel serial date number
  11. xls to csv converter
  12. Return result from Python to Vba
  13. How to concatenate three excels files xlsx using python?
  14. Get formula from Excel cell with python xlrd
  15. Error: Unsupported format, or corrupt file: Expected BOF record
  16. pandas xlsxwriter, format table header – not sheet header
  17. Refresh Excel External Data with Python
  18. How can I see the formulas of an excel spreadsheet in pandas / python?
  19. Print chosen worksheets in excel files to pdf in python
  20. Python: Open Excel Workbook using Win32 COM Api
  21. how to write to a new cell in python using openpyxl
  22. From password-protected Excel file to pandas DataFrame
  23. Leave dates as strings using read_excel function from pandas in python
  24. Adjust cell width in Excel
  25. Get Excel-Style Column Names from Column Number
  26. Edit existing excel workbooks and sheets with xlrd and xlwt
  27. Pandas: parse merged header columns from Excel
  28. django excel xlwt
  29. Automation Excel from Python
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment