We use xlwings to automate the data feeds of one of our analytical spreadsheet tools, which saves us 1–2 days of tedious manual work every month. Data sources include REST APIs, CSV files via …

This is a description of all the classes, methods, properties and functions that xlwings offers to work with the Excel object model.

To make this run, you’ll need to have the xlwings add-in installed or have the workbooks setup in the standalone mode. The easiest way to get everything set up is to use the xlwings command line client …

To uninstall xlwings completely, first uninstall the add-in, then uninstall the xlwings package using the same method (pip or conda) that you used for installing it:

xlwings allows you to write Python scripts to automate Excel on Windows and macOS. For this functionality, you don’t need to install any Excel add-in. Work with the whole data science universe, …

The xlwings add-in is the preferred way to be able to use the Run main button, RunPython or UDFs. Note that you don’t need an add-in if you just want to manipulate Excel by running a Python script.

xlwings Lite brings the VBA experience into the modern age by offering a privacy-first, secure, and developer-friendly way to automate Excel and write custom functions with Python.

xlwings Lite is now available in the add-in store for free!

xlwings Lite allows you to install a wide range of popular packages that are not supported with Python in Excel. A few examples include polars, xgboost, duckdb, cvxpy, geopandas, etc.

While xlwings Lite custom functions are mostly compatible with the VBA-based UDFs from classic xlwings, there are a few differences, which you should be aware of when switching from UDFs to …