Unicode error when loading workbook
Created originally on Bitbucket by thedauntless (Jeroen Beckers)
Openpyxl version: openpyxl-2.4.0b1-py2.7 on Windows 10.
When I use load_workbook on a specific xlsx file, it gives the following error output:
#!code
Traceback (most recent call last):
File ".\generate.py", line 758, in <module>
wb = openpyxl.reader.excel.load_workbook(sheetFileName, data_only="True")
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\reader\excel.py", line 152, in load_workbook
parser.parse()
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\packaging\workbook.py", line 54, in parse
rel.Target))
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\workbook\external_link\external.py", line 186, in read_external_link
book = ExternalLink.from_tree(node)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\serialisable.py", line 76, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\serialisable.py", line 76, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\serialisable.py", line 76, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\serialisable.py", line 76, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\serialisable.py", line 76, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\serialisable.py", line 89, in from_tree
return cls(**attrib)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\workbook\external_link\external.py", line 47, in __init__
self.v = v
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\nested.py", line 36, in __set__
super(Nested, self).__set__(instance, value)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\base.py", line 69, in __set__
value = _convert(self.expected_type, value)
File "C:\Python27\lib\site-packages\openpyxl-2.4.0b1-py2.7.egg\openpyxl\descriptors\base.py", line 59, in _convert
raise TypeError('expected ' + str(expected_type) + ' -- ' + str(value.encode("utf-8")))
TypeError: expected <type 'str'> -- C├®dric
As you can see, I have already modified the base.py file so that I have some feedback over what goes wrong.
The first thing I tried was a "replace all" on Cédric -> Cedric, but unfortunately, the same error is given (even though Cédric shouldn't be present in the xlsx anymore).
Unfortunately, I can't share the xlsx file, and I also haven't been able to reduce the problem to a presentable file.
This works fine on my OS X computer, but fails on Windows.
Are there any other places I should be looking for "Cédric" ? Places that excel won't find itself? And shouldn't everything be loaded in unicode anyway?
Attachments: TEST1.xlsx