How can issues with pandas.read_excel be resolved?

Category:
Scripting
Answer

There can be issues when calling pandas.read_excel starting from PowerFactory 2023 SP4 when an Anaconda is used. This is because with PowerFactory 2023 SP4 we started shipping a new version of libxml2.dll, because of a security problem with the old. But Anaconda at this point still ships an older version which leads to the problem.

As workaround we recommend to use CPython 3.11. Missing libraries like numpy can be easily installed via:

pip install numpy

 

 

Back