Export (0) Print
Expand All

ExcelService.CalculateA1 Method

Calculates formulas in the open workbook, or in a range within the workbook, using the Excel "A1" range specification.

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

[WebMethodAttribute]
public void CalculateA1(
	string sessionId,
	string sheetName,
	string rangeName,
	out Status[] status
)

Parameters

sessionId
Type: System.String

The Excel Web Services session ID.

sheetName
Type: System.String

The name of the sheet that you want to reference. Sheet name length is limited to 31 characters.

rangeName
Type: System.String

A range name can be a range reference, a named range, or a named data object. A rangeName string can contain a sheet name; for example, "Sheet1!A1:G17".

status
Type: []

Alert information.

To calculate a range in the workbook, use range coordinates to select the range. If a range is not specified, the entire workbook will be calculated.

If you specify the sheetName and rangeName parameters, the CalculateA1 method will only calculate the specified range, and will not calculate any dependencies outside of that range.

If the sheetName parameter is empty (that is, an Empty string or Null is passed in) and the rangeName parameter is empty, the entire workbook will be calculated.

If the sheetName parameter is non-empty, but the rangeName parameter is empty, the entire sheet will be calculated.

Show:
© 2014 Microsoft