Unable to load workbook with charts (<TypeError: expected <class 'openpyxl.chart.axis.NumericAxis'>)
*Created originally on Bitbucket by [M'Beth Schoenfeld](https://bitbucket.org/%7Bcbe98d3f-257c-43d8-b0e9-a66a4654dd9d%7D/)* Trying to open an excel sheet with the following python code: import openpyxl wb=openpyxl.load\_workbook\('PHPP\_V9.6a\_EN\_Pathfinder\_SI\_tester.xlsx'\) print\("sucess"\) here is the error I get: Traceback \(most recent call last\): File "C:\\Users\\ESchoenfeld\\Desktop\\PHPP Pathfinder\\PHPP\_excel\_test.py", line 2, in <module> wb=openpyxl.load\_workbook\('PHPP\_V9.6a\_EN\_Pathfinder\_SI\_tester.xlsx'\) File "build\\bdist.win-amd64\\egg\\openpyxl\\reader\\[excel.py](http://excel.py)", line 312, in load\_workbook File "build\\bdist.win-amd64\\egg\\openpyxl\\reader\\[excel.py](http://excel.py)", line 274, in read File "build\\bdist.win-amd64\\egg\\openpyxl\\reader\\[excel.py](http://excel.py)", line 249, in read\_worksheets File "build\\bdist.win-amd64\\egg\\openpyxl\\reader\\[drawings.py](http://drawings.py)", line 38, in find\_images File "build\\bdist.win-amd64\\egg\\openpyxl\\packaging\\[relationship.py](http://relationship.py)", line 161, in get\_rel File "build\\bdist.win-amd64\\egg\\openpyxl\\descriptors\\[serialisable.py](http://serialisable.py)", line 88, in from\_tree File "build\\bdist.win-amd64\\egg\\openpyxl\\descriptors\\[serialisable.py](http://serialisable.py)", line 88, in from\_tree File "build\\bdist.win-amd64\\egg\\openpyxl\\chart\\[plotarea.py](http://plotarea.py)", line 151, in from\_tree File "build\\bdist.win-amd64\\egg\\openpyxl\\descriptors\\[base.py](http://base.py)", line 44, in set TypeError: expected <class 'openpyxl.chart.axis.NumericAxis'> I’ve tried deleting all the charts from the workbook, but it doesn’t seem to make a difference, what am I missing? ‌ ‌ *Attachments:* [PHPP_V9.6a_EN_Pathfinder_SI_tester.xlsx](/uploads/e36dfe285d4e44fdea2a3d383f2a8f01/PHPP_V9.6a_EN_Pathfinder_SI_tester.xlsx)
issue