ReferredArea.GetValue

GetValue(int, int)

Gets cell value with given offset from the top-left of this area.

public object GetValue(int rowOffset, int colOffset)
ParameterTypeDescription
rowOffsetInt32row offset from the start row of this area
colOffsetInt32column offset from the start row of this area

Return Value

“#REF!” if this area is invalid; “#N/A” if given offset out of this area; Otherwise return the cell value at given position.

See Also


GetValue(int, int, bool)

Gets cell value with given offset from the top-left of this area.

public object GetValue(int rowOffset, int colOffset, bool calculateFormulas)
ParameterTypeDescription
rowOffsetInt32row offset from the start row of this area
colOffsetInt32column offset from the start row of this area
calculateFormulasBooleanWhether calculate it recursively if the specified reference is formula

Return Value

“#REF!” if this area is invalid; “#N/A” if given offset out of this area; Otherwise return the cell value at given position.

See Also