In Internet Explorer, the page looks similar to the following figure. If you change the atom value to html, the URL returns an HTML fragment instead of an Atom feed. This parameter can also take the value of html. If you look at the URL to access a named range by using Atom feed, note that the final part of the URL contains a parameter called $format, which is set to atom. Using XML gives you an easier way to get data out of an Excel range so that you can use it in your application. If the value in the cell is a number instead of a string, the value element contains that information. If the value is of type string in the workbook, the formatted value element is the only element under. Represents the value as it is formatted by Excel. Represents the container of the returned range. Following are the XML elements of interest:

The feed item contains XML that represents the data inside the range. But viewing the source of the page shows the XML that the feed item contains: Internet Explorer cannot show a single-entry Atom feed item. If you click SampleNamedRange in the range discovery page, you navigate to the following URL: Note that, in Internet Explorer, the resulting page looks like an error, as shown in the following screen shot.Įxcel Services REST range discovery using Atom To correctly reference sheet names that contain special characters, the basic guideline is 'see what the Excel client does' when referencing a formula to a sheet with special characters and follow that example.Įxcel Services REST named range discovery The sampleWorkbook.xlsx contains one named range, SampleNamedRange, as shown in the following screen shot:Ĭharacters like '?' and '#' are unsupported. Therefore, for a workbook with the file name sampleWorkbook.xlsx that is saved to /Docs/Documents/sampleWorkbook.xlsx, following is the URI to the model page: Using the discovery mechanism described in Discovery in Excel Services REST API, if you click on the Ranges Atom feed on the model page on the server, ( /_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model), it displays a page that shows all the named ranges in the workbook. The second is to get HTML fragments from inside a browser.Īs described in the Discovery in Excel Services REST API topic, the REST URL to the model page using discovery is: It also can synchronize with your feeds in Google Reader and the Facebook news feed. The first is used mainly to enable applications to get to the raw-data of a workbook, that is, the raw numbers or values from a worksheet. This is the official website of RSS Bandit, a free, open source application that allows you to read news feeds (both RSS and Atom feeds), supports NNTP and download podcasts from your desktop. The REST API in Excel Services supports two mechanisms for getting ranges. For Office 365 Education, Business, and Enterprise accounts, use the Excel REST APIs that are part of the Microsoft Graph endpoint. The Excel Services REST API applies to SharePoint and SharePoint 2016 on-premises.

Atom feed reader