Combine Multiple Excel Ranges in C#

VB C#

using IronXL;
using System;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// Get a range from an Excel worksheet
var range = workSheet["A2:A8"];

// Combine two ranges
var combinedRange = range + workSheet["A9:A10"];

// Iterate over combined range
foreach (var cell in combinedRange)
{
    Console.WriteLine(cell.Value);
}

Imports IronXL
Imports System
Imports System.Linq

Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()

' Get a range from an Excel worksheet
Private range = workSheet("A2:A8")

' Combine two ranges
Private combinedRange = range + workSheet("A9:A10")

' Iterate over combined range
For Each cell In combinedRange
	Console.WriteLine(cell.Value)
Next cell

Install-Package IronXL.Excel

Combine Multiple Excel Ranges in C#

IronXL is a C# library that allows for efficient manipulation of Excel files. One of its features is the ability to combine IronXL.Ranges.Range objects using the + operator.

Using the + operator to combine IronXL.Ranges.Range objects is a versatile way to handle multiple ranges as a single entity. This can be incredibly useful in scenarios requiring the aggregation of data from various sections of a worksheet.

Explore How to Write to Excel with IronXL