4 ms·
Any new or good ways to do this? I used Excel-Dna 10 years ago.
by rr808 4y ago
Any new or good ways to do this? I used Excel-Dna 10 years ago.
- alar44 4y agoHonestly, GPT is pretty good at this type of stuff.
- unsupp0rted 4y agoGPT's code and docs for this is way out of date. I tried it a couple weeks ago.
- unsupp0rted 4y agoYup, 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...
- rr808 4y agoAh interesting thanks, I'll have to try it out.
- cm2187 4y agoIs 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).
- unsupp0rted 4y agoNot sure how it compares to XLL but I'd wager the bottleneck, in my case, is the API calls.