Export (0) Print
Expand All

ExcelService.GetCellA1 Method

Gets a calculated value from a cell 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 Object GetCellA1(
	string sessionId,
	string sheetName,
	string rangeName,
	bool formatted,
	out Status[] status
)

Parameters

sessionId
Type: System.String

The Excel Web Services session ID.

sheetName
Type: System.String

The name of the sheet that 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 returns formatted strings.

false returns raw values.

status
Type: []

Alert information.

Return Value

Type: System.Object
The value from a single cell, using a range name string to select the cell.

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

The API checks only the result dimensions, not the dimensions of the requested range. For example, the caller might ask for a 2x3 range, and Excel Calculation Services might return a 1x1 range (for example, because of hidden cells).

Show:
© 2014 Microsoft