openpyxl read excel with filtered data throws error "ValueError: Value must be either numerical or a string containing a wildcard"

Question

When I use openpyxl(version 3.1.2) to read an Excel with filtered data using following code: wb = openpyxl.load_workbook(file) it throws an error "ValueError: Value must be either numerical or a string containing a wildcard".

If I deselect the filter function in excel sheet, it works fine. but I don't want to deselect the filter function in Excel sheet, I expect the openpyxl.load_workbook(file) can work with filtered Excel sheet.