Custom data types With its new JavaScript API in Excel which will be available in preview later this month, Microsoft is making it possible for developers to create their own custom data types.

Microsoft is opening up Excel to developers with a new JavaScript API. It will let developers use custom data types like images, cards, and arrays.

Spark SQL, part of Apache Spark, is used for structured data processing by running SQL queries on Spark data. Srini Penchikala discusses Spark SQL module & how it simplifies data analytics using SQL.

These new data types allow you to place structured data within a single cell. Microsoft announced a major update to Excel that brings the option to create your own data types.

These can all be backed up by users' own custom data sources. Users will also be able to make custom functions that can use these data types as both inputs and outputs.

Microsoft is bringing custom data types to Excel. Businesses and consumers will be able to import structured data into a single cell and reference it throughout a spreadsheet.

Virtual tables connect the Power Platform to business data stuck in silos, enriching it to use with workflows, AI tools and custom apps.