Name Class

Represents a defined name for a range of cells.

Inheritance Hierarchy

SystemObject
Aspose.CellsName

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 22.5.0.0 (22.5.0)

Syntax

C++

public class Name

Public Class Name

public ref class Name

type Name =  class end

The Name type exposes the following members.

Properties

	Name	Description
	Comment	Gets and sets the comment of the name. Only applies for Excel 2007.
	FullText	Gets the name full text of the object with the scope setting.
	IsReferred	Indicates whether this name is referred by other formulas.
	IsVisible	Indicates whether the name is visible.
	R1C1RefersTo	Gets or sets a R1C1 reference of the Name.
	RefersTo	Returns or sets the formula that the name is defined to refer to, beginning with an equal sign.
	SheetIndex	Indicates this name belongs to Workbook or Worksheet. 0 = Global name, otherwise index to sheet (one-based)
	Text	Gets the name text of the object.

Methods

	Name	Description
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetRange	Gets the range if this name refers to a range.
	GetRange(Boolean)	Gets the range if this name refers to a range
	GetRange(Int32, Int32, Int32)	Gets 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.
	GetRanges	Gets all ranges referred by this name.
	GetRanges(Boolean)	Gets all ranges referred by this name.
	GetReferredAreas	Gets all references referred by this name.
	GetRefersTo(Boolean, Boolean)	Get the reference of this Name.
	GetRefersTo(Boolean, Boolean, Int32, Int32)	Get the reference of this Name based on specified cell.
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	SetRefersTo	Set the reference of this Name.
	ToString	Returns a string represents the current Range object. (Overrides ObjectToString.)

Examples

[C#]

//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];
//Creating a named range
Range range = worksheet.Cells.CreateRange("B4", "G14");
//Setting the name of the named range
range.Name = "TestRange";
//Saving the modified Excel file in default (that is Excel 2000) format
workbook.Save("output.xls");   

[Visual Basic]

'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Accessing the first worksheet in the Excel file
Dim worksheet As Worksheet = workbook.Worksheets(0)
'Creating a named range
Dim range As Range = worksheet.Cells.CreateRange("B4", "G14")
'Setting the name of the named range
range.Name = "TestRange"
'Saving the modified Excel file in default (that is Excel 2000) format
workbook.Save("output.xls")

Reference

Aspose.Cells Namespace