Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
pandas read excel with openpyxl
Added on May 11, 2020 11:25AM
Likes: 1
Replies: 1
piyushk
Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Adv Designer, Registered Posts: 55 ✭✭✭✭✭
I am trying to read xlsx and xlsm file using pandas read_excel method with engine as openpyxl. I am getting error as <class 'ValueError'>: Unknown engine: openpyxl.
Upon searching on internet, i got to know that pandas==0.23.4 does not support engine parameter. Therefore, I tried upgrading pandas==0.25.3 where engine is supported. I am unable to perform the upgrade as well.
How can I resolve the issue, so that I can read excel files using openpyxl?
Answers
-
Hi,
It is not currently possible to read Excel files in DSS using pandas+openpyxl. You can either using pandas+xlrd (i.e. the default pandas engine) or openpyxl itself, but not with pandas' openpyxl engine.
We are looking into upgrading pandas in a future version of DSS.
