Bug#1017470: python3-pandas: Regression on upgrade from Buster to Bullseye: No data read from certain xlsx file

[David Auer]

Package: python3-pandas
Version: 1.1.5+dfsg-2
Severity: important

Dear Maintainer,

after upgrading Buster to Bullseye a Python script reading data from
xlsx files stopped working. This is because of a known bug when using
pandas with openpyxl which is now used by default for reading xlsx files
instead of xlrd:
https://github.com/pandas-dev/pandas/pull/39486

It has been fixed in pandas and backported to 1.2.2 therefore I'd like to have that
or a later version packaged for Bullseye, at least as a backport.

As a workaround we set the engine to xlrd in our Python script, but that
is not ideal because they removed support for xlsx files in the current
version. I'd really like to get rid of it and use openpyxl instead.

(Removing system information as this is not the system where the bug
occured.)

Unfortunately I can't attach the xlsx file because it contains sensitive
data. Let me know if there is anything else I can do.

Thanks!

David