ExcelService.SaveWorkbookCopy Method

SharePoint 2010

Saves a workbook using a different file name and/or to a different SharePoint document library.

Namespace:  Microsoft.Office.Excel.Server.WebServices
Assembly:  Microsoft.Office.Excel.Server.WebServices (in Microsoft.Office.Excel.Server.WebServices.dll)

public void SaveWorkbookCopy(
	string sessionId,
	string workbookPath,
	WorkbookType workbookType,
	SaveOptions saveOptions,
	out Status[] status


Type: System.String

The Excel Web Services session ID.

Type: System.String

The location of the workbook file to open. Must be an absolute path.

Maximum size is 4096 characters.

Type: Microsoft.Office.Excel.Server.WebServices.WorkbookType

Defines the different modes (Full Workbook, FullSnapshot, and PublishedItemsSnapshot) used to get a workbook. Also see the WorkbookTypeenumerator.

Type: Microsoft.Office.Excel.Server.WebServices.SaveOptions

Specifies whether to overwrite an existing file. If true to overwrite; otherwise false.

Type: []

Alert information.

This method only saves to a SharePoint document library in the same domain. The workbookPath cannot be a UNC file path. The document library must be a trusted location. This method works in view or in edit mode.

You can specify the workbook file format (.xlsx, .xlsb, .xlsm) as part of the file name. This method does not close the session. To close the session, you must explicitly call the CloseWorkbook(String, []) method.

This method preserves the workbook settings on recalculation before saving the workbook. To change workbook settings, use the SetCalculationOptions(String, WorkbookCalculation, []) method.