Microsoft Announces to Support JavaScript for Excel
At the end of last year, foreign media reported that due to the strong demands of community users, Microsoft is considering adding Python as an official Excel scripting language. However, at yesterday’s Build 2018 Developer Conference, Microsoft did not disclose information about Python support. Instead, it announced that Excel added JavaScript support, which means that developers can now run native JavaScript custom functions in Excel.
That is, developers can use JavaScript code to customize Excel formulas, then insert and call these formulas from Excel spreadsheets, and use the JavaScript interpreter to calculate tabular data instead of using Excel’s own calculation engine.
Microsoft said that office developers have been hoping to write JavaScript custom functions in Excel to perform some mathematical operations, bank account data, and stock data, etc. This will allow them to have more flexibility in customizing Excel.
However, this feature has not yet been officially released. Currently, it is only available in the Excel Developer Preview for Windows and Mac, as well as in the Excel online version. Users must first join the Office Insiders and install a custom add-in to experience.