why does my openpyxl load only pull one cell in worksheet

Question

I have this openpyxl intent on reading rows in an XLSX document.

But for some reason it is only reading the value in cell A1, then finishing.

What am I missing?

from openpyxl import load_workbook

Dutch = load_workbook(filename='languages/READY-Language Translation-- August (SOS) Dutch_dut_Compared_Results.xlsx', read_only=True)
Dws = Dutch.get_sheet_by_name(name='Ouput')

for row in Dws.iter_rows():
    for cell in row:
        print(cell.value)

Answer 1

If you load your workbook in read mode, and openpyxl is not reading the sheet as expected, say A1:A1, you can reset the max row and col with ws.reset_dimensions().

Documentaion here

Example:

from openpyxl import load_workbook

wb = load_workbook(filename='languages/READY-Language Translation-- August (SOS) Dutch_dut_Compared_Results.xlsx', read_only=True)
ws = wb['Ouput']
ws.reset_dimensions()

for row in ws.rows:
    for cell in row:
        print(cell.value)