Export (0) Print
Expand All

ExcelService.SetCalculationOptions Method

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, []),

Community Additions

ADD
Show:
© 2014 Microsoft