records (v0.5.3) is incompatible with latest Pandas (v1.2.4) cause they have requires different openpyxl version dependency, is there any way to fix this issue?

[baiyyee]

Incompatible Issues

• ImportError: Pandas requires version '2.6.0' or newer of 'openpyxl' (version '2.4.11' currently installed).
• records 0.5.3 requires openpyxl<2.5.0, but you have openpyxl 3.0.7 which is incompatible

Dependency Requirements:

• records 0.5.3 requires openpyxl<2.5.0
• Pandas 1.2.4 requires version '2.6.0' or newer of 'openpyxl'

[fymatsushita]

pip install openpyxl==3.0.5

[jennifer8801]

pip install openpyxl==3.0.5
mac m1
python3.9
records 0.5.3
pandas 1.2.4
it works for me,thanks

[kennethreitz]

Thank you for your kind contribution!!!!