skip_column_funcit allows you to write your own column skipping functions the protocol is to return pyexcel_io constants skip_data if skipping datapyexcel_io constants take_data to read datapyexcel_io constants stop_iteration to exit the reading procedure skip_empty_rowsbool defaults to false toggle it to true if the rest of empty rows are uselessbut it does affect the number of rows row_rendereryou could choose to write custom row renderer when the data is being read 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 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 support the project