3 ms·
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 wor
by wayne 4y ago
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-and-automation-add-ins-91f5ff06-0c9c-b98e-06e9-3657964eec72 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/troubleshoot/office-developer/automate-excel-from-visual-c https://learn.microsoft.com/en-us/previous-versions/office/t...