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