top of page

๐‹๐ข๐ฏ๐ž ๐๐ฒ๐ญ๐ก๐จ๐ง-๐ข๐ง-๐„๐ฑ๐œ๐ž๐ฅ ๐ฌ๐ฒ๐ฌ๐ญ๐ž๐ฆ๐ฌโ€Š-โ€Š๐›๐ฎ๐ข๐ฅ๐ญ ๐ฐ๐ข๐ญ๐ก ๐ฑ๐ฅ๐ฐ๐ข๐ง๐ ๐ฌ ๐‹๐ข๐ญ๐ž

Updated: Jul 23

๐€๐ˆ, ๐’๐œ๐ซ๐š๐ฉ๐ข๐ง๐ , ๐€๐๐ˆ๐ฌ, ๐„๐ƒ๐€, ๐ƒ๐, ๐‚๐ก๐š๐ซ๐ญ๐ฌ, ๐๐ƒ๐…๐ฌ, ๐€๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐ง๐ฌ

xlwings Lite turns Excel into a live Python appโ€Šโ€”โ€Šfrom simple automations to complex API based workflows. Just a lightweight add-in, no Python install needed. Built-in code editor, console, environment variables, and deep Excel integration. Built by Felix Zumsteinโ€Šโ€”โ€Šcreator of original xlwings.


Hereโ€™s a quick roundup of apps Iโ€™ve built with xlwings Lite across a range of use cases. Links include files, code, and setup docs. These are live working appsโ€Šโ€”โ€Šwhile the examples shown are around representative use cases, the architecture supports complex, production-grade workflows. Adapt as needed for your own use cases.


๐Ÿ. ๐€๐ˆ ๐–๐ž๐› ๐’๐œ๐ซ๐š๐ฉ๐ž๐ซInput URLs, define columns, set rules. API calls behind the scenes: Jina AI pulls pages, Gemini extracts structured data. Output goes straight into Excel tables. rex.tigzig.com/web-scraper


๐Ÿ. ๐€๐ˆ ๐“๐ž๐œ๐ก๐ง๐ข๐œ๐š๐ฅ ๐€๐ง๐š๐ฅ๐ฒ๐ฌ๐ญPulls Yahoo Finance data, builds charts and indicators, then sends to Gemini Vision for analysis. Output: clean PDF and web reports. Useful base for API based workflows, FastAPI backends, AI analysis and formatted reports. rex.tigzig.com/technical-analysis-report


๐Ÿ‘. ๐€๐ˆ ๐’๐œ๐ก๐ž๐ฆ๐š ๐ƒ๐ž๐ญ๐ž๐œ๐ญ๐ข๐จ๐ง ๐š๐ง๐ ๐€๐ฎ๐ญ๐จ๐ฆ๐š๐ญ๐ข๐จ๐งHandles data with varying columns and types. Uses Gemini API for schema detection, then feeds it into the next automation step.ย rex.tigzig.com/xlwings-llm-api


๐Ÿ’. ๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž ๐‚๐จ๐ง๐ง๐ž๐œ๐ญ๐จ๐ซConnect to any remote DB via an API layer. Built on a FastAPI serverโ€Šโ€”โ€Šjust pass query paramsโ€ฆ.pull schema, browse tables, fetch records, or run custom queries. All inside Excel. rex.tigzig.com/xlwings-api-db


๐Ÿ“. ๐„๐ƒ๐€ + ๐Œ๐‹ ๐–๐จ๐ซ๐ค๐Ÿ๐ฅ๐จ๐ฐBuilds on schema detection to run dynamic EDA plots and summary tables. Includes an XGBoost response model with evals, decile tables, and gains chart. rex.tigzig.com/xlwings-llm-api


๐Ÿ”. ๐˜๐š๐ก๐จ๐จ ๐…๐ข๐ง๐š๐ง๐œ๐ž ๐„๐ฑ๐ญ๐ซ๐š๐œ๐ญ๐จ๐ซPunch in a symbolโ€Šโ€”โ€Šget price, profile and financials directly in Excel. Powered by a FastAPI backend (also doubles as an MCP server). Great starter for getting into FastAPI backends. rex.tigzig.com/yahoo-finance-analyzer


These apps were built before env variable support. You can now secure API keys using env vars instead of exposing in workbook. Check out docs here: Environment Variablesโ€Šโ€”โ€Šxlwings Lite documentation


ree

ย 
ย 
bottom of page