Re:Microsoft’s making Excel’s formulas even easier
by unsupp0rted on Thursday December 29, 2022 @03:32PM
(#34177556)
Modern Javascript: 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.
Re:Microsoft’s making Excel’s formulas even easier
by rr808 on Thursday December 29, 2022 @03:50PM
(#34177733)
Excel-Dna works great. C#, Doesn't need access to registry so easy install.
Re:Microsoft’s making Excel’s formulas even easier
by cm2187 on Thursday December 29, 2022 @03:57PM
(#34177828)
And combined with NetOffice for Excel COM interoperability without the headaches.
Re:Microsoft’s making Excel’s formulas even easier
by auxym on Thursday December 29, 2022 @08:50PM
(#34180768)
You can use C# or F# using excel-DNA. I've played with excel add-ons (xll files) in F# in the past, pretty neat.
Re:Microsoft’s making Excel’s formulas even easier
by Iwan-Zotow on Thursday December 29, 2022 @09:01PM
(#34180850)
Python+LibreOffice
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.