Class GridReferredArea

GridReferredArea class

Represents a referred area by the formula.

public class GridReferredArea

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 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.
GetValues()Gets cell values in this area.

See Also