# 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.
- [Quick Start](quickstart.md): xlwings Lite is an Excel add-in that you install from the Office add-in store. It’s free for persona... - [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... - [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... - [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... - [Editor](editor.md): xlwings Lite uses the same editor as VS Code. This means that many of its familiar features are avai... - [Files](files.md): xlwings Lite allows you to work with local files in two ways: - [Dependencies](dependencies.md): This document describes how to install, uninstall, and update Python packages. Since xlwings Lite ru... - [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... - [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: - [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) - [Limitations](limitations.md): xlwings Lite is based on [Pyodide](https://pyodide.org), and comes with the following limitations: - [Security](security.md): xlwings Lite runs Python code inside the browser’s sandbox, so unlike VBA macros, it has no direct a... - [About](about.md): xlwings Lite is built on the strong foundation of xlwings, the open-source Python package. Establish... - [Changelog](changelog.md): - Custom functions can now access the calling cell by adding an argument with the `xw.Caller` type h... - [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 ... - [Hosting Solutions](hosting-solutions.md): xlwings Lite runs on any platform capable of running a Docker image. This includes Linux VMs, Kubern... - [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... --- For more comprehensive documentation, see [llms-full.txt](llms-full.txt)