fzumstein

7 ms·

1.
by fzumstein 14d ago
awesome, thanks!
2.
by fzumstein 14d ago
This sounds interesting! Do you have a specific example by any chance or blog post/doc references?
3.
by fzumstein 14d ago
I tend to agree. SQL may have been harder to write in the past (worse autocomplete than pandas/polars), but now that AI is writing the code, SQL is usually much easier to read. So DuckDB is another interesting alternative to pandas.
4.
by fzumstein 1mo ago
Funny enough, I received a marketing email from GitHub during the outage with the following subject: "What if every pull request you started actually shipped"
5.
by fzumstein 3mo ago
Pyodide 314.0 is already available in xlwings Lite (the Python in Excel alternative you actually wanted).
6.
by fzumstein 5mo ago
DuckDB also runs in Excel, by the way, via the free xlwings Lite add-in that you can install from the add-in store. It’s using the Python package and allows to write scripts, custom functions, as well as use a Jupyter-like notebook workflow
7.
by fzumstein 6mo ago
Pyodide powers xlwings Lite, a free Excel add-in that you can install from Excel’s add-in store with a single click. It outperforms Microsoft’s official Python in Excel solution in every coceivable way: price, privacy, speed, can install pa
8.
by fzumstein 9mo ago
Have you tried the CSP build of AlpineJS? It takes the code out of the template into a proper JS file, no unsafe-eval. Isn't state management mostly handled on the backend when you use AlpineJS?
9.
by fzumstein 1y ago
I am not a random user, but the creator. The dependencies are managed via standard requirements.txt file, which is stored in the Excel workbook itself. When you open xlwings Lite with the workbook, the dependencies are installed from either
10.
by fzumstein 1y ago
No, this is for Excel only, but it does work with the free online version of Excel. I think LibreOffice has support for Python via PyOO.
11.
Xlwings Lite: A free, local alternative to Python in Excel with no usage quota(lite.xlwings.org)
1 points by fzumstein 1y ago|0 comments
12.
SQLookup(sqlookup.com)
3 points by fzumstein 2y ago|1 comments
13.
by fzumstein 2y ago
SQLookup is an Excel add-in that gives you access to the SQLOOKUP function. The SQLOOKUP function allows you to query data in your Excel workbook using SQL (SQLite dialect). The add-in is free and works with Excel on Windows, macOS, and web
14.
by fzumstein 2y ago
So basically it’s free for 1 day per month (I only use chat).
15.
by fzumstein 2y ago
It's exactly why I built xlwings, to replace VBA with Python. Python in Excel instead is a competitor to the Excel formula language.
16.
by fzumstein 2y ago
No offense taken, and happy that xlwings was an inspiration for creating Row Zero! I don't really buy the security issues though for being the reason for switching from Excel to Row Zero. Yes, Excel has security issues, but so does the
17.
by fzumstein 2y ago
As the author of said second class add-in, let me just guess that your most popular feature request was adding the "Import from xlsx" functionality...which describes the whole issue: it's always Excel + something, never somet
18.
by fzumstein 2y ago
xlwings is a competitor to VBA rather than openpyxl: openpyxl can read and write the Excel file on disk, without involving the Excel application. xlwings is all about automating the Excel application, and write macros and custom functions i
19.
by fzumstein 2y ago
Hi all, I am Felix, the author of the post. I just wanted to reiterate that this post was mainly meant as a summary of my GitHub issues I opened with them. So it should really be seen as a feedback to help them improve the product. Python i
20.
My thoughts on Python in Excel(xlwings.org)
288 points by fzumstein 2y ago|118 comments
21.
by fzumstein 2y ago
It's been 10 years. But upload videos very irregularly.
22.
by fzumstein 2y ago
My most obscure video is about programming VBA in VS Code. Other than that, I focus on Python for Excel (no "Python in Excel"): https://www.youtube.com/@xlwings9689
23.
by fzumstein 2y ago
For the Python/Jinja world, there is Jinja2-fragments that allows you to return blocks of the template without having to extract it to partials. I am sure there are similar solutions for other template languages. See https:/&#x2F
24.
by fzumstein 3y ago
Never heard of it either. "Build and share delightful machine learning apps, all in Python." I am wondering what the heck is so special about "machine learning apps" that would differentiate them from any other app that
25.
by fzumstein 3y ago
Totally agree on the part of the add-in: Just give us a dead-simple method to load the manifest locally and be done with it!
26.
by fzumstein 3y ago
I don't think that's necessarily true. They built VSTO for C#, but everybody was using ExcelDNA instead, an Open Source solution that was much better!
27.
by fzumstein 3y ago
The same with xlwings (works on macOS, too): >>> import xlwings as xw >>> wb = xw.Book() >>> sh = wb.sheets[0] >>> sh["A1"].value = "Hello World"
28.
by fzumstein 3y ago
Which part do you find difficult? The web backend or the deployment of the Manifest.xml via the app store / office admin?
29.
by fzumstein 3y ago
It's me, yes, are you Michael then ;)? Yeah, I love the Office.js platform, I believe it's the most versatile extension platform there is, it just came out during an unfortunate time (when people believed that you can't use J
30.
by fzumstein 3y ago
Glad I am not the only one with this impression :)

More ›