Advanced Scenarios and Additional Samples

This topic describes some advanced REST scenarios and additional samples. It provides links to webpages 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.