Microsoft’s making Excel’s formulas even easier

Re:Microsoft’s making Excel’s formulas even easier by rr808 on Thursday December 29, 2022 @03:16PM (#34177348)

Any new or good ways to do this? I used Excel-Dna 10 years ago.

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by unsupp0rted on Thursday December 29, 2022 @03:35PM (#34177595)

Yup, javascript: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/c...

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by rr808 on Thursday December 29, 2022 @03:43PM (#34177667)

Ah interesting thanks, I'll have to try it out.

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by cm2187 on Thursday December 29, 2022 @03:49PM (#34177730)

Is it fast? For instance there is a large overhead to using VBA UDF, whereas XLL (and ExcelDNA) is pretty fast (matters if the formula is repeated over and over on a spreadsheet).

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by unsupp0rted on Thursday December 29, 2022 @03:52PM (#34177769)

Not sure how it compares to XLL but I'd wager the bottleneck, in my case, is the API calls.

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by alar44 on Thursday December 29, 2022 @03:19PM (#34177384)

Honestly, GPT is pretty good at this type of stuff.

[ Parent | on HN ]

Re:Microsoft’s making Excel’s formulas even easier by unsupp0rted on Thursday December 29, 2022 @03:28PM (#34177503)

GPT's code and docs for this is way out of date. I tried it a couple weeks ago.

[ Parent | on HN ]