Collection of the descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 35.0.30.1025

Syntax

C#
public sealed class NamedRangeCollection : IEnumerable<NamedRange>, 
	IEnumerable
Visual Basic
Public NotInheritable Class NamedRangeCollection _
	Implements IEnumerable(Of NamedRange), IEnumerable

Remarks

You can use the labels of columns and rows on a worksheet to refer to the cells within those columns and rows. Or you can create descriptive names to represent cells, ranges of cells, formulas, or constant values. Labels can be used in formulas that refer to data on the same worksheet; if you want to represent a range on another worksheet, use a name. You can also create 3-D names that represent the same cell or range of cells across multiple worksheets.

Examples

Following code demonstrates how to use formulas and named ranges. It shows next features: cell references (both absolute and relative), unary and binary operators, constand operands (integer and floating point), functions and named cell ranges.
CopyVB.NET
ws.Cells("A1").Value = 5
ws.Cells("A2").Value = 6
ws.Cells("A3").Value = 10

ws.Cells("C1").Formula = "=A1+A2"
ws.Cells("C2").Formula = "=$A$1-A3"
ws.Cells("C3").Formula = "=COUNT(A1:A3)"
ws.Cells("C4").Formula = "=AVERAGE($A$1:$A$3)"
ws.Cells("C5").Formula = "=SUM(A1:A3,2,3)"
ws.Cells("C7").Formula = "= 123 - (-(-(23.5)))"

ws.NamedRanges.Add("DataRange", ws.Cells.GetSubrange("A1", "A3"))
ws.Cells("C8").Formula = "=MAX(DataRange)"

Dim cr As CellRange = ws.Cells.GetSubrange("B9","C10")
cr.Merged = True
cr.Formula = "=A1*25"
CopyC#
ws.Cells["A1"].Value = 5;
ws.Cells["A2"].Value = 6;
ws.Cells["A3"].Value = 10;

ws.Cells["C1"].Formula = "=A1+A2";
ws.Cells["C2"].Formula = "=$A$1-A3";
ws.Cells["C3"].Formula = "=COUNT(A1:A3)";
ws.Cells["C4"].Formula = "=AVERAGE($A$1:$A$3)";
ws.Cells["C5"].Formula = "=SUM(A1:A3,2,3)";
ws.Cells["C7"].Formula = "= 123 - (-(-(23.5)))";

ws.NamedRanges.Add("DataRange", ws.Cells.GetSubrange("A1", "A3"));
ws.Cells["C8"].Formula = "=MAX(DataRange)";

CellRange cr = ws.Cells.GetSubrange("B9", "C10");
cr.Merged = true;
cr.Formula = "=A1*25";

Inheritance Hierarchy

System..::..Object
  GemBox.Spreadsheet..::..NamedRangeCollection

See Also