News for hackers. Stuff that matters.

ayemojay

Re:Microsoft’s making Excel’s formulas even easier on Thursday December 29, 2022 @03:21PM (#34177414)
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.