# xlwings Lite

> Documentation for xlwings Lite, an Excel add-in for running Python, building custom functions, and automating workbooks.


Zoomer Analytics GmbH

## Pages

- [xlwings Lite](index.md): **xlwings Lite lets you automate Excel and build native custom functions in Python.<br>
- [Installation](installation.md): 1. Click on the `Add-ins` button in Excel. Usually, it is located on the `Home` tab, but if you are ...
- [Video Walkthrough](video.md): <iframe width="560" height="315" src="https://www.youtube.com/embed/amCCEbJ39W8?si=mCTVouJryiN20hpK"...
- [Custom Functions](custom_functions.md): This tutorial teaches you everything about custom functions. Some highlights:
- [Scripts](custom_scripts.md): Scripts are the equivalent to a `Sub` in VBA or an Office Script. They run at the click of a button ...
- [Notebooks](notebooks.md): xlwings notebooks work similar to a Jupyter notebook: you split your code into cells and run them in...
- [Async API](async-api.md): To interact with the Excel object model, scripts and notebooks let you use the same syntax as the cl...
- [Plotting](plotting.md): xlwings Lite lets you create plots with the usual Python plotting libraries and bring them into Exce...
- [App Mode](app_mode.md): App Mode turns the xlwings Lite task pane into an app for end-users by hiding the code editor and sh...
- [Dependencies](dependencies.md): This document describes how to install, uninstall, and update Python packages. Since xlwings Lite ru...
- [Files](files.md): xlwings Lite allows you to work with local files in two ways:
- [Editor](editor.md): xlwings Lite uses the same editor as VS Code. This means that many of its familiar features are avai...
- [Web API Requests](web_requests.md): xlwings Lite runs Python in the browser, which means that any API requests you make are subject to t...
- [Databases](databases.md): Direct connections with traditional SQL databases aren’t supported. Here’s what you can do about it:
- [Personal Modules](personal_modules.md): Personal modules are Python files and packages shared across all your workbooks, similar to VBA’s `P...
- [Environment Variables](environment_variables.md): xlwings Lite runs in the secure sandbox of a browser and therefore can’t access anything on your loc...
- [Testing with Pytest](tests.md): xlwings Lite has a built-in [pytest](https://docs.pytest.org) runner, allowing you to write automate...
- [Security](security.md): xlwings Lite runs Python code inside the browser’s sandbox, so unlike VBA macros, it has no direct a...
- [FAQ](faq.md): The easiest solution is to ask your Office admin to install xlwings Lite via Office 365 Admin Center...
- [Troubleshooting](troubleshooting.md): Most likely, you’re running into a CORS issue, see [Web API Requests](web_requests.md)
- [Excel Compatibility](compatibility.md): xlwings Lite is supported on the following platforms:
- [Limitations](limitations.md): xlwings Lite is based on [Pyodide](https://pyodide.org), and comes with the following limitations:
- [About](about.md): xlwings Lite is built on the strong foundation of xlwings, the open-source Python package. Establish...
- [License & Privacy](license.md): For the xlwings Lite add-in as provided via Excel’s add-in store, you’ll find the EULA and privacy s...
- [Changelog](changelog.md): - Custom functions can now access the calling cell by adding an argument with the `xw.Caller` type h...
- [xlwings Lite vs. Python in Excel](xlwingslite_vs_pythoninexcel.md): Python in Excel turns the Excel grid into a 2-dimensional Jupyter notebook, while xlwings Lite bring...
- [xlwings Lite vs. Anaconda Code](xlwingslite_vs_anacondacode.md): Both xlwings Lite and Anaconda Code use Pyodide, the Python distribution for WebAssembly. Anaconda C...
- [Overview](self-hosting.md): This page is the starting point for deploying xlwings Lite on your own infrastructure. Self-hosting ...
- [Configuration](configuration.md): xlwings Lite is configured via the following settings. You set them either as environment variables ...
- [Linux VM](linux-vm.md): This guide shows how to self-host xlwings Lite on a plain Linux VM using the `xlwings-lite` CLI.
- [Azure Container Apps](azure-container-apps.md): This guide shows how to deploy xlwings Lite to Azure Container Apps.
- [AWS ECS Express Mode](aws-ecs-express.md): 1. Go to the [ECS console](https://console.aws.amazon.com/ecs/v2) and select **Express mode** in the...
- [Azure Container Apps (Azure CLI)](azure_container_apps_cli.md): These Azure CLI commands are provided as a convenience and have not been fully verified end-to-end. ...
- [Clean Up Missing Add-in Refs](cleanup-missing-addin-refs.md): After uninstalling a separate installation of xlwings Lite (SH), existing workbooks might cause the ...
- [Migrating to self-hosted](migrating-to-self-hosted.md): If you are switching from the cloud add-in **xlwings Lite** to the self-hosted add-in **xlwings Lite...
- [Roadmap](roadmap.md): A few of the planned enhancements include (not in any specific order):

---

For more comprehensive documentation, see [llms-full.txt](llms-full.txt)