top
Get exciting deals on all courses Use Coupon MM10 Click to Copy

Microsoft announced REST API feature for Excel

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.Objects in Excel Rest API are: - Worksheet - Range - Table - Chart - Named ItemImportant 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 - Unbounded-Range - Large-Range - Error informationExcel REST API documentation is available here.
Rated 4.0/5 based on 20 customer reviews
Normal Mode Dark Mode

Microsoft announced REST API feature for Excel

Geneva Clark
What's New
04th Aug, 2016
Microsoft announced REST API feature for Excel

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.

Objects in Excel Rest API are:

 - Worksheet

 - Range

 - Table

 - Chart

 - 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

 - Unbounded-Range

 - Large-Range

 - Error information

Excel REST API documentation is available here.

Geneva

Geneva Clark

Blog Author
Geneva specializes in back-end web development and has always been fascinated by the dynamic part of the web. Talk to her about modern web applications and she and loves to nerd out on all things Ruby on Rails.

Leave a Reply

Your email address will not be published. Required fields are marked *

SUBSCRIBE OUR BLOG

Follow Us On

Share on

other Blogs