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?