4 ms·
This is the interesting thing. I haven't played with it myself but seems MS is trying that with their new Beta python script function, but their implementation
by theonlybutlet 3y ago
This is the interesting thing. I haven't played with it myself but seems MS is trying that with their new Beta python script function, but their implementation is just crazy, completely handicapped. Can't see it being a true replacement for VBA in excel.
- _boffin_ 3y agoI haven't investigated the python implementation at all since i no longer work with VBA and or Excel in that fashion anymore. How have they handicapped it?
- theonlybutlet 3y agoThe code is executed remotely on Microsoft's servers (I can see many organizations just turning this feature off for all staff). I'm open to correction, can't see it in any of the demos, but the code it seems is also entered within a cell, it's not clear whether the output can manipulate/overwrite pre-existing cells as a result or it needs to have its own separate output.
- Qem 3y agoI think proper Python macros is one thing LibreOffice could have implemented years ago, to help attract people and break MS near monopoly on spreadsheets. It exists today, but last time I tried felt very hacky. There was no proper macro editor for it, IIRC you had to extract spreadsheets as if they were zip files and save .py written elsewhere in directories inside. Very cumbersome.
- theonlybutlet 3y agoWasn't aware of this, thanks. I'll give it a try. It's at least a good place to try different things with Python.
- sancarn 3y agoAgree, Python implementation in Excel is trash. Not at all a competitor for VBA. Not yet anyway.