𝐀𝐈 + 𝐏𝐲𝐭𝐡𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 𝐰𝐢𝐭𝐡 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞 - 𝐋𝐋𝐌 𝐀𝐏𝐈 𝐂𝐚𝐥𝐥𝐬 | 𝐏𝐚𝐫𝐭 𝟑
- Amar Harolikar
- Apr 7
- 2 min read
Updated: Apr 24
Ability to make API calls from xlwings Lite gives it superpowers.
Check out dedicated xlwings LIte info page on REX AI Co Analyst site
Full templates
How-to guides
Backend code
Technical breakdowns
Resource Links
Detailed info , source codes, how-to guides, resources and templates available on REX
Call LLMs and AI Agents. Parse. Analyze. Automate. All from Excel.
Previously showed how to connect Excel to Postgres, run SQL, perform analysis, EDA, and build an XGBoost model - all inside Excel with xlwings Lite. Now showing how to use API calls to LLMs for schema detection (column names, types) to automate workflows.
𝐈𝐧 𝐭𝐡𝐢𝐬 𝐞𝐱𝐚𝐦𝐩𝐥𝐞
▸ Gemini (2.0-Flash) and OpenAI (GPT-4o) with structured output - JSON
▸ Schema detection followed by EDA tables and plots
▸ API call with requests / httpx … earlier pyFetch
▸ Best start: Gemini -free - fast - no card needed - aistudio.google.com
▸ Recent months Flash better than 4o for schema detection
▸ LLM vs Python for schema detect - my experience
𝐀𝐈 + 𝐀𝐏𝐈 𝐩𝐨𝐰𝐞𝐫𝐞𝐝 𝐄𝐱𝐜𝐞𝐥 - 𝐟𝐞𝐰 𝐮𝐬𝐞 𝐜𝐚𝐬𝐞𝐬
▸ Automated workflows connected to API backends
▸ Web scraping in/out of Excel - AI & non-AI
▸ AI-enabled web research into Excel
▸ Automated text classification and summarization
▸ Text-to-SQL with Excel as frontend (see Part 2)
▸ AI agent integration via API
𝐇𝐨𝐰 𝐈 𝐮𝐬𝐞 𝐋𝐋𝐌 𝐀𝐏𝐈 𝐜𝐚𝐥𝐥𝐬 𝐢𝐧 𝐩𝐫𝐨𝐣𝐞𝐜𝐭𝐬
Half my client projects are automation-focused, with many requiring LLM API calls with structured output as part of the workflow. Use cases include schema detection, data extraction, non-standard file cleanup, and OCR-based web scraping.
I've shared some live apps (open source) on rex.tigzig.com. The Mutual Fund Processor app uses schema detection to identify column structure, data placement, and validation totals to convert messy monthly MF Excel files to CSV, with a choice of LLM model selection. The REX Co-Analyst app includes file upload to a remote database, using schema detection to identify field names and types for table creation before upload.
Feel free to try them out. No API key or DB credentials required. How-to links below.
𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞
Embedded mini code editor, console logs, robust object model - run complex workflows, add packages, make API calls - all from Excel. Created by Felix Zumstein - free, simple, and powerful Python-in-Excel.
✓ Useful Links
▸ Montecarlo simulation. With superbly designed dashboards. Check out this excellent share by FRANCO SIVILA. https://lnkd.in/ghAsXgW5
▸xlwings Lite | Part 2 | - API, SQL, DBs, ML in Excel https://lnkd.in/g7mEJfVT
▸ Excellent docs at: lite.xlwings.com
