from openpyxl import load_workbook
wb = load_workbook("data/test-2.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, 'rrrr'], [3.0, 234.0, 2020.0], [4.0, 234.0, 'nnnnnnn'], [5.0, 'rrrrrr', 2020.0], [6.0, 5.0, 2020.0], [7.0, 34.0, 2020.0], [8.0, 3.0, 'yyyyyy'], [9.0, 45.0, 2020.0]]
def pprint_table(llist: list) -> None:
for row in llist:
print(row)
pprint_table(result)
['Note', 'Code', 'Year'] [1.0, 34.0, 2020.0] [2.0, 345.0, 'rrrr'] [3.0, 234.0, 2020.0] [4.0, 234.0, 'nnnnnnn'] [5.0, 'rrrrrr', 2020.0] [6.0, 5.0, 2020.0] [7.0, 34.0, 2020.0] [8.0, 3.0, 'yyyyyy'] [9.0, 45.0, 2020.0]