from openpyxl import load_workbook
wb = load_workbook('file.xlsx')
sheet_ranges = wb['List1']
column_b = sheet_ranges['B']
for i in range(len(column_b)):
print(column_b[i].value)
# Или просто как итератор перебрать столбец:
for cell in column_b:
print(cell.value)