Select Excel Range

from ironxl import *

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

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

# Get column from worksheet
column_a = worksheet.GetColumn(0)

# Get row from worksheet
row_1 = worksheet.GetRow(0)

# Iterate over the range
for cell in selected_range:
    print(f"{cell.Value}")

pip install ironxl

pip install ironxl

Select Excel Range

IronXL for Python makes it easy to select and work with ranges in any Excel WorkSheet. The code below demonstrates how ranges, rows, and columns can be selected. After selection, aggregate methods such as SortAscending(), SortDescending(), Sum(), Max(), Min(), and Average() can be applied to the collected data. Note that when methods modify or move cell values, the affected range, row, or column will reflect those changes accordingly.

Range

To select a range from A2 to A8, use range_ = worksheet["A2:A8"].

Row

To select row 1, use worksheet.GetRow(0). Indexing is zero-based. The range of cells returned is determined by the union of all populated cells across all rows, including row 1 itself.

Column

To select column A, use worksheet.GetColumn(0) or assign the range address as worksheet["A:A"]. The range of cells is determined by the union of all populated cells across all columns, including column A itself.