Skip to content

Handle engines for pandas.read_excel #910

@patricklnz

Description

@patricklnz

With the update to pandas 2.2.0 (Documentation) the read_excel function fails with the openpyxl engine.
Pandas have added a new engine calamine which can be up to 5x faster than openpyxl.
I think we should take that, but pandas versions smaller than that should also work with our programm

A possible solution would be checking the used pandas version and decide from that which engine to use.
`from distutils.version import LooseVersion

if LooseVersion(pd.__version) > LooseVersion(2.2.0):
    engine = 'calamine'
else:
    engine = 'openpyxl`

@mknaranja what's your opinion on that?

Metadata

Metadata

Assignees

Labels

loc::data handlingThis issue concerns any kind of data handling.

Type

No type

Projects

Status

✅ Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions