Over the last few years, Excel has begun to add a variety of new data kinds, first allowing users to draw in stock and geography data from the cloud, then Power BI and Power Query data types, which allow users to deal with their own data. Developers can now go a step further by defining unique data types that are relevant to their businesses.
Microsoft Excel only permitted two types of data, text, and numbers, until recently. Instead of simple strings of text or numbers, cells can now hold far more complicated elements such as content cards, pictures, matrices, arrays, and more.
We have been on a multi-year journey to up-level Excel’s possibilities with data types—first with the introduction of the Stocks and Geography data types and last year with the release of Power BI and Power Query data types, which allow customers to work with their own data as a data type.Microsoft said in thier blog post.
Microsoft has already partnered with Bloomberg to help them test these new data kinds. These more flexible structures allow you to organize complex data as objects and display it to users in more natural ways, while still allowing users simple access to the entire information they need for analysis or reporting.
Customers will also be able to create new add-ins or enhance current ones to take advantage of the power of data types, resulting in a more integrated and next-generation Excel experience. You can use data types to empower your entire company by developing add-ins or solutions that connect data types to your own service or data.
Microsoft is offering consumers and developers the ultimate power with this new API, allowing them to better organize, access, and work with their data.