Chapter 17

Developing Excel Applications in SharePoint 2013


  • Building Office 2013 apps with Visual Studio
  • Consuming Excel Services OData and REST APIs
  • Using Excel Services Web Access JavaScript
  • Adding and accessing rich data with Excel
  • Creating Excel Services UDF functions


The code downloads for this chapter are found at on the Download Code tab. The code is in the chapter 17 download and individually named according to the names throughout the chapter.

Excel is one of the most-used application platforms for constructing business applications. Excel provides the ability to have complex business logic along with displaying data and rich chart support. It is no surprise that Microsoft wanted to take those experiences a step further and enable these Excel applications for all users to consume and interact with. To accomplish this Microsoft introduced Excel Services with SharePoint 2007 and has been improving the experience with each version. Now in SharePoint 2013 the new features are more focused on the web-based technologies and enabling developers to take advantage of the rich set of APIs.

Excel Services can be thought of as the engine that drives Excel on the web. It is responsible for displaying workbook data, tables, and charts or content, making web-based calls to data, and running large calculations on an application server in your SharePoint Farm. Excel Services ...

Get Professional SharePoint 2013 Development now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.