filter out some data you may want to filter odd rows and print them in an array of dictionariessheet filter(row_indices=[ ]sheet content +++column column column +==========+==========+========== +++let' try to further filter out even columnssheet filter(column_indices=[ ]sheet content ++column column +==========+========== ++save the data let' save the previous filtered datasheet save_as("example_series_filter xls"when you open example_series_filter xlsyou will find these data column column how to filter out empty rows in my sheetsuppose you have the following data in sheet and you want to remove those rows with blanksimport pyexcel as pe sheet pe sheet([[ , , ],['','',''],['','',''],[ , , ]]you can use pyexcel filters rowvaluefilterwhich examines each rowreturn true if the row should be filtered out solet' define filter functiondef filter_row(row_indexrow)result [element for element in row if element !''return len(result)== and then apply the filter on the sheetdel sheet row[filter_rowsheet pyexcel sheet+---+---+---(continues on next page old tutorial