Unable to load workbook with charts (<TypeError: expected <class 'openpyxl.chart.axis.NumericAxis'>)

Created originally on Bitbucket by M'Beth Schoenfeld

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
wb=openpyxl.load_workbook('PHPP_V9.6a_EN_Pathfinder_SI_tester.xlsx')
File "build\bdist.win-amd64\egg\openpyxl\reader\excel.py", line 312, in load_workbook
File "build\bdist.win-amd64\egg\openpyxl\reader\excel.py", line 274, in read
File "build\bdist.win-amd64\egg\openpyxl\reader\excel.py", line 249, in read_worksheets
File "build\bdist.win-amd64\egg\openpyxl\reader\drawings.py", line 38, in find_images
File "build\bdist.win-amd64\egg\openpyxl\packaging\relationship.py", line 161, in get_rel
File "build\bdist.win-amd64\egg\openpyxl\descriptors\serialisable.py", line 88, in from_tree
File "build\bdist.win-amd64\egg\openpyxl\descriptors\serialisable.py", line 88, in from_tree
File "build\bdist.win-amd64\egg\openpyxl\chart\plotarea.py", line 151, in from_tree
File "build\bdist.win-amd64\egg\openpyxl\descriptors\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