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.