Excel Services (How Do I...)

Article
10/16/2013

Use the links in this topic to quickly find the answers to your most frequent programming questions about working with Excel Services in Microsoft Office SharePoint Server 2007.

How Do I…

Excel Web Services

Set credentials?
Get an entire workbook or snapshot?
Save a workbook?
Get values from ranges?
Set values of ranges?
Specify range addresses?
Specify sheet names?
Use the CloseWorkbook method call asynchronously?
Refresh data?
Use the SubCode property to capture error codes?
Develop a custom application by using Excel Web Services?
Create the Web Service Client project?
Add a Web reference?
Access a Web Service?
Build and test an application?
Add Excel Web Parts to pages programmatically?(Office Visual How To)
Develop custom applications by using Excel Web Services? (Office Visual How To)

Excel Services User-Defined Functions (UDFs)

Enable UDFs?
Create a UDF that calls a Web Service?
Access an external data source by using a UDF?
Deploy UDFs by using Windows SharePoint Services solutions?
Restrict UDF Code Access Security permissions?
Develop a managed-code UDF?
Create a project and add a UDF reference?
Create a managed-code UDF?
Deploy and enable UDFs?
Test and call UDFs from cells?
Create managed-code UDFs for Excel Services? (Office Visual How To)

Excel Web Access

Add an Excel Web Access Web Part to a page?
Locate and copy Microsoft.Office.Excel.WebUI.dll?
Retrieve a workbook or a snapshot of a workbook in Excel Services? (Office Visual How To)

General

Trust a location?
Trust workbook locations by using script?
Save from Excel client to the server?
Save to the server to prepare for programmatic access?
Catch exceptions?

Excel Services (How Do I...)

How Do I…

See Also

Reference

Concepts

Additional resources