Extending the Excel Services Programmability Framework
This first version of Excel Services, available in Microsoft Office SharePoint Server 2007, provides a simple yet-powerful programmability framework that you can customize to meet your business needs. However, because it is a first version, you might encounter certain limitations common to version 1 technologies and features. This article discusses how you can overcome these limitations, and how to also expand the following built-in functionality for your Excel Services solutions:
- Consumption of SharePoint lists
- Use of query tables on Excel Services
- Creation of external workbook references
- Exploitation of user-defined functions (UDFs) compatibility with the Microsoft Office Excel 2007 client application
In addition, the article shows how to use SQL write-back to further expand this built-in functionality.
Read More