Cruzersoftech
Microsoft opens up Excel to custom data types with images, arrays, and more
Tech News

Microsoft opens up Excel to custom data types with images, arrays, and more

Microsoft Excel used to solely enable two types of data: textual content and numbers. After overhauling Excel with its personal reside custom data types final yr, Microsoft is opening up Excel to give builders the liberty to create their very own custom data types that may include photographs, arrays, and more.

A brand new JavaScript API shall be accessible to preview inside Excel later this month, which can let builders create these custom data types for inputs and outputs and allow custom capabilities. Excel builders shall be ready to create their very own add-ins or replace current ones to use the JavaScript API.

This can open Excel up to far more custom data types, together with content material playing cards, photographs, matrices, arrays, and formatted quantity values. Excel has lengthy had help for macros and add-ins, however Microsoft’s new APIs ought to make this lots more environment friendly and simpler for builders to implement.

“These more versatile constructions provide the capacity to manage complicated data as objects and expose this data to customers in more pure methods,” explains Wangui McKelvey, normal supervisor of Microsoft 365. “You possibly can share the ability of data types throughout your total group and create add-ins or options which might join data types to your personal service or data.”

A preview of the brand new JavaScript API in Excel shall be accessible later this month, nevertheless it’s not clear precisely when this shall be rolled out to all Microsoft 365 customers.

Related posts

Microsoft joins Qualcomm’s effort to set standards for ‘Internet of Things’

cruzer

Microsoft sells 50% stake in Caradigm healthcare startup to GE

cruzer

Microsoft adds 23k employees in one year, growing 14% despite pandemic and tight labor market

cruzer