[bcoates]

There's PowerQuery, built into Excel. It can do some great stuff (love me some fuzzy join) but the ergonomics are apocalyptic.

This is actually the root problem of trying to improve or extend Excel--it has a truly ancient, horribly broken sharing/ipc/embedding model that is integrated into everything and can't be easily fixed or worked around.

[Cordiali]

Power Query/M is the only functional language I've used, a couple years ago. I actually quite liked it, I even built up a collection of my own functions.

It's just a pity the editor is literally worse than Notepad. And the implementation wants to reload a file twenty times. And the security stuff doesn't really work, so you're constantly turning that off. And and and.