Name a Range

The following example shows you how to name a range.

C# example

using System;
using Independentsoft.Office;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet1 = new Worksheet();
            sheet1.ID = 1;
            sheet1.Name = "TestSheet1";

            DefinedName range1 = new DefinedName("myrange1");
            range1.Body = "TestSheet1!$A$1:$A$10";

            DefinedName range2 = new DefinedName("myrange2");
            range2.Body = "TestSheet1!$B$1:$D$1";

            Workbook book = new Workbook();
            book.Sheets.Add(sheet1);
            book.DefinedNames.Add(range1);
            book.DefinedNames.Add(range2);

            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet1 As New Worksheet()
        sheet1.ID = 1
        sheet1.Name = "TestSheet1"

        Dim range1 As New DefinedName("myrange1")
        range1.Body = "TestSheet1!$A$1:$A$10"

        Dim range2 As New DefinedName("myrange2")
        range2.Body = "TestSheet1!$B$1:$D$1"

        Dim book As New Workbook()
        book.Sheets.Add(sheet1)
        book.DefinedNames.Add(range1)
        book.DefinedNames.Add(range2)

        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

Independentsoft - any library, any programming language

Spreadsheet .NET > Tutorial > Name a Range

Need help? Ask our developers: