Sunday, November 18, 2007

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

1 comment:

Anonymous said...

Keep up the good work.