Calculates formulas in the open workbook, or in a range within the workbook, using the Excel "A1" range specification.
This method is not CLS-compliant.
Namespace: Microsoft.Office.Excel.Server.WebServices
Assembly: Microsoft.Office.Excel.Server.WebServices (in microsoft.office.excel.server.webservices.dll)
Visual Basic (Declaration)
<WebMethodAttribute> _
Public Sub CalculateA1 ( _
sessionId As String, _
sheetName As String, _
rangeName As String, _
<OutAttribute> ByRef status As Status() _
)
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
The Excel Web Services session ID.
- sheetName
The name of the sheet you want to reference. Sheet name length is limited to 31 characters.
- rangeName
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
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 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.