auto_detect_datetime automatically convert text to python datetime if possible this applies only pyexcel-io where csvtsvcsvz and tsvz formats are supported by defaultit does the detection setting it to false will turn on this behavior library name pyexcel plugin to handle file format in the situation where multiple plugins were pip installedit is confusing for pyexcel on which plugin to handle the file format for exampleboth pyexcel-xlsx and pyexcel-xls reads xlsx format now since version you can pass on library="pyexcel-xlsto handle xlsx in specific function call it is better to uninstall the unwanted pyexcel plugin using pip if two plugins for the same file type are not absolutely necessary cookbook merge_csv_to_a_book(filelist[outfilename]merge_all_to_a_book(filelist[outfilename]split_a_book(file_name[outfilename]extract_a_sheet_from_a_book(file_namesheetnamemerge list of csv files into excel book merge list of excel files into excel book split file into separate sheets extract sheet from excel book pyexcel merge_csv_to_a_book pyexcel merge_csv_to_a_book(filelistoutfilename='merged xls'merge list of csv files into excel book parameters filelist (lista list of accessible file path outfilename (strsave the sheet as pyexcel merge_all_to_a_book pyexcel merge_all_to_a_book(filelistoutfilename='merged xls'merge list of excel files into excel book parameters filelist (lista list of accessible file path outfilename (strsave the sheet as pyexcel split_a_book pyexcel split_a_book(file_nameoutfilename=nonesplit file into separate sheets parameters file_name (stran accessible file name api documentation