Version

GetCell(String,CellReferenceMode) Method

Gets the cell at the specified address or name.
Syntax

Parameters

address
The address or name of the cell.
cellReferenceMode
The cell reference mode to use to parse the cell address.

Return Value

A cell represented by the specified address or name.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionaddress is null.
System.ComponentModel.InvalidEnumArgumentExceptioncellReferenceMode is not defined in the CellReferenceMode enumeration.
System.ArgumentExceptionaddress is not a valid name or a valid cell or region address in the specified cell reference mode.
System.InvalidOperationExceptionaddress is a relative R1C1 address. The overload taking an origin cell must be used to resolve relative R1C1 references.
Remarks

If one or more region references are specified instead of a cell reference, the top-left cell of the first region will be returned.

If a name is specified, it must refer to a cell or region in the Worksheet and it must be scoped to the Workbook or the Worksheet or null will be returned.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also