Deployment becomes more annoying and the APIs aren't as intuitive, but all the Excel/Office VBA APIs are accessible via COM so you can use any language that works with COM (e.g. Python): https://support.microsoft.com/en-us/topic/excel-com-add-ins-...

It's especially easy to access via any .NET language. I've written a few plugins in C#: https://learn.microsoft.com/en-us/previous-versions/office/t...

Honestly, I thought it had good discoverability when I used to use it a lot, and the syntaxes is just another syntax..

The problem came when they moved all the documentation to cloud, so you could get hopelessly stuck when you were trying to make something work and didn't have internet access.