Microsoft Excel used to only allow two types of data: text and numbers. After overhauling Excel with its own live custom data types last year, Microsoft is opening up Excel to give developers the freedom to create their own custom data types that can contain images, arrays, and more.
This will open Excel up to far more custom data types, including content cards, images, matrices, arrays, and formatted number values. Excel has long had support for macros and add-ins, but Microsoft’s new APIs should make this a lot more efficient and easier for developers to implement.
“These more flexible structures give you the ability to organize complex data as objects and expose this data to users in more natural ways,” explains Wangui McKelvey, general manager of Microsoft 365. “You can share the power of data types across your entire organization and create add-ins or solutions which can connect data types to your own service or data.”