search

AgileBioFoundry / FA-NGS

This is a software utility for calculating pooling volumes and graphing quality control data of next generation sequencing (NGS) libraries.
Other
2 stars 0 forks source link

xlrd no longer supports xlsx, this breaks app #1

Open jdmccauley opened 3 years ago

jdmccauley commented 3 years ago

Hi FA-NGS team,

I tried to run the FA-NGS app a few weeks ago and ran into an error saying that it could not read xlsx files. I found my own way around this, and assumed I was doing something wrong. I got a similar issue in another project today and learned that xlrd did in fact drop xlsx support. This means that as is, this dependency breaks the whole project.

I recommend switching to a new excel read module, or use an older version of xlrd when it used to support xlsx. I'm working on this somewhere else, and will report what works for me.

Best, Josh

jdmccauley commented 3 years ago

Hi FA-NGS team,

I found that version 1.2.0 of xlrd works as a temporary fix. It's a security risk to use the older version, so apparently the package openpxyl is better long term.

To install xlrd version 1.2.0: pip install xlrd==1.2.0

Found that solution on stackoverflow: https://stackoverflow.com/questions/65254535/xlrd-biffh-xlrderror-excel-xlsx-file-not-supported

Best, Josh