Reading xlsx files

xlrd doesn’t now seem to support reading xlsx files: I het the error message: XLRDError: Excel xlsx file; not supported

I searched on the web and see the recommendation to use ‘openyxl’

pip install --used openpyxl
seemed to work ok

However, the following line:
inductancedata = np.array(pd.read_excel(‘MKP_Magnetic_11x11_Matrix.xlsx’, engine=‘openpyxl’))

results in the following error:
ValueError: Unknown engine: openpyxl

Any ideas please?


My guess is that you still need to define the PYTHONPATH to point to it, see:

You need to create a user environment script that modifies the PYTHONPATH on session startup.