When using pandas.read_excel()
I get the following error:
ImportError: Pandas requires version ‘3.1.0’ or newer of ‘openpyxl’ (version ‘3.0.10’ currently installed).
My current versions:
- pandas: 2.2.1
- openpyxl: 3.0.10
I upgraded openpyxl as described in this post /questions/78154244/unable-to-update-to-latest-openpyxl-version-3-1-or-later-using-anaconda-prompt, however it still have version 3.0.10 and get the same error message.
I also tried to uninstall pandas and openpyxl to afterwards reinstall them, however I get the following messages which load forever which makes it not possible to uninstall the packages:
The environment is inconsistent, please check the package plan carefully
The following packages are causing the inconsistency:defaults/win-64::anaconda-client==1.12.3=py39haa95532_0
defaults/win-64::anaconda==custom=py39_1
defaults/win-64::anaconda-navigator==2.5.2=py39haa95532_0
defaults/win-64::conda==23.9.0=py39haa95532_0
defaults/win-64::conda-build==3.27.0=py39haa95532_0
….
What is the issue here? I never had this problem before.
Would appreciate any help.