Cannot open this workbook. Opening it with excel 2010 works just fine.
Created originally on Bitbucket by shadowobject
Trying to open this attached workbook results in the following error stack:
Traceback (most recent call last):
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\base.py", line 55, in _convert
value = expected_type(value)
TypeError: int() argument must be a string, a bytes-like object or a number, not 'NoneType'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:/sourcecode/pythonprojects/test/test.py", line 3, in <module>
wb = load_workbook('test.xlsx')
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\reader\excel.py", line 314, in load_workbook
reader.read()
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\reader\excel.py", line 279, in read
self.read_worksheets()
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\reader\excel.py", line 254, in read_worksheets
charts, images = find_images(self.archive, rel.target)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\reader\drawings.py", line 39, in find_images
cs = get_rel(archive, deps, rel.id, ChartSpace)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\packaging\relationship.py", line 168, in get_rel
obj = cls.from_tree(tree)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree
return cls(**attrib)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\drawing\geometry.py", line 312, in __init__
self.w = w
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\base.py", line 67, in __set__
value = _convert(self.expected_type, value)
File "C:\sourcecode\pythonprojects\test\venv\lib\site-packages\openpyxl\descriptors\base.py", line 57, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'int'>
Process finished with exit code 1
Program code:
from openpyxl import load_workbook
wb = load_workbook('test.xlsx')
Attachments: test.xlsx