ExcelService.SetCalculationOptions Method

SharePoint 2010

Changes the calculation mode setting for workbooks.

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

[WebMethodAttribute]
public void SetCalculationOptions(
	string sessionId,
	WorkbookCalculation calcType,
	out Status[] status
)

Parameters

sessionId
Type: System.String

The Excel Web Services session ID.

calcType
Type: Microsoft.Office.Excel.Server.WebServices.WorkbookCalculation

The CalculationOptions type.

status
Type: []

Alert information.

The changes are temporary, that is, for the duration of the session. The changes are not saved even if the workbook is saved to its original or an alternate location. This method works in view and edit modes.

The calculation options you can use are Automatic, Semiautomatic and Manual. Automatic calculates workbook automatically. Semiautomatic calculates workbook automatically except for data tables. Manual disables automatic workbook calculation and requires an explicit call to one of the calculate methods to calculate: Calculate(String, String, RangeCoordinates, []),

Show: