3 ms·
As someone who's not Excel-pilled, how does this work? Is it an alternative language to Excel's own formula language or an add-on like VBA?
by qsort 2y ago
As someone who's not Excel-pilled, how does this work? Is it an alternative language to Excel's own formula language or an add-on like VBA?
- zamadatix 2y agoIt runs pretty much as described - you enter `=py` and it becomes a place to dump python code directly without configuring anything. The "catch" is it runs in the cloud and you need to buy the appropriate license level.
- darkest_ruby 2y agoPossible to refer to other cells/sheets in that python code?
- ryzvonusef 2y agofrom what I understand from seeing youtube videos of it in action, you can use python functions libraries for the calculation part, but one of the strenghts of VBA was that you could interact with the Excel software itself, and that bit hasn't been replicated in python. people liked they could set up scripts in VBA for automating routine tasks, but hated the VBA language syntax, from what I've understood, and wished they could program those functions in some more popular language like Python etc. But that isn't what this is.
- fzumstein 2y agoIt's exactly why I built xlwings, to replace VBA with Python. Python in Excel instead is a competitor to the Excel formula language.
- ryzvonusef 2y agoTools like xlwing are excellent, but people want to start excel first and stay in that interface. If we are going to open up Jupyter notebooks, we have already failed. (That's why VBA works, it's the only thing that runs on locked down corp laptops, because it's inside Excel.)