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)

Syntax

'Declaration
<WebMethodAttribute> _
Public Sub CalculateA1 ( _
    sessionId As String, _
    sheetName As String, _
    rangeName As String, _
    <OutAttribute> ByRef status As Status() _
)
'Usage
Dim instance As ExcelService
Dim sessionId As String
Dim sheetName As String
Dim rangeName As String
Dim status As Status()

instance.CalculateA1(sessionId, sheetName, _
    rangeName, status)
[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 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.

Remarks

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 Nullis 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.

See Also

Reference

ExcelService Class

ExcelService Members

Microsoft.Office.Excel.Server.WebServices Namespace