EasyXLS

Named ranges and formulas

EasyXLS™ library allows you to define named ranges and to use names in formulas in Excel files.

A name can be referred to a cell, a range of cells or a formula and it has a title that identifies the name.

Source code sample

The below example shows how to export an Excel file with a named range.

C#.NET
VB.NET
C++
Java
PHP
ASP
VB6
VBS
Coldfusion
Python

The screen shot provides an example of an Excel file with two sheets. The second sheet has a defined name for a range of cells.

Excel named range on formulas


Available for: Professional, Excel Writer, Excel Reader
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
COM+ Excel Library
full COM+ version to import, export or convert Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

Office 365
MS Excel 2021 - 2024
MS Excel 2007 - 2019
MS Excel 97 - 2003
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT