On
December 15 2006, Dan Parish, the Microsoft Program Manager on the Excel
Services team gave a web cast for the Australian SharePoint User Groups. The web
cast is now available to view at your leisure by clicking
here.
Dan has provided a number of links
and code samples from the web cast that you might find useful:
Developer Documentation
The following links deal with ways to code against Excel
Services' Web Service and create Excel Services User Defined Functions.
|
|
Cum Grano Salis
|
A blog by Shahar Prish, one of
the Excel Services developers, about how to
build custom solutions using Excel Services Web
Services and User Defined Functions. |
|
|
Microsoft Office SharePoint
Server 2007 (Beta) SDK
|
Contains in depth information and
samples about how to work with Excel Services
Web Services, how to build SharePoint filters
that can work with Excel Services, and more. |
|
|
SharePoint Server 2007 Developer
Portal
|
The home for SharePoint Server
2007 (which includes Excel Services) developer
related information. |
|
|
Downloadable SharePoint Server
2007 SDK
|
If you want to download the
Microsoft Office SharePoint Server 2007 (Beta)
SDK for use locally, you can get a downloadable
version here. |
|
|
LuisBE on Services
|
A blog by Luis Bitencourt-Emilio,
one of the Excel Services testers, about how to
do all the things you want Excel Services to do,
but that aren't provided out of the box. |
|
|
Excel Services Technical Overview
|
Learn about Excel Services and
how it works with Excel 2007 to provide robust
and secure shared workbook solutions. Read about
Excel Services extensibility features,
architecture, performance optimization, and
deployment. |
|
|
Using Excel Web Services in a
SharePoint Web Part
|
Learn how to create a Web Part
that can be deployed to Microsoft Office
SharePoint Server 2007 and call Excel Web
Services to perform custom calculations. |
|
|
Deploying and Optimizing a
SharePoint Web Part That Calls Excel Web
Services
|
Learn how to deploy a Web Part by
using deployment CABs, and how to improve the
appearance and configurability of a Web Part. |
|
|
SharePoint Server 2007 Sample:
Web Part That Calls Excel Web Services
|
This download contains a sample
solution that demonstrates how to create a Web
Part that calls Excel Web Services to perform
custom calculations. It includes a deployment
package sample that can be deployed to Microsoft
Office SharePoint Server 2007. |
|
|
|
The
following (unsupported) code samples from Dan Parish deal with two common Excel
Services requirements:
1. Remove
all comments, drawing objects, etc.
2. Remove
data validation
1)
Sub
RemoveShapes()
'Find all shapes in the workbook
num_shapes = 0
For Each w
In Worksheets
For Each s
In w.Shapes
' Check to see if it is not a chart
' (note that this is just the Beta 2 return value)
If s.AutoShapeType <> -2
Then
num_shapes = num_shapes + 1
End If
Next
Next
' Check if we found anything
If (num_shapes > 0)
Then
' Ask the user if we should delete them
result = MsgBox("Found " & num_shapes &
" non-chart shapes. Delete elements?",
vbYesNo, "Delete found elements ")
If (result = vbYes)
Then
For Each w
In Worksheets
For
Each s In w.Shapes
' Delete all non-chart shapes
If s.AutoShapeType <> -2
Then
s.Delete()
End
If
Next
Next
End If
Else
MsgBox("No shapes found.")
End If
End
Sub
2)
Sub
RemoveDataValidation()
For Each w
In Worksheets
w.Range("A1:XFD1048576").Validation.Delete
Next w
End Sub
Also, check out Shahar’s post
Another tool for working around Excel Services not supporting QueryTable
back to home