11–20 of 123 posts
I rarely want to access Python from my Excel. I quite often want to access Excel from my Python.
A spreadsheet is a great GUI for a lot of things. A lot of people are employed creating "shitty version of Excel but can be driven from any of "
Being able to easily drive Excel from an external Python program would make for a nice cross-platform application substrate.
> We wanted an alternative to VBA, but got an alternative to the Excel formula language. indeed > Integrating the Jupyter notebook cells inside the Excel grid was a mistake. 100% agreed. this seems like the typical Microsoft behavior where the team A was pushing their product and won over team B, even though it's not really what users needed > Python in Excel isn’t suitable for Python beginners nor for interactive da…
i am baffled. power query / M is taking over the corporate world and its extremely, extremely useful. its one of the most useful things that nobody in open source world has tried to copy (that im aware of).
I agree with xlwings about this but for different reasons. MS are a company wot makes money. Python was added to Excel cos R and Python and so on - market share. I suggest you do what my brother does and unanswer the question! He works for quite a large firm and is surrounded by quite a lot of data. He is a Windows user by routine and asked me for some help. I got Python + MS Visual Code installed and integrated for…
One should note that this comes from xlwings, a Python-in-Excel plugin with a $1,490 professional lifetime license. Excel's changes will end up eating their reason to exist.
And anyway, Microsoft did this in reaction to increasing demand. The pie will grow faster than Microsoft's pie slice will take from this guy.
Without interacting with it myself, none of this is surprising. I have used excel in the past, and I am a long term python user. But if you asked me today what I really wanted to make my life easier and ultimately a product or business better using only excel? I would ask for lua or scheme. I don’t need a batteries included environment embedded into a spreadsheet. I just want sane syntax for common functionality whic…
Your personal use-case might prefer Lua or Scheme, but most casual Excel (or SQL) users are non-programmers so they won't. They'll want the equivalent of decently-documented macros or boilerplate they can easily and quickly use without modification. (One common Excel use-case will clearly be "import/munge lots of data from various sources, then pass it into some AI model, then process the output". Can't see people wr…
I personally don’t think python is the problem here, but if their users can learn python they can certainly learn lua.
"I don't want to learn the M language" i am baffled. power query / M is taking over the corporate world and its extremely, extremely useful. its one of the most useful things that nobody in open source world has tried to copy (that im aware of).
The big problem is that this is exactly backwards. I rarely want to access Python from my Excel. I quite often want to access Excel from my Python. A spreadsheet is a great GUI for a lot of things. A lot of people are employed creating "shitty version of Excel but can be driven from any of " Being able to easily drive Excel from an external Python program would make for a nice cross-platform application substrate.
"I don't want to learn the M language" i am baffled. power query / M is taking over the corporate world and its extremely, extremely useful. its one of the most useful things that nobody in open source world has tried to copy (that im aware of).