fzumstein

9 ms·

61.
Free VBA developer tools in 2019(xltrail.com)
16 points by fzumstein 7y ago|1 comments
62.
by fzumstein 7y ago
see also http://docs.xlwings.org/en/stable/rest_api.html for the Python version of the REST api. It doesn't require any VBA...
63.
A better way to track changes in Excel(xltrail.com)
1 points by fzumstein 7y ago|0 comments
64.
Collaborate on Excel Workbooks – The Definitive Guide(xltrail.com)
2 points by fzumstein 8y ago|0 comments
65.
5 tools to compare Excel files(xltrail.com)
1 points by fzumstein 8y ago|0 comments
66.
Writing async functions with Excel has never been easier(docs.xlwings.org)
1 points by fzumstein 8y ago|0 comments
67.
Access your legacy Excel workbooks via REST API(docs.xlwings.org)
2 points by fzumstein 8y ago|0 comments
68.
by fzumstein 8y ago
Our [video course]( https://training.zoomeranalytics.com/p/xlwings ) allows us to spend more time again on developing xlwings. With regards to your question: Please open a [GitHub issue]( https://github.com&#x2
69.
by fzumstein 8y ago
16 seconds demo: https://www.youtube.com/watch?v=KXzG3LBZEWI
70.
Call Python functions from VBA in all Microsoft Office apps(docs.xlwings.org)
75 points by fzumstein 8y ago|25 comments
71.
3 steps to make Spreadsheet Compare work with Git diff(xltrail.com)
3 points by fzumstein 9y ago|0 comments
72.
Getting Started with Git and Excel: Setup Gitignore(xltrail.com)
2 points by fzumstein 9y ago|0 comments
73.
by fzumstein 9y ago
Note that Pathio has been relaunched as https://www.xltrail.com - it supports the standard Git workflow and every Git system (GitHub, Bitbucket, Gitlab etc.).
74.
by fzumstein 9y ago
I agree, the issue is not Excel as such but how it's being handled: I once wrote a blog post on how you can unit test Excel spreadsheets, too: https://www.zoomeranalytics.com/blog/unittests-for-microsoft...
75.
Xlwings is now on xltrail(xltrail.com)
2 points by fzumstein 9y ago|0 comments
76.
by fzumstein 9y ago
It's described in the last paragraph "Behind the scenes"
77.
Tired of Excel's VLOOKUP? Use SQL Queries on Excel Ranges(zoomeranalytics.com)
2 points by fzumstein 9y ago|2 comments
78.
by fzumstein 10y ago
I wrote a blog post about unit testing Excel workbooks using Python's built-in unittest module: https://www.zoomeranalytics.com/blog/unittests-for-microsoft...
79.
Unit Tests for Microsoft Excel(zoomeranalytics.com)
2 points by fzumstein 10y ago|0 comments
80.
How to Fetch Market Data in Excel Like a Pro(zoomeranalytics.com)
3 points by fzumstein 10y ago|1 comments
81.
by fzumstein 11y ago
Elegance is always a relative term, but one could argue that having 0 dependencies is more elegant than having 2 dependencies.
82.
by fzumstein 11y ago
interesting! what do you do differently?
83.
Pip -t: A simple and transparent alternative to virtualenv in Python(blog.zoomeranalytics.com)
74 points by fzumstein 11y ago|61 comments
84.
by fzumstein 12y ago
Yes...you need Excel installed (on Windows or Mac) as this is a package for interaction/programming with open files, not just reading/writing files.
85.
by fzumstein 12y ago
Or simply comment out that line: https://github.com/ZoomerAnalytics/xlwings/issues/72
86.
by fzumstein 12y ago
No but have a look at https://github.com/ericremoreynolds/excelpython for UDFs.