News for hackers. Stuff that matters.
Re:Excel Adds JavaScript and Power BI Support by msaunders77 on Tuesday May 08, 2018 @06:06PM (#17025682)
As the PM for this feature I'm happy to answer that it works in Excel Online starting today in the developer preview!

Right now developers have to sideload the add-in manually. But when the feature ships publicly, the add-in that has the custom JS functions will be deployed to a "catalog". The various Excel platforms (like Excel for Windows, Mac, and Excel Online) will all be able to access that catalog automatically to run the same functions because a pointer to the add-in gets persisted in the xlsx file.

That's a little different from VBA UDFs, which get stored in the file itself. But one advantage of our new model is that it will be way easier for organizations to manage and maintain their JS functions, compared to VBA.

Re:Excel Adds JavaScript and Power BI Support by govert on Wednesday May 09, 2018 @07:01PM (#17035049)
It would be wonderful if it were possible to integrate with this 'pointer' mechanism in a custom way for .xll add-ins too, like those made in C/C++, .NET (with Excel-DNA), Python (with PyXLL) or D (with excel-d)? There's a huge ecosystem of Excel add-ins that could benefit by access to just a few of the hooks being build for the JavaScript support.
Re:Excel Adds JavaScript and Power BI Support by jimnotgym on Tuesday May 08, 2018 @06:13PM (#17025741)
As the PM can I beg you to look again at Python built in to replace VBA?