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, …

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 …

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 …

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 …

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 …