openpyxl icon indicating copy to clipboard operation
openpyxl copied to clipboard

bug: TypeError: _NamedCellStyle.__init__() got an unexpected keyword argument 'biltinId'

Open jgroc-de opened this issue 1 year ago • 3 comments

Hi,

when trying to open an excel (.xlsx) file, i got this error:

Traceback (most recent call last): File "main.py", line 15, in load_workbook(filename='old.xlsx') File "~/.local/lib/python3.10/site-packages/openpyxl/reader/excel.py", line 317, in load_workbook reader.read() File "~/.local/lib/python3.10/site-packages/openpyxl/reader/excel.py", line 281, in read apply_stylesheet(self.archive, self.wb) File "~/.local/lib/python3.10/site-packages/openpyxl/styles/stylesheet.py", line 198, in apply_stylesheet stylesheet = Stylesheet.from_tree(node) File "~/.local/lib/python3.10/site-packages/openpyxl/styles/stylesheet.py", line 103, in from_tree return super(Stylesheet, cls).from_tree(node) File "~/.local/lib/python3.10/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree obj = desc.expected_type.from_tree(el) File "~/.local/lib/python3.10/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree obj = desc.expected_type.from_tree(el) File "~/.local/lib/python3.10/site-packages/openpyxl/descriptors/serialisable.py", line 103, in from_tree return cls(**attrib) TypeError: _NamedCellStyle.init() got an unexpected keyword argument 'biltinId'

if i open this file with calc or microsoft excel and re-save it, this error disappears. i tried it with another python lib to open excel files and it works so i guess it is something for openpyxl.

Badfully, i am not sure i can give you an exemple file for testing purpose... Ask me if ever the stacktrace is not enough.

thx for the lib anyway.

jgroc-de avatar Nov 04 '22 13:11 jgroc-de