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.StringThe Excel Web Services session ID.
sheetName
Type: System.StringThe name of the sheet that you want to reference. Sheet name length is limited to 31 characters.
rangeName
Type: System.StringA 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 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.