Skip to content

Fix reading rows with skipped reference attribute

Baudouin Giard requested to merge topic/3.0/skipped-r into branch/3.0

Resolves: #1571 (closed)

Some Excel files generated with third-party libraries such as SpreadsheetGear - there could be other, skip the "r" attribute on "c" tags within rows. Excel seems to put this attribute on every cell, but I couldn't find any evidence that the standard commands it.

openpyxl is not expecting these attributes to be skipped, so the result is that we end up with an invalid parsed row.

To fix this, when we get coordinates, make sure the column number gets assigned to col_counter so the reader always knows which cell it has been reading last.

--HG-- branch : 3.0

Edited by Baudouin Giard

Merge request reports