Error when loading .xlsm (load_workbook)
Created originally on Bitbucket by Vassilis Lemonidis
Probably has to do with 3D charts. Unfortunately, I cannot post more data, as they contain sensitive information, but I attach the charts. Please guide me on how to fix it and I will offer immediate feedback.
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/base.py", line 57, 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 "/code/TypesHandlers/excel/base.py", line 330, in _extract
work_book = load_workbook(self.path, data_only=True)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/reader/excel.py", line 274, in load_workbook
for c in find_charts(archive, rel.target):
File "/usr/local/lib/python3.5/dist-packages/openpyxl/chart/reader.py", line 43, in find_charts
drawing = SpreadsheetDrawing.from_tree(tree)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/serialisable.py", line 100, in from_tree
return cls(**attrib)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/drawing/shapes.py", line 261, in __init__
self.w = w
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/base.py", line 69, in __set__
value = _convert(self.expected_type, value)
File "/usr/local/lib/python3.5/dist-packages/openpyxl/descriptors/base.py", line 59, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'int'>
Attachments: bugshape_error.xlsx