Excel REST使用方法

REST 语法：http://server/_vti_bin/ExcelRest.aspx/Shared%20Documents/File.xlsx/Model/

资源名称	访问内容…
/Model	The workbook (the binary or the available feeds)
/Model/Ranges	List of named ranges in a workbook (some of them)
/Model/Ranges('RangeName')?$format=html	Specific range.
/Model/Charts	List of charts
/Model/Charts('ChartName')?$format=image	Specific Chart
/Model/Tables	List of tables (Lists)
/Model/Tables('TableName')?$format=html	Specific table
/Model/PivotTables	List of PivotTables
/Model/PivotTables('PivotName')?$format=html	Specific PivotTable
Model/Ranges('('Sheet1!A1|D4'')?$format=html	Normal Range
Model/Charts('ChartName')?$format=image&Ranges('FiscalYear')=2008&Ranges('Sheet1!A1')=0.50	Insert Values

转载于:https://www.cnblogs.com/dwang/archive/2010/12/08/1899983.html