Click to Rate and Give Feedback
MSDN
MSDN Library
Office Development
SDK Documentation
ExcelService Class
 CalculateA1 Method
Community Content
In this section
Statistics Annotations (1)
Collapse All/Expand All Collapse All
This page is specific to
The 2007 product release

Other versions are also available for the following:
ExcelService.CalculateA1 Method (Microsoft.Office.Excel.Server.WebServices)
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() _
)
Visual Basic (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)
C#
[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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
CalculateA1 will not calculate dependents or dependencies if run against a range.      Luis Bitencourt-Emilio - MSFT   |   Edit   |   Show History
Please note, if you specify the sheetName & rangeName parameters than CalculateA1 will *only* calculate the specified range, and will not calculate any dependencies outside of that range.
Tags What's this?: Add a tag
Flag as ContentBug
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker