3 ms·
What is your language of choice for building custom formula? Python + xlwings: most successful (relatively speaking) to build custom finance functions in my li
by ayemojay 4y ago
What is your language of choice for building custom formula?
Python + xlwings: most successful (relatively speaking) to build custom finance functions in my line of work. Downside is the slowness and deploying on other computers.
Rust + xladd: really enjoyed this but feels immature still. Better performance than python and easier to distribute as single dll.
VBA: options above make this almost obsolete, however can’t beat being embedded.
- unsupp0rted 4y agoModern Javascript: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview https://learn.microsoft.com/en-us/office/dev/add-ins/excel/c... For the "task pane", if you need one, you can use React or Angular, but I prefer to use Vue (or no front-end framework is fine too). For the backend logic, just straight up Node + webpack. You could probably do this better with Vite, but I think Microsoft's starter templates all use webpack. You end up distributing a manifest file that tells Excel which server your assets and API live at. Warning: hot reload and dev debugging is quite a pain on macOS.
- rr808 4y agoExcel-Dna works great. C#, Doesn't need access to registry so easy install.
- cm2187 4y agoAnd combined with NetOffice for Excel COM interoperability without the headaches.
- auxym 4y agoYou can use C# or F# using excel-DNA. I've played with excel add-ons (xll files) in F# in the past, pretty neat.
- Iwan-Zotow 4y agoPython+LibreOffice