Name Class

Name class

Represents a defined name for a range of cells.


type Name struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
GetCommentGets and sets the comment of the name.Only applies for Excel 2007 or higher versions.
SetCommentGets and sets the comment of the name.Only applies for Excel 2007 or higher versions.
GetTextGets the name text of the object.
SetTextGets the name text of the object.
GetFullTextGets the name full text of the object with the scope setting.
GetRefersToReturns or sets the formula that the name is defined to refer to, beginning with an equal sign.
SetRefersTo_StringReturns or sets the formula that the name is defined to refer to, beginning with an equal sign.
GetR1C1RefersToGets or sets a R1C1 reference of the Name.
SetR1C1RefersToGets or sets a R1C1 reference of the Name.
GetRefersTo_Bool_BoolGet the reference of this Name.
GetRefersTo_Bool_Bool_Int_IntGet the reference of this Name based on specified cell.
SetRefersTo_String_Bool_BoolSet the reference of this Name.
IsReferredIndicates whether this name is referred by other formulas.
IsVisibleIndicates whether the name is visible.
SetIsVisibleIndicates whether the name is visible.
GetSheetIndexIndicates this name belongs to Workbook or Worksheet.0 = Global name, otherwise index to sheet (one-based)
SetSheetIndexIndicates this name belongs to Workbook or Worksheet.0 = Global name, otherwise index to sheet (one-based)
ToStringReturns a string represents the current Range object.
GetRangesGets all ranges referred by this name.
GetRanges_BoolGets all ranges referred by this name.
GetReferredAreasGets all references referred by this name.
GetRangeGets the range if this name refers to a range.
GetRange_BoolGets the range if this name refers to a range
GetRange_Int_Int_IntGets the range if this name refers to a range.If the reference of this name is not absolute, the range may be different for different cell.