Can not open excel with filtered column

[gelekgm]

Hello, There`s and issue with 'self.read_worksheets()' when trying to open Excel file with specific structure. Issue discovered within pandas as backend. Method is unable to open excel file when there is column with filter that hide 'blank' cells. More details in link below

https://github.com/pandas-dev/pandas/issues/51557

[azhu26]

I can confirm the issue. it emerged in the latest vesion: 3.1.2. On the other hand, if downgrading openpyxl to 3.0.10, the ValueError will be gone.

see discussion here: https://github.com/pandas-dev/pandas/issues/53238

and attached excel file tto test.

test-filter.xlsx

[fjcamillo]

Was also encountering this, looks like Openpyxl is using this source https://foss.heptapod.net/openpyxl/openpyxl

[jacmrob]

Is there a plan to fix this or a workaround to read from a worksheet with an active filter? My use case will be ingesting worksheets from customers so simply removing the filter in the excel file is not an option

[obertrand-ewolff]

There is work in progress here: https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1967