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 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 pyexcel get_records pyexcel get_records(name_columns_by_row= **keywordsobtain list of records from an excel source it accepts the same parameters as get_sheet(but return list of dictionary(recordsinstead specificallyname_columns_by_row specify row to be dictionary key it is default to or first row if you would use column index insteadyou should doget_records(name_columns_by_row=- name_rows_by_column= examples on start_rowstart_column let' assume the following file is huge csv file support the project