Accessing a Schema
This topic shows one example of how you can access and look at a schema for the REST service in Excel Services. This topic assumes that you have read Sample URI For Excel Services REST API.
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.
Viewing a Schema
In the browser address bar, type the URI to an Atom XML feed by using a URI, as follows:
http://myserver/_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model/Ranges('Sheet1!A1|H3')?$format=atom
Right-click the webpage, and then click View Source.
You should see a schema that looks similar to the following example:
<?xml version="1.0" encoding="utf-8"?>
<entry xml:base="http://excel.live.com/REST" xmlns:x="http://schemas.microsoft.com/office/2008/07/excelservices/rest" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservice" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom">
<title type="text">Sheet1!A1:H3</title>
<id>http://myserver/_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model/Ranges('Sheet1!A1%7CH3')</id>
<updated>2009-06-25T00:41:37Z</updated>
<author>
<name />
</author>
<link rel="self" href="http://myserver/_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model/Ranges('Sheet1!A1%7CH3')?$format=atom" title="Sheet1!A1:H3" />
<category term="ExcelServices.Range" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<content type="application/xml">
<x:range name="Sheet1!A1:H3">
<x:row>
<x:c>
<x:fv>Name </x:fv>
</x:c>
<x:c>
<x:fv>Name </x:fv>
</x:c>
<x:c>
<x:fv>Exchange </x:fv>
</x:c>
<x:c>
<x:fv>Symbol </x:fv>
</x:c>
<x:c>
<x:fv>Last Trade </x:fv>
</x:c>
<x:c />
<x:c>
<x:fv>Change </x:fv>
</x:c>
<x:c>
<x:fv>Mkt Cap</x:fv>
</x:c>
</x:row>
<x:row>
<x:c>
<x:fv>Microsoft Corporation </x:fv>
</x:c>
<x:c>
<x:fv>Microsoft Corporation </x:fv>
</x:c>
<x:c>
<x:fv> </x:fv>
</x:c>
<x:c>
<x:fv>MSFT </x:fv>
</x:c>
<x:c>
<x:v>26.25</x:v>
<x:fv>26.25</x:fv>
</x:c>
<x:c />
<x:c>
<x:fv>-0.23 (-0.87%) </x:fv>
</x:c>
<x:c>
<x:v>239670000000</x:v>
<x:fv> $239,670,000,000 </x:fv>
</x:c>
</x:row>
<x:row>
<x:c />
<x:c />
<x:c>
<x:fv> </x:fv>
</x:c>
<x:c />
<x:c>
<x:v>15.58</x:v>
<x:fv>15.58</x:fv>
</x:c>
<x:c />
<x:c>
<x:fv>-1.38 (-8.14%) </x:fv>
</x:c>
<x:c>
<x:v>21590000000</x:v>
<x:fv> $21,590,000,000 </x:fv>
</x:c>
</x:row>
</x:range>
</content>
</entry>
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for