ExcelService.GetRangeA1 Method

Gets calculated values from a range in the open 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 Function GetRangeA1 ( _
    sessionId As String, _
    sheetName As String, _
    rangeName As String, _
    formatted As Boolean, _
    <OutAttribute> ByRef status As Status() _
) As Object()
Dim instance As ExcelService
Dim sessionId As String
Dim sheetName As String
Dim rangeName As String
Dim formatted As Boolean
Dim status As Status()
Dim returnValue As Object()

returnValue = instance.GetRangeA1(sessionId, _
    sheetName, rangeName, formatted, _
public Object[] GetRangeA1(
    string sessionId,
    string sheetName,
    string rangeName,
    bool formatted,
    out Status[] status


  • 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".
  • formatted
    Type: System.Boolean
    true to return formatted strings.
    false to return raw values.
  • status
    Type: []
    Alert information.

Return Value

Type: []
Array of values for the requested range.


This method returns an array of values from a range of cells, using a range name string to select the range.

A range can be a range reference, a named range, or a named data object.

The returned array has the exact dimensionality of the requested range. Null objects represent empty cells.

Formatted values respect the cell's format or the default format, but are independent of any layout or grid modifications. Specifically, there is no concept of cell width for a value returned through the API, which means:

  • No number signs (####) are returned if the cell width is too small to display the formatted value.

  • In general format, no "precision displayed" rounding is done.

  • No fill-in is done, even if a fill-in character is defined in the cell's format.

Excel Web Services returns a jagged array of type "object". Each entry represents a row, and is defined as an array of type "object"; each entry is mapped to one cell value.

A null object represents an empty cell. The array is jagged technically, but should be rectangular in dimensionality, meaning that all row arrays should have the same number of entries.

If the formatted parameter is set to true, this method will return the Empty string for empty cells.

If the formatted parameter is set to false, this method will return Null for empty cells.

See Also


ExcelService Class

ExcelService Members

Microsoft.Office.Excel.Server.WebServices Namespace