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