from openpyxl import load_workbook
wb = load_workbook("data/test.xlsx")
# https://github.com/dm-fedorov/python_basic/blob/master/data/test.xlsx
result = []
ws = wb.worksheets[0]
for row in ws.iter_rows():
result.append([cell.value for cell in row])
print(result)
[['Note', 'Code', 'Year'], [1.0, 34.0, 2020.0], [2.0, 345.0, 2020.0], [3.0, 234.0, 2020.0], [4.0, 234.0, 2020.0], [5.0, 6.0, 2020.0], [6.0, 5.0, 2020.0], [7.0, 34.0, 2020.0], [8.0, 3.0, 2020.0], [9.0, 45.0, 2020.0]]