Error loading workbook with empty properties file
When we try to open a workbook that has an empty properties file (docProps/core.xml
), we get a lxml error for an empty document
>>> wb = load_workbook('uploads/test.xlsx')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python3.11/site-packages/openpyxl/reader/excel.py", line 346, in load_workbook
reader.read()
File "/usr/local/lib/python3.11/site-packages/openpyxl/reader/excel.py", line 293, in read
self.read_properties()
File "/usr/local/lib/python3.11/site-packages/openpyxl/reader/excel.py", line 175, in read_properties
src = fromstring(self.archive.read(ARC_CORE))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "src/lxml/etree.pyx", line 3257, in lxml.etree.fromstring
File "src/lxml/parser.pxi", line 1916, in lxml.etree._parseMemoryDocument
File "src/lxml/parser.pxi", line 1803, in lxml.etree._parseDoc
File "src/lxml/parser.pxi", line 1144, in lxml.etree._BaseParser._parseDoc
File "src/lxml/parser.pxi", line 618, in lxml.etree._ParserContext._handleParseResultDoc
File "src/lxml/parser.pxi", line 728, in lxml.etree._handleParseResult
File "src/lxml/parser.pxi", line 657, in lxml.etree._raiseParseError
File "<string>", line 1
lxml.etree.XMLSyntaxError: Document is empty, line 1, column 1
example file: test.xlsx