Microsoft has announced general availability of Excel Representational State Transfer(REST)API ,after a preview that began in last November - Developers can now use Excel for office 365 to transfer the data into the excel sheets, building dashboards, doing calculations and much more.
Microsoft in its build conference in March had come up with detailed plans for turning office 365 into more of platforms for developers. Like other Microsoft office 365 API’s , the new Excel one will be available through the Microsoft Graph and Microsoft’s unified API end point is now available for all its cloud services.
Inherently, The Excel API support to most of the businesses which use Excel to store tons of data- Using this service where developers can now perform calculation on this data for instant results. They call the data and perform calculations on Excel sheets for building reports and dashboards.
Gradually Microsoft is turning office into a data-rich development platform. Microsoft has now partnered with third party services to make API accessing easier. For Example Zapier users can now build integrations with excel for office 365 and business management services is offered by Sage to small and medium businesses, is now combining it with its accounting solution.
- Named Item
Important programming details related to Excel REST APIs are given in the below section:
- Authorization and scopes
- The basics
- Worksheet operations
- Chart operations
- Table operations
- Range operations
- Named items
- Understanding nulls in Excel API
- Blank Input and Output
- Error information
Excel REST API documentation is available here.