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.
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.”