How to ignore blank lines with flask-excel when import from xlsx? about flask-excel HOT 8 CLOSED

>>> import pyexcel as pe
>>> sheet = pe.Sheet([[1,2,3],['','',''],['','',''],[1,2,3]])
>>> sheet
pyexcel sheet:
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
+---+---+---+
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
>>> def filter_row(row):
...     result = [element for element in row if element != '']
...     return len(result)==0
...
>>> sheet.filter(pe.RowValueFilter(filter_row))
>>> sheet
pyexcel sheet:
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+

excel_data = request.get_records(field_name='file')
not_null_line_data = []
for d in excel_data:
    if all(map(lambda x: x == '', d.values())):
        continue
    not_null_line_data.append(d)

book = request.get_book(field_name='file')
book['Sheet1'].filter(...)

excel_data = request.get_book_dict(field_name='file', skip_empty_row=True)

def filter_empty_row(row_index, row_content):
    empty_row = [element for element in row_content if element.strip() != '']
    return len(emtpy_row)  # delete it if True

book = request.get_book(field_name='file')
for sheet in book:
    del sheet.row[filter_empty_row]  # delete the empty lines 

book = request.get_book(field_name='file')
for sheet in book:
    del sheet.row[lambda _, row: len([element for element in row if row.strip() != '']) == 0]