Print area cannot be parsed if it's a reference to a Table
Excel allows users to create tables and set the print area as whatever the area of that table is. This results in a definedName tag in workbook.xml that openpyxl cannot parse (expects a cell reference)
See attached file, which produces something like
<definedNames> <definedName name="_xlnm.Print_Area" localSheetId="0">InvoiceData[#All]</definedName> </definedNames>
This crashes out in the workbook reader as it attempts to extract a cell reference (See here)
The spec (at least according to c-rex) doesn't really provide much guidance on this one. I'm unable to test how LibreOffice handles it.
from openpyxl import load_workbook wb = load_workbook("QueryTable.xlsx")