Excel Services 2010 REST API

  • Article

Excel services in SharePoint 2010 are accessible via REST API. Assuming you have a File.xlsx under Shared Documents in the server you may use the following URL with the table below that enumerates the options and the parameters available:
https://server/_vti_bin/ExcelRest.aspx/Shared%20Documents/File.xlsx

 

/Model

?atom, ?workbook

/Model/Ranges

?atom

/Model/Ranges(‘RangeName’)

?atom, ?html

/Model/Charts

?atom

/Model/Charts(‘ChartName’)

?atom, ?image

/Model/Tables

?atom

/Model/Tables(‘TableName’)

?atom, ?html

/Model/PivotTables

?atom

/Model/PivotTables(‘PivotTableName’)

?atom, ?html