3 ms·
This is actually about using a paid, closed-source add-on PyXLL, that integrates python into Excel, but only to the Windows version. And costs 25 USD per month
by shp0ngle 6y ago
This is actually about using a paid, closed-source add-on PyXLL, that integrates python into Excel, but only to the Windows version.
And costs 25 USD per month (but has a free trial).
Excel is never actually ditched.
edit: oh, that's only step 4. Step 5 is actually ditching Excel.
- etothepii 6y agoThe main point is to try and separate view, data and calculation engine. PyXLL is great for helping with this as you can move the calculations into Python and thus have them automatically tested and protected by source control. I assume this is possible for VBA but have never seen it done in practice.
- m101 6y agoI've used xlwings at work but I'm mired by packaging issues and things like the CMD window disappearing for some users but not others.