OFC305 - Creating Rich Business Applications Using MOSS, MS Excel and Excel Services – Dan Parish

What Excel Services is and What Excel Services is Not. 

The only thing that I got out of this is the impression that if we were to run Excel Web Services, we might be able to do away with the FarPoint control?  There was too much setup to integrate it to a SharePoint Form in my opinion.

• For the exploration and consumption of excel workbooks
• Access via Thin Rendering in Browser, Excel 2007 Client, or Custom Applications

Architecture – Web Front End(Excel Web Access, Excel Web Services) Application Server (UDFs and Excel Calculation Services)

Demo:   SharePoint Lists, Excel Services (UDFs) and Excel Web Access Web Part

Step 1 – Create SharePoint List and UDF (not SQL Server UDF).

Step 1 Easy just create a form.  UDF .  Add a reference to Excel Services UDF Data Services and Microsoft SharePoint.  Decorate your class with a UDFClass attribute.  And set isvilotile to true to cause it to refresh every time you call it.  ReturnPersonalInformation = true to be able to privatize the results.

Publish to SharePoint.  Hookup UDF to Excel Workbook Sheets.