Overview of data types in Excel add-ins (preview)
Data types APIs are currently only available in public preview. Preview APIs are subject to change and are not intended for use in a production environment. Do not use preview APIs in a production environment or within business-critical documents.
Some of the data types APIs, such as
Range.valuesAsJSON are in active development and are not yet available in public preview. This article is intended as a conceptual introduction. Concepts described in this article that are not yet in public preview will be released to preview soon.
Data types and custom functions
The custom functions integration with data types is currently in public preview and is only compatible with Office on Windows. Preview features are subject to change and are not intended for use in a production environment. We recommend that you try them out in test and development environments only. Do not use preview features in a production environment or within business-critical documents.
To try out the custom functions integration with data types in Office on Windows, you must have an Excel build number greater than or equal to 16.0.14623.20002. To use this feature, you need to join the Office Insider Program and then choose the Beta Channel Insider level. To learn more, see Join the Office Insider Program.