For a long time, Microsoft Excel has been predominantly about text and numbers and Microsoft has been working to increase the data types supported by the application. Just last year at the Ignite Conference, dynamic arrays and array formulas were introduced and now this year, it’s the custom data types.
Here is the gist
The great thing about this update is that linked data types connect users to other data from Bing and other sources. The goal is to show everyone that Excel can offer more than just text and numbers. Non-developers can now create mobile and desktop apps for businesses. According to Microsoft’s program manager,
Introduction of Javascript interfaces
With the introduction of Javascript interfaces, developers can now use more data types. This addition will revolutionize how developers work. It will significantly reduce the number of custom fixes for add-ins needed. For those familiar with Range.values API, Range.valuesAsJson should be easier to read as it will allow them to read and write data types. The new API supports entity values, web images, formatted number values and arrays which can be used as inputs and outputs. The update is currently available in the latest Windows and macOS versions for Insiders with the latest JavaScript APIs. What do you think of the latest update for Excel? Share your thoughts in the comment section below.
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
