search

theorchard / openpyxl

Other
58 stars 21 forks source link

Can not open excel with filtered column #31

Open gelekgm opened 1 year ago

gelekgm commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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

jacmrob commented 1 year ago

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 commented 9 months ago

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