ReferredArea class

ReferredArea class

Represents a referred area by the formula.

The ReferredArea type exposes the following members:

Properties

PropertyDescription
is_external_linkIndicates whether this is an external link.
external_file_nameGet the external file name if this is an external reference.
sheet_nameIndicates which sheet this reference is in.
is_entire_rowIndicates whether this area contains all columns(entire row).
is_entire_columnIndicates whether this area contains all rows(entire column).
is_areaIndicates whether this is an area.
end_columnThe end column of the area.
start_columnThe start column of the area.
end_rowThe end row of the area.
start_rowThe start row of the area.

Methods

MethodDescription
get_valuesGets cell values in this area.
get_valuesGets cell values in this area.
get_valueGets cell value with given offset from the top-left of this area.
get_valueGets cell value with given offset from the top-left of this area.

See Also