Combine Excel Ranges

Name: C# Excel Library - IronXL
Rating: 4.81 (173 reviews)

VB C#

using System.Linq;
using IronXL;

WorkBook workbook = WorkBook.Load("test.xls");
WorkSheet sheet = workbook.WorkSheets.First();

//This is how we get a range from an Excel worksheet
var range = sheet["A2:A8"];
 
var combinedRange = range + sheet["A9:A10"];;

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

Imports System.Linq
Imports IronXL

Private workbook As WorkBook = WorkBook.Load("test.xls")
Private sheet As WorkSheet = workbook.WorkSheets.First()

'This is how we get a range from an Excel worksheet
Private range = sheet("A2:A8")

Private combinedRange = range + sheet("A9:A10")

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

Install-Package IronXL.Excel

Combine Excel Ranges

IronXL allows us to combine more than one `IronXL.Ranges.Range` using the '+' operator.

Previous Example

Next Example

Ready to get started? Version: 2022.6 just released

View Licenses >