Class ReferredArea

ReferredArea class

Represents a referred area by the formula.

public class ReferredArea

Properties

NameDescription
EndColumn { get; }The end column of the area.
EndRow { get; }The end row of the area.
ExternalFileName { get; }Get the external file name if this is an external reference.
IsArea { get; }Indicates whether this is an area.
IsExternalLink { get; }Indicates whether this is an external link.
SheetName { get; }Indicates which sheet this reference is in.
StartColumn { get; }The start column of the area.
StartRow { get; }The start row of the area.

Methods

NameDescription
GetValue(int, int)Gets cell value with given offset from the top-left of this area.
GetValue(int, int, bool)Gets cell value with given offset from the top-left of this area.
GetValues()Gets cell values in this area.
GetValues(bool)Gets cell values in this area.
override ToString()Returns the simple string representation of this area.

See Also