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 source_library choose specific data source plugin for reading parser_library choose pyexcel parser plugin for reading skip_hidden_sheetsdefault is true please toggle it to read hidden sheets parameters related to csv file format for csvfmtparams are accepted delimiter field separator lineterminator line terminator encodingcsv specific specify the file encoding the csv file for exampleencoding='latin especiallyencoding='utf- -sigwould add utf bom header if used in rendereror would parse csv with utf brom header used in parser escapechar one-character string used by the writer to escape the delimiter if quoting is set to quote_none and the quotechar if doublequote is false quotechar one-character string used to quote fields containing special characterssuch as the delimiter or quotecharor which contain new-line characters it defaults to '"quoting controls when quotes should be generated by the writer and recognised by the reader it can take on any of the quote_constants (see section module contentsand defaults to quote_minimal skipinitialspace when truewhitespace immediately following the delimiter is ignored the default is false pep_ _off when true in python version pep- is turned on the default is false 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 support the project