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 |
