[wayne]

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...