from openpyxl import Workbook,load_workbook from openpyxl.styles import * import warnings warnings.filterwarnings('ignore') wb = load_workbook('2020.xlsx') ws = wb['000'] codelist = [] for i in range(50): codelist.append(ws.cell(i+1, 1).value) print(codelist)