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()