public class ReferredArea
Property Getters/Setters Summary | ||
---|---|---|
int | getEndColumn() | |
The end column of the area.
|
||
int | getEndRow() | |
The end row of the area.
|
||
java.lang.String | getExternalFileName() | |
Get the external file name if this is an external reference.
|
||
boolean | isArea() | |
Indicates whether this is an area.
|
||
boolean | isExternalLink() | |
Indicates whether this is an external link.
|
||
java.lang.String | getSheetName() | |
Indicates which sheet this reference is in.
|
||
int | getStartColumn() | |
The start column of the area.
|
||
int | getStartRow() | |
The start row of the area.
|
Method Summary | ||
---|---|---|
java.lang.Object | getValue(int rowOffset, int colOffset) | |
Gets cell value with given offset from the top-left of this area.
|
||
java.lang.Object | getValue(int rowOffset, int colOffset, boolean calculateFormulas) | |
Gets cell value with given offset from the top-left of this area.
|
||
java.lang.Object | getValues() | |
Gets cell values in this area.
|
||
java.lang.Object | getValues(boolean calculateFormulas) | |
Gets cell values in this area.
|
||
java.lang.String | toString() | |
Returns the simple string representation of this area.
|
public boolean isExternalLink()
public java.lang.String getExternalFileName()
public java.lang.String getSheetName()
public boolean isArea()
public int getEndColumn()
public int getStartColumn()
public int getEndRow()
public int getStartRow()
public java.lang.Object getValues()
public java.lang.Object getValues(boolean calculateFormulas)
calculateFormulas
- In this range, if there are some formulas that have not been calculated,
this flag denotes whether those formulas should be calculated recursivelypublic java.lang.Object getValue(int rowOffset, int colOffset)
rowOffset
- row offset from the start row of this areacolOffset
- column offset from the start row of this areapublic java.lang.Object getValue(int rowOffset, int colOffset, boolean calculateFormulas)
rowOffset
- row offset from the start row of this areacolOffset
- column offset from the start row of this areacalculateFormulas
- Whether calculate it recursively if the specified reference is formulapublic java.lang.String toString()