Combine Excel Ranges

VB C#

from ironxl import *

# Load existing spreadsheet
workbook = WorkBook.Load("sample.xls")
worksheet = workbook.WorkSheets[0]

# Get a range from an Excel worksheet
selected_range = worksheet["A2:A8"]

# Combine two ranges
combined_range = selected_range + worksheet["A9:A10"]

# Iterate over the combined range
for cell in combined_range:
    print(cell.Value)

Combine Excel Ranges

IronXL for Python provides an efficient way to manipulate Excel files, including the ability to combine Range objects using the + operator.

Using the + operator to combine Range objects is a versatile approach for handling multiple non-contiguous cell groups as a single entity. This is particularly useful when aggregating data from different sections of a worksheet—for example, applying a single formatting rule or calculation across a union of ranges without writing repetitive selection logic.

Explore How to Write to Excel with IronXL for Python