Returns the simple string representation of this area.
Property Getters/Setters Detail
isExternalLink
public boolean isExternalLink()
Indicates whether this is an external link.
getExternalFileName
public java.lang.String getExternalFileName()
Get the external file name if this is an external reference.
getSheetName
public java.lang.String getSheetName()
Indicates which sheet this reference is in.
isArea
public boolean isArea()
Indicates whether this is an area.
If this is not an area, only StartRow and StartColumn effect.
getEndColumn
public int getEndColumn()
The end column of the area.
getStartColumn
public int getStartColumn()
The start column of the area.
getEndRow
public int getEndRow()
The end row of the area.
getStartRow
public int getStartRow()
The start row of the area.
Method Detail
getValues
public java.lang.Object getValues()
Gets cell values in this area.
Returns:
If this area is invalid, "#REF!" will be returned;
If this area is one single cell, then return the cell value object;
Otherwise return one 2D array for all values in this area.
getValues
public java.lang.Object getValues(boolean calculateFormulas)
Gets cell values in this area.
Parameters:
calculateFormulas - In this range, if there are some formulas that have not been calculated,
this flag denotes whether those formulas should be calculated recursively
Returns:
If this area is invalid, "#REF!" will be returned;
If this area is one single cell, then return the cell value object;
Otherwise return one 2D array for all values in this area.
getValue
public java.lang.Object getValue(int rowOffset, int colOffset)
Gets cell value with given offset from the top-left of this area.
Parameters:
rowOffset - row offset from the start row of this area
colOffset - column offset from the start row of this area
Returns:
"#REF!" if this area is invalid;
"#N/A" if given offset out of this area;
Otherwise return the cell value at given position.
getValue
public java.lang.Object getValue(int rowOffset, int colOffset, boolean calculateFormulas)
Gets cell value with given offset from the top-left of this area.
Parameters:
rowOffset - row offset from the start row of this area
colOffset - column offset from the start row of this area
calculateFormulas - Whether calculate it recursively if the specified reference is formula
Returns:
"#REF!" if this area is invalid;
"#N/A" if given offset out of this area;
Otherwise return the cell value at given position.
toString
public java.lang.String toString()
Returns the simple string representation of this area.
com.aspose.cells.ReferredArea