How to Add Named Range

using IronXL; // Import the IronXL library to manage Excel files

// Create a new workbook
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Access the default worksheet in the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Select a range of cells from A1 to A5
var selectedRange = workSheet["A1:A5"];

// Add a named range to the worksheet,
// allowing you to easily reference this range later
workSheet.AddNamedRange("range1", selectedRange);

// Save the workbook with the specified filename
workBook.SaveAs("addNamedRange.xlsx");

Imports IronXL ' Import the IronXL library to manage Excel files

' Create a new workbook
Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)

' Access the default worksheet in the workbook
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Select a range of cells from A1 to A5
Private selectedRange = workSheet("A1:A5")

' Add a named range to the worksheet,
' allowing you to easily reference this range later
workSheet.AddNamedRange("range1", selectedRange)

' Save the workbook with the specified filename
workBook.SaveAs("addNamedRange.xlsx")

using IronXL;

// Load the workbook from the specified file
WorkBook workBook = WorkBook.Load("addNamedRange.xlsx");

// Select the default worksheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Retrieve all named ranges in the worksheet
var namedRangeList = workSheet.GetNamedRanges();

// Iterate through the named ranges and display their details
foreach (var namedRange in namedRangeList)
{
    // Print the name and address of each named range
    Console.WriteLine($"Named Range: {namedRange.Name}, Address: {namedRange.AreaAddress}");
}

Imports IronXL

' Load the workbook from the specified file
Private workBook As WorkBook = WorkBook.Load("addNamedRange.xlsx")

' Select the default worksheet
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Retrieve all named ranges in the worksheet
Private namedRangeList = workSheet.GetNamedRanges()

' Iterate through the named ranges and display their details
For Each namedRange In namedRangeList
	' Print the name and address of each named range
	Console.WriteLine($"Named Range: {namedRange.Name}, Address: {namedRange.AreaAddress}")
Next namedRange

using IronXL;

// The following code demonstrates how to load an Excel workbook,
// locate a named range, and select the range within a worksheet.

// Load the Excel workbook from the specified file
WorkBook workBook = WorkBook.Load("addNamedRange.xlsx");

// Get the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Find the named range "range1" and get its address
// Assuming the correct method name is GetNamedRange for retrieving the named range
NameRange namedRange = workSheet.GetNamedRange("range1");
string namedRangeAddress = namedRange.FullAddress;

// Select the range using the address obtained
var range = workSheet[namedRangeAddress];

// Note:
// IronXL is a third-party library used for working with Excel files in .NET applications.
// - 'Load' method is used to load the workbook from a file.
// - 'DefaultWorkSheet' property accesses the default worksheet in the workbook.
// - 'GetNamedRange' retrieves the named range as a NameRange object.
// - 'FullAddress' is a property of the NameRange object that retrieves the address of the named range.
// - The range is accessed using the indexer of 'workSheet'.

Imports IronXL

' The following code demonstrates how to load an Excel workbook,
' locate a named range, and select the range within a worksheet.

' Load the Excel workbook from the specified file
Private workBook As WorkBook = WorkBook.Load("addNamedRange.xlsx")

' Get the default worksheet from the workbook
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Find the named range "range1" and get its address
' Assuming the correct method name is GetNamedRange for retrieving the named range
Private namedRange As NameRange = workSheet.GetNamedRange("range1")
Private namedRangeAddress As String = namedRange.FullAddress

' Select the range using the address obtained
Private range = workSheet(namedRangeAddress)

' Note:
' IronXL is a third-party library used for working with Excel files in .NET applications.
' - 'Load' method is used to load the workbook from a file.
' - 'DefaultWorkSheet' property accesses the default worksheet in the workbook.
' - 'GetNamedRange' retrieves the named range as a NameRange object.
' - 'FullAddress' is a property of the NameRange object that retrieves the address of the named range.
' - The range is accessed using the indexer of 'workSheet'.

// Make sure to include the proper using directive to access IronXL functionalities
using IronXL;

// This code snippet demonstrates how to load an existing Excel workbook,
// access its default worksheet, and remove a named range from it.

// Load the Excel workbook named "addNamedRange.xlsx"
WorkBook workBook = WorkBook.Load("addNamedRange.xlsx");

// Get the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Check if the named range "range1" exists before attempting to remove it
if (workSheet.HasNamedRange("range1"))
{
    // Remove a named range with the name "range1" from the worksheet
    workSheet.RemoveNamedRange("range1");
}
else
{
    // Optionally, handle the case where the named range does not exist
    Console.WriteLine("Named range 'range1' does not exist.");
}

// Save the workbook after making changes (if required)
workBook.Save();

' Make sure to include the proper using directive to access IronXL functionalities
Imports IronXL

' This code snippet demonstrates how to load an existing Excel workbook,
' access its default worksheet, and remove a named range from it.

' Load the Excel workbook named "addNamedRange.xlsx"
Private workBook As WorkBook = WorkBook.Load("addNamedRange.xlsx")

' Get the default worksheet from the workbook
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Check if the named range "range1" exists before attempting to remove it
If workSheet.HasNamedRange("range1") Then
	' Remove a named range with the name "range1" from the worksheet
	workSheet.RemoveNamedRange("range1")
Else
	' Optionally, handle the case where the named range does not exist
	Console.WriteLine("Named range 'range1' does not exist.")
End If

' Save the workbook after making changes (if required)
workBook.Save()