4.3 Retrieve a Range from a Workbook as an Atom Feed

  • Article

The following example illustrates the exchange of messages required for a client to retrieve a range from the Sales.xlsx workbook as an Atom feed.

Request

 GET /_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Ranges('C17%7CE17')?$format=atom HTTP/1.1
 Accept: application/atom+xml 
 Host: www.contoso.com

Response

 HTTP/1.1 200 OK
 Cache-Control: private
 Content-Type: application/atom+xml;charset=utf-8
 Server: Microsoft-IIS/7.5
 SPRequestGuid: a8fecc3b-a7ef-48e5-a988-b6152207fad1
 X-SharePointHealthScore: 4
 X-AspNet-Version: 2.0.50727
 X-Powered-By: ASP.NET
 MicrosoftSharePointTeamServices: 14.0.0.4732
 Date: Wed, 20 Jan 2010 19:50:23 GMT
 Content-Length: 1183
  
 <?xml version="1.0" encoding="utf-8"?>
 <entry 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">C17:E17</title>
   <id>http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Ranges('C17%7CE17')</id>
   <updated>2010-01-20T19:50:23Z</updated>
   <author>
     <name />
   </author>
   <link rel="self" href="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Ranges('C17%7CE17')?$format=atom" title="C17:E17" />
   <category term="ExcelServices.Range" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
   <content type="application/xml">
     <x:range name="C17:E17">
       <x:row>
         <x:c>
           <x:v>18167</x:v>
           <x:fv> $18,167 </x:fv>
         </x:c>
         <x:c>
           <x:v>14500</x:v>
           <x:fv> $14,500 </x:fv>
         </x:c>
         <x:c>
           <x:v>15408</x:v>
           <x:fv> $15,408 </x:fv>
         </x:c>
       </x:row>
     </x:range>
   </content>
 </entry>