Name Class |
Namespace: Aspose.Cells
The Name type exposes the following members.
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.
|
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.) |
[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")