openpyxl
openpyxl copied to clipboard
Can not open excel with filtered column
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