Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Building Custom Solutions
Building Custom Solutions
Excel Services is a strong product out-of-the-box, but you can always customize it to better suit the
unique needs of your enterprise. Multiple programmability surface areas exist that you can
leverage individually or together to extend the capabilities of Excel Services. This chapter introduces
concepts geared toward extending the feature set through custom solutions.
In this chapter, you do the following:
Become familiar with the Excel Services web service methods
Learn how to create an application that makes Excel Services web service calls
Learn how to author and deploy an Excel Services user-defined function (UDF)
Become familiar with calling a UDF from an Excel workbook
Learn about customizing xlviewer.aspx
Excel Services Web Service
An important feature of Excel Services is its web service, also referred to as the API. This is a
powerful programmability feature that enables solution developers to harness the power of Excel Services.
One benefit of the web service is that developers are not tied to a specific technology when building
solutions that interact with the API. The API exposes a wide range of methods that you can use to
manage workbooks through Excel Services.
This chapter covers some of the terminology and good-to-know information about the API. With
that information, you can then move toward creating a managed-code solution to make API calls.
The chapter focuses on each of the public API methods by explaining their signatures, as well as
by providing a code snippet on making calls with the methods. At the conclusion of the chapter,
a comprehensive API solution is shown that ties together the API concepts.