Error when loading Outlook.com / Web Excel modified spreadsheet.

Issue #636 resolved
Kiran Manam created an issue

I have the latest version of openpyxl installed. When I tried to open/parse the normal Excel Spreadheet generated by Outlook.com / Web Excel. I got the following error :

Traceback (most recent call last):

File "C:/Downloads/Live/ExcelcheckPOResponse.py", line 150, in <module>

modified = check_excel(po_id)

File "C:/Downloads/Live/ExcelcheckPOResponse.py", line 86, in check_excel

wb = openpyxl.load_workbook(filename)

File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 234, in

load_workbook

parser.parse()

File "C:\Python27\lib\site-packages\openpyxl\reader\worksheet.py", line 106, in parse

dispatcher[tag_name](element)

File "C:\Python27\lib\site-packages\openpyxl\reader\worksheet.py", line 314, in

parse_sheet_views

self.ws.sheet_view = SheetView.from_tree(el)

File "C:\Python27\lib\site-packages\openpyxl\descriptors\serialisable.py", line 78, in

from_tree

return cls(**attrib)

TypeError: init() got an unexpected keyword argument

'{http://schemas.microsoft.com/office/spreadsheetml/2016/revision3}uid'

Comments (6)

  1. CharlieC

    The problem is due to Microsoft continuing to extend the file format in new versions of Microsoft Office. The 2.4 branch is much better at ignoring the various new attributes associated with these extensions. It should be noted that the format already contains provision for extensions and that these are in addition to those.

  2. bsilvest

    Are there arguments for loading a workbook to ignore these extension elements? I've updated openpyxl to latest 2.4.0-b1 release and I am seeing the same issue attempting to read an excel sheet modified by Microsoft Office via web browser. Thanks.

  3. Log in to comment