Reading xlsx files

michaeljbarnes · May 20, 2021, 7:04pm

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?
Thanks

etejedor · May 21, 2021, 8:04am

Hello,

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

github.com

swan-cern/help/blob/master/docs/advanced/install_packages.md

# Install packages in CERNBox

LCG releases on CVMFS incorporate new packages quite frequently, so if you think there is a missing package that can be 
potentially useful for a significant number of users, please [let the SWAN team know](mailto:swan-talk@cern.ch) and 
[contact the librarians directly](https://sft.its.cern.ch/jira/projects/SPI).

On the other hand, you can install packages on your CERNBox and, if necessary, configure your environment to pick them 
up in SWAN. 

## Python

A typical case is the installation of Python packages, which requires to run pip from a SWAN terminal:

   `pip install --user package_name`

If this fails because you are trying to install an updated version of a package that already exists in CVMFS, you will need to add the `--upgrade` flag.

Then, it would be necessary to add the local installation path to `PYTHONPATH`, by creating a bash startup script that configures that variable (don't forget to call this startup script in the session configuration menu):

``` python

This file has been truncated. show original

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