Select Excel Range

VB C#

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}")