fzumstein

8 ms·

31.
by fzumstein 3y ago
Thanks for your work! The async JS functions are amazing and allowed me to ship rock-solid Custom functions with xlwings and Python. The problem with Office.js is that it’s just simply too hard to get started with all the npm bloat for the
32.
by fzumstein 3y ago
> By it's very nature these Excel documents will be filled with company data, so I can imagine these companies would also be a bit cautious sending those calculations to the cloud, especially if they can't control the flow of d
33.
by fzumstein 3y ago
> I wish it wasn't solely powered only by Microsoft Cloud and could support python running locally Have a look at xlwings, which runs on any cloud and also locally.
34.
by fzumstein 3y ago
DataNitro was my inspiration for the Open Source version of xlwings back in 2014. They have been out of business for many years though.
35.
by fzumstein 3y ago
xlwings creator and author of the O'Reilly book "Python for Excel" here! First of all, big congrats to the team! I've been in contact with the Excel team on and off over the years and I remember when an Excel project man
36.
by fzumstein 4y ago
We built https://www.xltrail.com to make Excel work with Git.
37.
by fzumstein 4y ago
I am the developer of xlwings, so this is heavily biased. Anyhow, ever since I’ve added support for Google Sheets, I am building all internal tools with it. No HTML/JS/CSS required whatsoever and everybody knows how to interact wi
38.
A New Way to Automate Google Sheets with Python(xlwings.org)
2 points by fzumstein 4y ago|0 comments
39.
by fzumstein 5y ago
Hey has! I should have mentioned that xlwings is a wrapper around your excellent appscript package that does all the heavy lifting with AppleScript :) Thanks for reviving the project on GitHub :)
40.
by fzumstein 5y ago
Have a look at xlwings (I am the creator), it’s a Python wrapper around AppleScript that follows closely the original VBA object model, so won’t require a change in mindset.
41.
by fzumstein 5y ago
I found noVNC easier to use.
42.
by fzumstein 5y ago
At https://www.xltrail.com , we wrote an open-source Git extension that allows you to diff the VBA part of your Excel workbooks. The extension also integrates with SourceTree, Atlassian's free Git client. You can see some sc
43.
by fzumstein 5y ago
There is https://gridstudio.io/ but I am not sure what the current project status is...
44.
by fzumstein 5y ago
Thanks for pointing this out and I'll update the homepage accordingly. You're right about the sustainability challenge though!
45.
by fzumstein 5y ago
You're right, it's the biggest challenge. But a ton of companies do now have something like Anaconda in their official software catalogue and sometimes even an internal mirror of PyPI or anaconda.org for the packages.
46.
by fzumstein 5y ago
Book author and xlwings creator here. Thanks for posting this link! Funny enough, about 10 days after sending the book to the printer (March 11), Microsoft updated the feature request ("Python as en Excel scripting language") on t
47.
What Makes Excel's Lambda Functions so great (and what doesn't)?(xlwings.org)
2 points by fzumstein 6y ago|0 comments
48.
by fzumstein 6y ago
not if you don't know anything about css ;)
49.
by fzumstein 6y ago
With Excel (the stuff that tends to be most critical), Microsoft has gone through a few iterations on this. Just a few days ago, they finally enabled a proper Version History on the online version of Excel, much in the same way as it’s been
50.
by fzumstein 6y ago
I agree with you mostly, but Excel is still often a good choice for reporting. And with a package like xlwings, you can do it all from Python.
51.
Open-Source Python Libraries for Excel(excelpython.org)
2 points by fzumstein 6y ago|0 comments
52.
Python Libraries for Reporting and Factsheets(xlwings.org)
1 points by fzumstein 7y ago|0 comments
53.
by fzumstein 7y ago
If you write VBA in Excel, there is a free Git extension called Git XL that we maintain which is able to properly Git merge your code directly in Excel: https://github.com/xlwings/git-xl
54.
Xlwings-Reports: Excel and PDF Reports with Python(xlwings.org)
2 points by fzumstein 7y ago|0 comments
55.
by fzumstein 7y ago
You can use Pandas via the xlwings package ( https://www.xlwings.org )
56.
How to Merge Excel Workbooks with Git(xltrail.com)
3 points by fzumstein 7y ago|0 comments
57.
by fzumstein 7y ago
With a few tricks, you can actually use a professional version control system like Git with Excel, see the slides of my recent webinar: https://www.slideshare.net/xlwings/git-for-excel-files-webin...
58.
by fzumstein 7y ago
You can actually unit test your Spreadsheets surprisingly easily with Python: https://www.slideshare.net/xlwings/automated-testing-of-exce...
59.
by fzumstein 7y ago
Microsoft has been looking into adding Python natively, see: https://news.ycombinator.com/item?id=15927132 but we're still waiting for an official decision...
60.
The new dynamic arrays in Excel with Python and xlwings(xlwings.org)
65 points by fzumstein 7y ago|9 comments

More ›