Introduction to the SharePoint 2013 Excel Services REST API

The REST API in Excel Services is a new addition to Microsoft SharePoint Server 2010. The REST API allows you to access a workbook part or element directly by using a URL.

One, REST service is based on two requirements:

Addressing scheme for locating network resources

Methods used to return representations of these resources

The three components of the REST URL base uri are:

REST aspx page uri:http://<servername>/_vti_bin/excelrest.aspx

Workbook Location:/docs/documents/sampleworkbook.xlsx

Resource location:/model/ranges (' Nameofthenamedrange ')

Third, the API simple application and Example:

1. Cell Display:

Example: Http://URL/_vti_bin/ExcelRest.aspx/DocLib1/ExcelTest.xlsx/model/Ranges (' A1 ')

Attached: Complete Excel

2. Chart Display

Example: Special description "%e5%9b%be%e8%a1%a8%201" = = "Figure 1" means, after URL encoding

Http://URL/_vti_bin/ExcelRest.aspx/DocLib1/ExcelTest.xlsx/Model/Charts ('%e5%9b%be%e8%a1%a8%201 ')

Attached: The original Excel screenshot screen