parameters related to xls file formatplease note the following parameters apply to pyexcel-xls more details can be found in xlrd open_workbook(logfilean open file to which messages and diagnostics are written verbosityincreases the volume of trace material written to the logfile use_mmapwhether to use the mmap module is determined heuristically use this arg to override the result current heuristicmmap is used if it exists encoding_overrideused to overcome missing or bad codepage information in older-version files 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 free_resources pyexcel free_resources(close file handles opened by signature functions that starts with 'ifor 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 saving data to excel file save_as(**keywordsisave_as(**keywordssave_book_as(**keywordsisave_book_as(**keywordssave sheet from data source to another one save sheet from data source to another one with less memory save book from data source to another one save book from data source to another one pyexcel save_as pyexcel save_as(**keywordssave sheet from data source to another one it accepts two sets of keywords why two setsone set is sourcethe other set is destination in order to distinguish the two setssource set will be exactly the same as the ones for pyexcel get_sheet()destination set are exactly the same as the ones for pyexcel sheet save_as but require 'destprefix api documentation