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