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 : IEnumerator<ICellInfo>, IEnumerator, IDisposable, IEnumerable<ICellInfo>, IEnumerableProperties
Address
The address.
Declaration
ExcelAddressBase Address { get; }Property Value
| Type | Description |
|---|---|
| ExcelAddressBase |
IsEmpty
If the range is empty
Declaration
bool IsEmpty { 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 |
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 |
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 |