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 pyexcel get_book pyexcel get_book(**keywordsget an instance of book from an excel source 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 support the project