ReferredArea

ReferredArea class

Represents a referred area by the formula.

public class ReferredArea

Properties

Name Description
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

Name Description
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