Interface IRangeInfo

Information about a specific range used by the formula parser.

Inherited Members

IAddressInfo.Address

System.Collections.Generic.IEnumerator<OfficeOpenXml.FormulaParsing.ICellInfo>.Current

System.Collections.IEnumerator.MoveNext()

System.Collections.IEnumerator.Reset()

System.IDisposable.Dispose()

System.Collections.Generic.IEnumerable<OfficeOpenXml.FormulaParsing.ICellInfo>.GetEnumerator()

Namespace: OfficeOpenXml.FormulaParsing

Assembly: EPPlus.dll

Syntax

public interface IRangeInfo : IAddressInfo, IEnumerator<ICellInfo>, IEnumerator, IDisposable, IEnumerable<ICellInfo>, IEnumerable

Properties

Dimension

The worksheet dimension if the range referres to an worksheet address, otherwise the size of the array.

Declaration

FormulaRangeAddress Dimension { get; }

Property Value

Type	Description
FormulaRangeAddress

IsEmpty

If the range is empty

Declaration

bool IsEmpty { get; }

Property Value

Type	Description
System.Boolean

IsInMemoryRange

Returns true if the range is not referring to the cell store, but rather keeps the data in memory.

Declaration

bool IsInMemoryRange { get; }

Property Value

Type	Description
System.Boolean

IsMulti

If the contains more than one cell with a value.

Declaration

bool IsMulti { get; }

Property Value

Type	Description
System.Boolean

IsRef

If the range is not valid and returns #REF!

Declaration

bool IsRef { get; }

Property Value

Type	Description
System.Boolean

Size

Size of the range, i.e. number of Cols and number of Rows

Declaration

RangeDefinition Size { get; }

Property Value

Type	Description
RangeDefinition

Worksheet

The worksheet

Declaration

ExcelWorksheet Worksheet { get; }

Property Value

Type	Description
ExcelWorksheet

Methods

GetNCells()

Get number of cells

Declaration

int GetNCells()

Returns

Type	Description
System.Int32	Number of cells

GetOffset(Int32, Int32)

Gets

Declaration

object GetOffset(int rowOffset, int colOffset)

Parameters

Type	Name	Description
System.Int32	rowOffset
System.Int32	colOffset

Returns

Type	Description
System.Object

GetOffset(Int32, Int32, Int32, Int32)

Get a subrange

Declaration

IRangeInfo GetOffset(int rowOffsetStart, int colOffsetStart, int rowOffsetEnd, int colOffsetEnd)

Parameters

Type	Name	Description
System.Int32	rowOffsetStart	row start index from top left
System.Int32	colOffsetStart	col start index from top left
System.Int32	rowOffsetEnd	row end index from top left
System.Int32	colOffsetEnd	col end index from top left

Returns

Type	Description
IRangeInfo	A new range with the requested cell data

GetValue(Int32, Int32)

Get the value from a cell

Declaration

object GetValue(int row, int col)

Parameters

Type	Name	Description
System.Int32	row	The Row
System.Int32	col	The Column

Returns

Type	Description
System.Object

IsHidden(Int32, Int32)

Returns true if the cell is hidden

Declaration

bool IsHidden(int rowOffset, int colOffset)

Parameters

Type	Name	Description
System.Int32	rowOffset
System.Int32	colOffset

Returns

Type	Description
System.Boolean