ReferredArea Class

ReferredArea class

Represents a referred area by the formula.


type ReferredArea struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
IsExternalLinkIndicates whether this is an external link.
GetExternalFileNameGet the external file name if this is an external reference.
GetSheetNameIndicates which sheet this reference is in.
IsEntireRowIndicates whether this area contains all columns(entire row).
IsEntireColumnIndicates whether this area contains all rows(entire column).
IsAreaIndicates whether this is an area.
GetEndColumnThe end column of the area.
GetStartColumnThe start column of the area.
GetEndRowThe end row of the area.
GetStartRowThe start row of the area.
GetValuesGets cell values in this area.
GetValues_BoolGets cell values in this area.
GetValue_Int_IntGets cell value with given offset from the top-left of this area.
GetValue_Int_Int_BoolGets cell value with given offset from the top-left of this area.
ToStringReturns the reference address of this area.Generally it is the address of the reference which may be used in formula, such as “Sheet1!A1:C3”.