Skip to content

Latest commit

 

History

History
135 lines (107 loc) · 3.7 KB

accessing-a-schema.md

File metadata and controls

135 lines (107 loc) · 3.7 KB
titledescriptionms.datems.assetidms.localizationpriority
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.
06/03/2022
02613912-36f6-4edc-a915-165d12e60bc8
high

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"?> <entryxml: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"> <titletype="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> <linkrel="self"href="http://myserver/_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model/Ranges('Sheet1!A1%7CH3')?$format=atom"title="Sheet1!A1:H3" /> <categoryterm="ExcelServices.Range"scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <contenttype="application/xml"> <x:rangename="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>
close