Loading workbook error: float() argument must be a string or a number, not 'NoneType'
*Created originally on Bitbucket by [megavolts](https://bitbucket.org/%7Bb8759c7a-b72f-482f-8f7d-4ff9c2150a84%7D/)* Hello, I have a script which importe several workbook in a row. However, the importation work only for one notebook LAB_CRREL_-20141112B.xlsx and failed with the same error for the other one, for example LAB_CRREL-2014110A.xlsx. I have tried to examine the .xlsx files to see what differences there. As they are all based on the same template, I wasn't able to find significant difference, beside the numbers. (edit 2017-08-31 6:11pm) After downgrading openpyxl to 2.4.1, the problem dissapeared. Version 2.4.8 works well too. All the workbook are based on the same template, only float value varies in them. Code: ``` #!python import openpyxl wb1 = openpyxl.load_workbook('/mnt/data_local/UAF/data/RSOI/core/data/LAB_CRREL_-20141112B.xlsx') wb2 = openpyxl.load_workbook('/mnt/data_local/UAF/data/RSOI/core/data/LAB_CRREL_-20141110A.xlsx') Here is the error messages: ` Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 57, in _convert value = expected_type(value) TypeError: float() argument must be a string or a number, not 'NoneType' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/IPython/core/interactiveshell.py", line 2862, in run_code exec(code_obj, self.user_global_ns, self.user_ns) File "<ipython-input-23-e7757d6ead32>", line 1, in <module> openpyxl.load_workbook('/mnt/data_local/UAF/data/RSOI/core/data/LAB_CRREL-20141112B.xlsx') File "/usr/lib/python3.6/site-packages/openpyxl/reader/excel.py", line 274, in load_workbook for c in find_charts(archive, rel.target): File "/usr/lib/python3.6/site-packages/openpyxl/chart/reader.py", line 52, in find_charts cs = get_rel(archive, deps, rel.id, ChartSpace) File "/usr/lib/python3.6/site-packages/openpyxl/packaging/relationship.py", line 158, in get_rel obj = cls.from_tree(tree) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/lib/python3.6/site-packages/openpyxl/chart/plotarea.py", line 146, in from_tree self = super(PlotArea, cls).from_tree(node) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree obj = desc.expected_type.from_tree(el) [Previous line repeated 2 more times] File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 99, in from_tree return cls(**attrib) File "/usr/lib/python3.6/site-packages/openpyxl/chart/data_source.py", line 62, in __init__ self.v = v File "/usr/lib/python3.6/site-packages/openpyxl/chart/data_source.py", line 46, in __set__ super(NumberValueDescriptor, self).__set__(instance, value) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/nested.py", line 36, in __set__ super(Nested, self).__set__(instance, value) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 69, in __set__ value = _convert(self.expected_type, value) File "/usr/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 59, in _convert raise TypeError('expected ' + str(expected_type)) TypeError: expected <class 'float'> ``` ` *Attachments:* [LAB_CRREL-20141110A.xlsx](/uploads/e3e6e3e9e24c3f77b9fa6efe31521930/LAB_CRREL-20141110A.xlsx)[LAB_CRREL-20141112B.xlsx](/uploads/339286185648e6645255e701f9814ff0/LAB_CRREL-20141112B.xlsx)
issue