Interface IRangeInfo
Information about a specific range used by the formula parser.
Inherited Members
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>, IEnumerableProperties
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 range 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 |