Skip to content

xlrd >= 2.0, only the xls format is supported. Install openpyxl instead #1

Description

@karilint

Hi John,
I was trying to reproduce your code - I'm almost there.
At some stage, (I don't remember when), I got this error regarding xls/xlsx files:
"Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead."

I added "import openpyxl" to the code and altered taxonomy_df = pd.read_excel(taxonomy_path, header=0).fillna('') --> taxonomy_df = pd.read_excel(taxonomy_path, header=0, engine='openpyxl').fillna(''). It seemed to work but then the last section of the code (the Main section), gives me an error: "Processing raw-spacytest-small
Preparing taxon patterns
Argument 'string' has incorrect type (expected str, got int)".

That may relate to the imported xlsx file or not. I'm quite new to Jupyter Notebook / python and therefore not able to say what is going on here. If you find a way to fix this, it would be great.

All the best,
-Kari

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions