Interface IRangeInfo

Namespace

OfficeOpenXml.FormulaParsing

Assembly

EPPlus.dll

Information about a specific range used by the formula parser.

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

Inherited Members

IAddressInfo.Address

IEnumerator<ICellInfo>.Current

IEnumerator.MoveNext()

IEnumerator.Reset()

IDisposable.Dispose()

IEnumerable<ICellInfo>.GetEnumerator()

Properties

Dimension

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

FormulaRangeAddress Dimension { get; }

Property Value

FormulaRangeAddress

IsEmpty

If the range is empty

bool IsEmpty { get; }

Property Value

bool

IsInMemoryRange

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

bool IsInMemoryRange { get; }

Property Value

bool

IsMulti

If the range contains more than one cell with a value.

bool IsMulti { get; }

Property Value

bool

IsRef

If the range is not valid and returns #REF!

bool IsRef { get; }

Property Value

bool

Size

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

RangeDefinition Size { get; }

Property Value

RangeDefinition

Worksheet

The worksheet

ExcelWorksheet Worksheet { get; }

Property Value

ExcelWorksheet

Methods

GetNCells()

Get number of cells

int GetNCells()

Returns

int

Number of cells

GetOffset(int, int)

Gets

object GetOffset(int rowOffset, int colOffset)

Parameters

rowOffset int

colOffset int

Returns

object

GetOffset(int, int, int, int)

Get a subrange

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

Parameters

rowOffsetStart int

row start index from top left

colOffsetStart int

col start index from top left

rowOffsetEnd int

row end index from top left

colOffsetEnd int

col end index from top left

Returns

IRangeInfo

A new range with the requested cell data

GetValue(int, int)

Get the value from a cell

object GetValue(int row, int col)

Parameters

row int

The Row

col int

The Column

Returns

object

IsHidden(int, int)

Returns true if the cell is hidden

bool IsHidden(int rowOffset, int colOffset)

Parameters

rowOffset int

colOffset int

Returns

bool