Xlwings Lite – Python in Excel Using Pyodide
a year ago
- #Productivity tools
- #Excel automation
- #Python
- xlwings Lite is a privacy-first, secure, and developer-friendly tool for automating Excel and writing custom functions with Python.
- Free and easy to install from the Office add-in store, with no registration required.
- Cross-platform compatibility with Windows, macOS, Excel for the web, Microsoft 365, and Office 2024.
- No need for a local Python installation; runs via WebAssembly (Pyodide) in the browser.
- Python code is stored inside the workbook, requiring only the xlwings Lite add-in to run.
- Supports custom functions (UDFs), automation scripts, and access to the Excel object model.
- Allows installation of Python packages like pandas, Polars, DuckDB, and custom packages.
- Can fetch data from CORS-supported APIs and runs locally for fast performance.
- Fully local and private, with optional self-hosting for maximum security.
- Features a VS Code-like editor with familiar keyboard shortcuts for efficiency.
- Works offline after the initial add-in load.