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
Implements¶
IAddressInfo
IDisposable
IEnumerable
IEnumerable<ICellInfo>
IEnumerator
IEnumerator<ICellInfo>
Properties¶
Dimension¶
The worksheet dimension if the range refers to an worksheet address, otherwise the size of the array.
Property Value¶
IsEmpty¶
If the range is empty
Property Value¶
IsInMemoryRange¶
Returns true if the range is not referring to the cell store, but rather keeps the data in memory.
Property Value¶
IsMulti¶
If the range contains more than one cell with a value.
Property Value¶
IsRef¶
If the range is not valid and returns #REF!
Property Value¶
Size¶
Size of the range, i.e. number of Cols and number of Rows
Property Value¶
Worksheet¶
The worksheet
Property Value¶
Methods¶
GetAddressDimensionAdjusted(int)¶
Get the address adjusted inside the dimension of the worksheet.
Parameters¶
index int
The index of the address.
Returns¶
The address adjusted within the dimension of the worksheet.
GetNCells()¶
Get number of cells
Returns¶
Number of cells
GetOffset(int, int)¶
Gets
Parameters¶
rowOffset int
colOffset int
Returns¶
GetOffset(int, int, int, int)¶
Get a subrange
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¶
A new range with the requested cell data
GetRangeInfoByValue()¶
Gets dimension of rang excluding null values
Returns¶
GetValue(int, int)¶
Get the value from a cell
Parameters¶
row int
The Row
col int
The Column
Returns¶
IsHidden(int, int)¶
Returns true if the cell is hidden
Parameters¶
rowOffset int
colOffset int