In the past, Microsoft Excel only allowed two types of data: text and numbers. After overhauling Excel with its own real-time custom data types last year, Microsoft is opening up Excel, giving developers the freedom to create their own custom data types, which can include images, arrays, and more.
This will make Excel open to more custom data types, including content cards, images, matrices, arrays, and formatted numeric values. For a long time, Excel has supported macros and add-ins, butMicrosoftThe new API should make developers more efficient and easier to implement.
“These more flexible structures give you the ability to organize complex data into objects and expose these data to users in a more natural way,” explained Wangui McKelvey, general manager of Microsoft 365. “Users can share the power of data types throughout the organization and create plug-ins or solutions that connect data types to your own services or data.”