Use Named Ranges

Normally, you use the labels of columns and rows on a worksheet to refer to the cells within those columns and rows. However, you can create descriptive names to represent cells, ranges of cells, formulas, or constant values. The word Name may refer to a string of characters that represents a cell, range of cells, formula, or constant value. For example, use easy‑to‑understand names, such as Products, to refer to hard‑to‑understand ranges, such as Sales!C20:C30. Labels can be used in formulas that refer to data on the same worksheet; if you want to represent a range on another worksheet, you may use a name. Named Ranges are among the most powerful features of Microsoft Excel. Users may assign a name to a named range so that this range of cells can be referred to by its name in formulas. Aspose.Cells.GridDesktop does support this feature.

Adding/Referencing Named Ranges in Formulas

The GridDesktop control supports importing/exporting named ranges in Excel files and provides two classes (Name and NameCollection) to work with named ranges.

The following code snippet shows how to use them.