GetRegion(String,WorksheetCell) Method

Gets the region at the specified address or name.

Syntax

C#

public WorksheetRegion GetRegion( 
   string address,
   WorksheetCell originCell
)

Parameters

address

The address or name of the region.

originCell

The origin for resolving relative R1C1 references.

Return Value

A region represented by the specified address or name.

Exceptions

Exception	Description
System.ArgumentNullException	address is null.
System.ArgumentException	address is not a valid name or a valid cell or region address in the workbook's cell reference mode.
System.InvalidOperationException	address is a relative R1C1 address and originCell is null. An origin cell must be specified to resolve relative R1C1 references.

Remarks

The CellReferenceMode of the workbook will be used to parse the region address.

If a cell reference is specified instead of a region reference, a 1x1 region containing the cell at the address will be returned.

If a list of references is specified, the region specified by the first reference will be returned.

The origin cell specified will not be used if a name is specified, if the workbook has an A1 cell reference mode, or if an absolute R1C1 address is specified.

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+