Python for Excel data manipulation would be great.
The finance folks I work with are fucking wizards. I'm convinced many of them would have made great engineers given what they can accomplish building applications in what might be the world's worst IDE.
I'd say two things would make it better: - Have a "code" version of the cell editor that has formatting/indentation + basic linting. [Sometimes 75% of the challenge is reading the code in linear fashion and figuring out what it does]
- Integrate git-like versioning and some sharing features with Office365. Basically, make it so that you can roll-forward or roll-back on both the code and the contents, and make it so that you are _not_ emailing files around to share them.
It was one of my first usages of Python, and used that to create quite complex Spreadsheets
They did officially respond in 2018 and put out a survey for thoughts, don't think they've followed up since but they definitely know demand is there.
I could only find "Office Scripts", which doesn't work in the normal desktop apps (only the web version).
Edit: I just found out about "Script Lab". Is that what you are talking about? https://appsource.microsoft.com/en-us/product/office/WA10438...