Advanced Scenarios and Additional Samples
This topic describes some advanced REST scenarios and additional samples. It provides links to Web pages where you can get more detailed information.
Note: The Excel Services REST API applies to SharePoint and SharePoint 2016 on-premises. For Office 365 Education, Business, and Enterprise accounts, use the Excel REST APIs that are part of the Microsoft Graph endpoint.
Passing Parameters to a Workbook
The Advanced Excel Services REST API Capabilities—Passing Parameters to a Spreadsheet sample shows you how to pass parameters in REST URLs, to modify the result that you get back. This sample demonstrates how, by passing parameters into the workbook, you are able to take advantage of the data and visualization, and you can also take advantage of the logic that is behind them.
Using URL Parameters with Excel Services Gadget
The Using Advanced REST Functionality with the Excel Services Gadget sample shows you how to use the Advanced Excel Services REST API Capabilities—Passing Parameters to a Spreadsheet sample with the Excel Services Gadget. You can use the gadget to display the results that you get from the REST API.
Embedding Workbook Data
The Excel Services REST API Examples sample shows you how to use the REST API to embed workbook data in interesting ways.
More REST API Syntax Examples
The Excel Services REST API Syntax blog entry provides additional Excel Services REST API syntax examples.
Ideas About How to Take Advantage of the REST API
The Excel Services REST API Examples blog entry provides additional ideas about what you can do with the REST API in Excel Services.