why does my openpyxl load only pull one cell in worksheet
<p>I have this openpyxl intent on reading rows in an XLSX document.</p>

<p>But for some reason It is only reading the value in CELL A1, then finishing.
What am I missing?</p>

<p>Thanks</p>

<p>from openpyxl import load_workbook</p>

<pre><code>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)
</code></pre>

<p>Read-only mode depends to a large extent on the metadata provided by the file you're reading, particularly the "dimensions". You can check this by seeing what <code>ws.max_row</code> and <code>ws.max_col</code> are. If these are different to what you expect then the metadata in the file is incorrect. You can force openpyxl to recalculate these values with <code>ws.calculate_dimensions()</code> but this is inadvisable as it forces openpyxl to read the whole sheet. Better is simply to reset the underlying values so that openpyxl knows the worksheet is unsized.</p>

python excel openpyxl