import 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+---+---+--- +---+---+--- +---+---+---book you access each cell via this syntaxbook[sheet_index][rowcolumnorbook["sheet_name"][rowcolumnsuppose you have the following sheetsand you can randomly access cell in sheetbook pyexcel get_book(file_name="example xls"print(book["sheet "][ , ] print(book[ ][ , ]the same cell tipwith pyexcelyou can regard single sheet as an two dimensional array and multi-sheet excel book as an ordered dictionary of two dimensional arrays write multiple sheet excel book suppose you have previous data as dictionary and you want to save it as multiple sheet excel filecontent 'sheet '[ ][ ][ (continues on next page new tutorial