Microsoft Excel is getting a whole lot more customization

Microsoft is expanding is spreadsheet software with the addition of a new API which will allow developers to create their own custom data ...

Microsoft is expanding is spreadsheet software with the addition of a new API which will allow developers to create their own custom data types in Excel.

Countless solutions have been built in Excel using just text and numbers but over the course of its multi-year journey, the software giant has expanded the types of data users can work with natively in its software. This began with the introduction of Microsoft's Stocks and Geography “data types” back in 2018 and these linked data types allow for a single cell in a spreadsheet to contain a live, connected and rich set of information about objects like stocks, currencies, cities and countries.

Last year though, Microsoft expanded on this vision by allowing customers to work with their own data as a data type. As a result, it became possible to automatically connect data from its Power BI business intelligence tool with Excel and this integration made published Power BI data discoverable in Excel as a structured data type.

Now Microsoft is taking linked data types to a whole new level yet again with the introduction of a new JavaScript API in Excel.

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.

These new custom data types can contain images, entities, arrays and formatted number values all backed by their own custom data sources. These new Excel data types can also be used as both inputs and outputs.

Now developers will able to organize complex data as objects and present this data to users in more natural ways while still providing easy access to the full information users require for analysis or reporting according to a new blog post from Microsoft.

Excel users can also create their own add-ins or extend previously existing ones to utilize the power of data types. Custom data types can even be shared across an entire organization and add-ins or other solutions can be created that are capable of connecting data types to a company's own service or data.

Microsoft's new Javascript API will be available in public preview when the next version of the Office.JS Preview APIs are deployed near the end of this month. However, to create custom data types, users will need the Office.JS Preview API along with an Insiders Beta build of Excel for Windows or Mac.

We've also highlighted the best spreadsheet software and the best business intelligence tools

from TechRadar - All the latest technology news https://ift.tt/2Yh3RRy



Apps,3855,Business,148,Camera,1154,Earn $$$,1,Gadgets,1739,Games,924,Innovations,1,Mobile,1695,Paid Promotions,3,Promotions,3,Technology,7934,Trailers,795,Travel,36,Trendly News,22559,Video,4,XIAOMI,12,
Trendly News | #ListenNow #Everyday #100ShortNews #TopTrendings #PopularNews #Reviews #TrendlyNews: Microsoft Excel is getting a whole lot more customization
Microsoft Excel is getting a whole lot more customization
Trendly News | #ListenNow #Everyday #100ShortNews #TopTrendings #PopularNews #Reviews #TrendlyNews
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy