GetCell(String,CellReferenceMode) Method

Gets the cell at the specified address or name.

Syntax

C#

public WorksheetCell GetCell( 
   string address,
   CellReferenceMode cellReferenceMode
)

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

Exception	Description
System.ArgumentNullException	address is null.
System.ComponentModel.InvalidEnumArgumentException	cellReferenceMode is not defined in the CellReferenceMode enumeration.
System.ArgumentException	address is not a valid name or a valid cell or region address in the specified cell reference mode.
System.InvalidOperationException	address 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+