With the addition of data types APIs, we want to empower you as a developer to take advantage of many of the experiences we have built that power data types. Linked data types (Stocks, Geography, Wolfram and Power BI), entity values, dynamic arrays, improved errors, images in cells, lambdas, and formatted number values are all new types that have delivered on this promise and back many of the experiences you have seen introduced in the product today.
With the addition of data types, Excel has evolved to a world where cells can contain something much richer. Many of these solutions are powered by cells which most often contain (or evaluate to) just text or numbers. Data types More t han just text and numbersĬountless solutions have been built with Excel.
Onboard your add-in to the next generation of Excel experiences with data types, and reduce your time to market by reaping the benefits of our deeply integrated feature set. With this new set of capabilities, you can leverage the technology behind data types, which powers the experiences of Wolfram, Stocks, Geography, and other linked data types that can be found in Excel today. This helps solve a key problem developers have today with requirements around metadata associated with cells. We’re excited to announce new capabilities that let you programmatically create your own custom data types within Excel.