GetRegions(String,CellReferenceMode) Method

Gets the regions at the specified address or name.

Syntax

C#

public WorksheetRegion[] GetRegions( 
   string address,
   CellReferenceMode cellReferenceMode
)

Parameters

address

The address or name of the region.

cellReferenceMode

The cell reference mode to use to parse the region address.

Return Value

An array of regions 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

The address can be a list of references, each one referring to a separate region on the Worksheet.

If a cell or single region reference is specified instead, an array of one region at the address will be returned.

If a name is specified, it must refer to cells or regions 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+