Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
CHAPTER 7: Excel Services > Using REST Services
Using REST Services
The Excel REST service is another powerful technique for integrating data into your SharePoint site. The term REST is an acronym for Representational State Transfer. It is an architectural style of exposing data to clients. You access data by providing the address of the data you're looking for. A UNC file location is a good example of a REST-like addressing scheme where the address includes theserver, disk drive, folder, sub-folders, and finally the filename.
With the Excel REST services, you can publish an Excel spreadsheet to your SharePoint site and then use the REST API to programmatically extract parts of the document into an existing web page.
Note The techniques I have demonstrated so far in this chapter are available in both the Small Business (P) and Enterprise (E) plans. However, the Excel REST service is only available in the Enterprise plans. For this demonstration you will need to publish an Excel spreadsheet to an Enterprise account.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint