Microsoft Excel has always been known to only allow entry for two types of data: text and numbers. After overhauling Excel with its own live custom data types last year, Microsoft has concluded that opening up Excel to give developers the freedom to create their own custom data types that can contain images, arrays, and more.
This addition is expected to open Excel up for far more fantastic custom data types, which may include content cards, images, matrices, arrays, and formatted number values. Excel has long released application support for macros and add-ins, but the addition of Microsoft’s new APIs would result in a program that is a lot more efficient and easier for developers to implement. In the past, Excel added a number of data types, which allowed users to pull in stock and geography data from the cloud at first, they immediately followed up with the addition of Power BI and Power Query data types — which allowed users to work with their own data. Now, developers can take this a step further by creating custom data types that make sense for their organizations.