Can't determine dimensions when <dimension> element and <row spans=...> attribute are both missing
Created originally on Bitbucket by Anonymous
If neither nor is available in the sheet.xml file the dimensions cannot be determined.
A patch of the read_dimension() function in reader/worksheet.py is attached (based on 1.8.3)
$ diff worksheet.py-1.8.3 worksheet.py 36c36 < from openpyxl.cell import Cell, coordinate_from_string
from openpyxl.cell import Cell, coordinate_from_string, column_index_from_string, coordinate_from_string 78c78 < if ":" in span:
if span and ":" in span:
85a86,94
if el.tag == '{%s}c' % SHEET_MAIN_NS: col = column_index_from_string(coordinate_from_string(el.get("r"))[0]) if min_col is None: min_col = max_col = col else: min_col = min(min_col, col) max_col = max(max_col, col)
87c96 < warn("Unsized worksheet")
#warn("Unsized worksheet")