in additionthis function use pyexcel sheet to render the data which could have performance penalty in exchangeparameters for pyexcel sheet can be passed one name_columns_by_row 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 save_book_as pyexcel save_book_as(**keywordssave book from data source to another one here is table of parameterssource loading from file loading from string loading from stream loading from sql loading from django models loading from dictionary loading from an url parameters file_namekeywords file_contentfile_typekeywords file_streamfile_typekeywords sessiontables models bookdict url where the dictionary should have text as keys and two dimensional array as values parameters file_name file with supported file extension file_content the file content file_stream the file stream file_type the file type in file_content or file_stream session database session tables list of database table models list of django models bookdict dictionary of two dimensional arrays url download http url for your excel file sheetsa list of mixed sheet names and sheet indices to be read this is done to keep pandas compactibility with this parametermore than one sheet can be read and you have the control to read the sheets of your interest instead of all available sheets auto_detect_float defaults to true auto_detect_int defaults to true auto_detect_datetime defaults to true ignore_infinity defaults to true library choose specific pyexcel-io plugin for reading api documentation