pandas / openpyxl version conflict

[justmobilize]

Hello! I have a dependency with pandas for reading xlsx files that requires:

Pandas requires version '3.1.0' or newer of 'openpyxl' (version '3.0.10' currently installed).

This change was merged roughly a year ago

Looking at the change log for openpyxl, it doesn't look like pinning to 3.1.0 from 3.0.10 (which is the next release) would cause any issues.

You are using it the same way I am (so the deprecations, should have zero effect):

    df = pd.read_excel(
        xls,
        sheet_name=sheet,
        usecols=[value, label],
        names=[col for col, _ in sorted(cols.items(), key=operator.itemgetter(1))],
        dtype=(str, str),
        header=header,
        skiprows=skiprows_list,
        engine="openpyxl",
    )

I'm happy to create a PR to update this, if it would be accepted