Stuart Breckenridge

Excel Gains JavaScript User Defined Functions

Frederic Lardinois, writing for TechCrunch:

Microsoft is launching a couple of features to Excel today that make the ubiquitous spreadsheet software a bit more powerful. Among the new features is support for Azure Machine Learning and custom JavaScript functions to Excel to extend its capabilities.

[…]

Developers could already write their own complex scripts with Visual Basic for Applications (VBA). There are some advantages to using JavaScript, though, not in the least its popularity and ability to easily connect to third-party services, but also the simple fact that these functions can run on any platform. Microsoft first tested custom functions through the Office Insider Program, and it’s now ready to roll it out to a wider audience.

The instructions seem a little convoluted at this stage 1, but I’m keen to try this out.

  1. It is early access. ↩︎