Writing VBA in other programming languages

[dispelthemyth]

Due to wanting to learn more than just VBA so i am not typecast as 'that excel guy' i am leaning some other things such as Python and realised that VBA can be replaced and written directly using xlwings - Replace Excel VBA with Python!

What other languages (and add ins) are good for integrating with Excel?

 

[Aaron Blood]

Due to wanting to learn more than just VBA so i am not typecast as 'that excel guy' i am leaning some other things such as Python and realised that VBA can be replaced and written directly using xlwings - Replace Excel VBA with Python!

What other languages (and add ins) are good for integrating with Excel?

Last time I tinkered with it, I believe the native compiled DLL's, Excel functions, and so forth were created with C/C++

There was actually a very good book on it years ago that may be a tad outdated now:
"Financial Applications Using Excel Add-in Development in C/C++" by Steve Dalton and the publisher was Wiley Finance

If I were to start tinkering with it again, I might dust off that book and try to maybe pair it with C# just because C# seems to be the bestest! LOL

Good thing about the book is it lays bare the somewhat rigid structure that you do need to adhere to for making your own Excel functions that can calculate as fast as the built-in Excel functions. I don't think I would've been able to easily google-my-way to that info.