xlwings retweeted
Big new feature for xlwings Lite: Plugins are here! ✨
Plugins solve something that was always missing in VBA: an easy way to reuse your scripts and custom functions across workbooks.
Plugins are regular Python packages that you can publish on PyPI or an internal package registry. What makes them special is that they automatically register their scripts and custom functions, so you don’t need to write any code in your workbook.
Like other Python dependencies, Plugins are pinned to a version, but you can also have them update automatically with the new “no pin” option.
To try it out, add xlwings-sqlookup to your requirements.txt and you’ll get the SQLOOKUP custom function in Excel.
Docs: lite.xlwings.org/plugins
#xlwings #pythoninexcel #python #microsoftexcel
xlwings retweeted
For the next thing I am building, I had to fill a ton of gaps in the xlwings API. So now xlwings supports the following natively:
- PivotTables
- Conditional Formats
- Borders
- Advanced Chart control
- AutoFilter
- and many more...
Release notes: docs.xlwings.org/en/latest/w…
xlwings retweeted
Python has a new plotting library! 📈
Reflex recently launched xy, which I took as an opportunity to add support for even more plotting libraries to xlwings Lite's notebooks. You can now use:
- Matplotlib
- Seaborn
- Plotly
- Bokeh
- Altair
- Plotnine
- xy
Which one is your favorite?
#xlwings #python #microsoftexcel
xlwings retweeted
xlwings Lite scripts now support arguments! Adding a type hint is all it takes to turn them into form fields when the script runs in App Mode.
#xlwings #pythoninexcel #python #microsoftexcel
xlwings retweeted
print() doesn't have to be boring.
The Output pane in xlwings Lite now supports colors, so you can use @willmcgugan's Rich or Colorama to format your output nicely, including tables, progress bars etc.
#xlwings #python #pythoninexcel #microsoftexcel
xlwings retweeted
xlwings Lite is used for serious work, so it now has a serious Source files menu.
Some users told me their "main. py" had grown past 5,000 lines. Now you can split it up across multiple modules.
You also get:
* Multiple notebooks (.nb.py extension)
* Multiple pytest files (test_*.py)
* Non-Python files, like "config.json"
* "*.sql" for SQL syntax highlighting
* Close and reorder tabs, rename and delete files
#xlwings #python #microsoftexcel #pythoninexcel
xlwings retweeted
I've just added a new killer feature to the xlwings Lite notebook: Right-click any variable and select "View in Excel". This will write out the DataFrame or whatever it is to a new sheet in your current workbook.
This is inspired by "xw.view()" from the open source package, which happens to be one of the all-time favorite xlwings features, from what I hear.
There's a few other enhancements though, go try the latest version of the notebook for yourself!
#xlwings #python #microsoftexcel
xlwings retweeted
xlwings Lite now officially supports custom functions that return plots!
This means you can return plots from Matplotlib, Seaborn etc. and they behave just like native Excel charts: change the source data, and the plot updates automatically.
Because of technical limitations, the plot has to briefly pass through a cloud server before it lands in your cell. If that gives you heartburn: the self-hosted version of xlwings Lite keeps your data inside your network at all times. Happy to show you around!
Docs: lite.xlwings.org/custom_func…
#xlwings #matplotlib #python #pythoninexcel
xlwings retweeted
2 days ago, xlwings Lite crossed 1,000 daily users for the first time.
For the first 10 months, daily users were around 200. Nobody seemed to really care and I was busy with the 2nd edition of my O'Reilly book "Python for Excel".
However, in January, I started to implement the features users were asking about. Most importantly, I added support for local files. All of a sudden, people seem to care!
Meanwhile, I've started using xlwings Lite for serious work myself. For example, I built this chart in it, using Wingman, the AI chat built into xlwings Lite ;-)
#xlwings #python #microsoftexcel
xlwings retweeted
🎉 Giveaway! My author's copies of the 2nd edition of Python for Excel have arrived! To celebrate, I'm giving away 2 copies.
The 2nd edition now also covers Microsoft's "Python in Excel" and the new xlwings Lite add-in.
To enter: leave a comment about what you're most looking forward to learning.
I'll draw 2 winners in a week, on June 29.
#pythoninexcel #microsoftexcel #xlwings
xlwings retweeted
xlwings Lite now supports object handles!
While they look similar to a 'Python in Excel' cell, they are actually useful as you can provide them as arguments in native Excel functions. You can also customize them (icon, preview card, and text). See the docs: lite.xlwings.org/custom_func…
#xlwings #pythoninexcel #python #microsoftexcel
xlwings retweeted
xlwings Lite now supports streaming functions!
The docs include a sample about how to stream live BTC prices: lite.xlwings.org/custom_func…
Enjoy!
#xlwings #pythoninexcel #python #microsoftexcel
xlwings retweeted
Come to the dark side. 🖤
Dark mode has descended upon xlwings Lite.
May the 4th be with you.
xlwings retweeted
xlwings Lite can now run automated tests with pytest! 🔥
It's useful even if you don't use xlwings otherwise:
* Unit tests: Unit test your functions from main. py (see screenshot).
* End-to-end tests: Change an input cell and check if the result is correct.
* Cross-check: Double-check your spreadsheet logic with an independent implementation in Python.
Here are the docs: lite.xlwings.org/tests
xlwings retweeted
xlwings Lite notebooks now support Plotly plots 🔥
This is perfect for exploratory data analysis as you can zoom in, deselect categories, and get additional information in tooltips on hover.
👉 Install xlwings Lite for free from the Microsoft Marketplace: marketplace.microsoft.com/en…
@plotlygraphs
#xlwings #plotly #microsoftexcel #pythoninexcel
xlwings retweeted
xlwings Lite now has a Jupyter notebook experience built in 🔥! notebook.py supports your interactive workflow in addition to the script buttons and custom functions that you define in main.py.
Unlike =PY cells, it behaves like a traditional Jupyter notebook, so only the cells you run get executed. It also supports Shift+Enter.
Give it a try and let me know what you think!
xlwings retweeted
With undisclosed usage limits, Python in Excel will never be more than a prototyping tool.
That’s why I am working so hard on xlwings Lite.
This is from a Reddit discussion: reddit.com/r/excel/comments/…
#xlwings #pythoninexcel #python #microsoftexcel
xlwings retweeted
It’s been 5 years since my book came out, which means it’s time for an update!
The 2nd edition is now available (unedited) on the O’Reilly Learning Platform:
oreilly.com/library/view/pyt…
Print versions will be available in early June and are already available for pre-order: amazon.com/Python-Excel-Envi…
The 2nd edition includes three new chapters on Python in Excel and xlwings Lite. It also updates the stack:
• uv instead of conda
• Python 3.8 → 3.14
• pandas 1.0 → 3.0
There are also new sample cases featuring DuckDB, the OpenAI API, and Hugging Face.
xlwings retweeted
xlwings Lite now has an App Mode 🚀 ! It enables you to quickly ship an Excel app to end-users who don't bother about how it works and who shouldn't change your Python code by accident.
In App Mode, xlwings Lite hides the code editor and shows each script with an own button. It also renders the module and function docstrings in Markdown and shows a list of your custom functions.
It's pretty powerful!
#xlwings #python #microsoftexcel #pythoninexcel
xlwings retweeted
Two things I don't like about Power Query:
* It uses M code
* It has no Copilot integration to write the M code for me
But, I don't really care anymore because xlwings Lite + DuckDB is the new Super Power Query. In my latest video, I am analyzing 46 million records in 4 seconds with SQL. I also demo how Wingman can edit and explain the code.
👉 youtube.com/watch?v=vT0SDvgQ…
#pythoninexcel #xlwings #microsoftexcel #powerquery #duckdb

















