formatting_infothe default is falsewhich saves memory when trueformatting information will be read from the spreadsheet file this provides all cellsincluding empty and blank cells formatting information is available for each cell ragged_rowsthe default of false means all rows are padded out with empty cells so that all rows have the same size as found in ncols true means that there are no empty cells at the ends of rows this can result in substantial memory savings if rows are of widely varying sizes see also the row_len(method when you use this function to work on physical filesthis function will leave its file handle open when you finish the operation on its datayou need to call pyexcel free_resources(to close file hande(sfor csvcsvz file formatsfile handles will be left open for xlsods file formatsthe file is read all into memory and is close afterwards for xlsxfile handles will be left open in python by pyexcel-xlsx(openpyxlin other wordspyexcel-xlspyexcel-odspyexcel-ods won' leak file handles pyexcel iget_records pyexcel iget_records(custom_headers=none**keywordsobtain generator of list of records from an excel source it is similiar to pyexcel get_records(but it has less memory footprint but requires the headers to be in the first row and the data matrix should be of equal length it should consume less memory and should work well with large files examples on start_rowstart_column let' assume the following file is huge csv fileimport datetime import pyexcel as pe data [ ][ ][ ][ ][ ][ pe save_as(array=datadest_file_name="your_file csv"and let' pretend to read partial datape get_sheet(file_name="your_file csv"start_row= row_limit= your_file csv+---+----+---- +---+----+---- +---+----+---- +---+----+----and you could as well do the same for columns api documentation