Ef&dZddlZddlZddlmZddlmZddlmZddl m Z ddl m Z m Z ddlmZdd lmZmZdd Zdd Zdd Zdd Z ddZ ddZeZdS)z pyexcel_io.io ~~~~~~~~~~~~~~~~~~~ The io interface to file extensions :copyright: (c) 2014-2022 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details N) GeneratorType) constants)Reader)Writer) OLD_READERS OLD_WRITERS)isstream)NoSupportingPluginFound(SupportingPluginAvailableButNotInstalledc 0t|f|dd|\}}||fS)aQGet data from an excel file source The data has not gone into memory yet. If you use dedicated partial read plugins, such as pyexcel-xlsxr, pyexcel-odsr, you will notice the memory consumption drop when you work with big files. :param afile: a file name, a file stream or actual content :param sheet_name: the name of the sheet to be loaded :param sheet_index: the index of the sheet to be loaded :param sheets: a list of sheet to be loaded :param file_type: used only when filename is not a physical file name :param force_file_type: used only when filename refers to a physical file and it is intended to open it as forced file type. :param library: explicitly name a library for use. e.g. library='pyexcel-ods' :param auto_detect_float: defaults to True :param auto_detect_int: defaults to True :param auto_detect_datetime: defaults to True :param ignore_infinity: defaults to True :param ignore_nan_text: various forms of 'NaN', 'nan' are ignored :param default_float_nan: choose one form of 'NaN', 'nan' :param pep_0515_off: turn off pep 0515. default to True. :param keep_trailing_empty_cells: keep trailing columns. default to False :param keywords: any other library specific parameters :returns: an ordered dictionary T file_type streaming) _get_data)afilerkeywordsdatareaders O/var/www/ffwdstore.be/apps/py-env/lib/python3.11/site-packages/pyexcel_io/io.py iget_datars=6 "d6>LD& <c `||durtjdt|f|dd|\}}|S)aIGet data from an excel file source :param afile: a file name, a file stream or actual content :param sheet_name: the name of the sheet to be loaded :param sheet_index: the index of the sheet to be loaded :param sheets: a list of sheet to be loaded :param file_type: used only when filename is not a physial file name :param force_file_type: used only when filename refers to a physical file and it is intended to open it as forced file type. :param streaming: toggles the type of returned data. The values of the returned dictionary remain as generator if it is set to True. Default is False. :param library: explicitly name a library for use. e.g. library='pyexcel-ods' :param auto_detect_float: defaults to True :param auto_detect_int: defaults to True :param auto_detect_datetime: defaults to True :param ignore_infinity: defaults to True :param ignore_nan_text: various forms of 'NaN', 'nan' are ignored :param default_float_nan: choose one form of 'NaN', 'nan' :param pep_0515_off: turn off pep 0515. default to True. :param keep_trailing_empty_cells: keep trailing columns. default to False :param keywords: any other library specific parameters :returns: an ordered dictionary NTzPlease use iget_data insteadFr )warningswarnr)rrrrr_s rget_datar:sY4d!2!2 4555 "e7?GD! Krc 4t|r1|t||p tjnM||%|t||n$|t||t di|S)N file_streamr file_namer) file_contentr)r updatedictrFILE_FORMAT_CSV load_data)rrrs rrr\s K !#@y'@        =I- OOD5IFFF G G G G OODeyIII J J J  x  rc @|}t|ttf}|rd}tj|i}n4t|}t |dk}t|o|du}|r tj}t|r%| t||n$| t||||d<tdi|5} | |ddddS#1swxYwYdS)aSave data to an excel file source Your data must be a dictionary :param filename: actual file name, a file stream or actual content :param data: a dictionary but an ordered dictionary is preferred :param file_type: used only when filename is not a physial file name :param force_file_type: used only when filename refers to a physical file and it is intended to open it as forced file type. :param library: explicitly name a library for use. e.g. library='pyexcel-ods' :param keywords: any other parameters that python csv module's `fmtparams `_ TNrr single_sheet_in_bookr#) isinstancelistrrDEFAULT_SHEET_NAMEkeyslenr r&r$r% get_writerwrite) rrrrto_storeis_listr*r. no_file_typewriters r save_datar6lsfHm455G.#0$7DIIKK  "4yyA~E??8yD'8L.- D)DDDEEEEu BBBCCC';H #$   h  6 Xs0DDDFc  zi} |||g} d| D} t| dkrttj|I|r|}nD |dd}n'#t $rt tjwxYw tj ||}n'#ttf$rt||}YnwxYw |r|j |fi| n1|r|j|fi| n |r|j|fi| ntd|r||} nD|||} n,|||} n|} | durE| D]}t+| || |<|d}| |fS#t$r{|rwt.j|rzload_data..@@@1!-Q---rr)N.zUnrecognized optionsF)r/IOErrorrMESSAGE_ERROR_02splitAttributeError Exception"MESSAGE_FILE_NAME_SHOULD_BE_STRINGr get_a_pluginr r ropen open_content open_streamread_sheet_by_nameread_sheet_by_index read_manyread_allr.r,closeospathexistsisfileMESSAGE_NOT_FILE_FORMATTERMESSAGE_FILE_DOES_NOT_EXIST)r!r"rrforce_file_type sheet_name sheet_indexsheetslibraryrrresultinputsnumber_of_none_inputsrkeys rr'r's.F{ 3F@@@@@ !!Q&&i0111  N'II N%OOC004 ! N N N LMMM N,))W== #%M N,,, 7++,&  2 FK . .X . . . .  2 F  9 9 9 9 9 9  2 F { 7 7h 7 7 7 7011 1  '..z::FF  $// <>),,!!.r>rr)TNr?r@F)r/rArrBrCrDrErFrrGr r rrIrHrJ) r!rrrZrVrr\r]file_type_givenr5s rr0r0s~ %F@@@@@ !!Q&&i0111OY  N'II N%OOC004 ! N N N LMMM N ,))W== #%M N,,, 7++,4  / F  6 6X 6 6 6 6 FK . .X . . . . 4;33(333 Ms A%%$B B%%!C C r9)NN) NNNNNNNNNF)NNNNN)__doc__rPrtypesr pyexcel_iorpyexcel_io.readerrpyexcel_io.writerrpyexcel_io.pluginsrrpyexcel_io._compactr pyexcel_io.exceptionsr r rrrr6r'r0 store_datar#rrrksz  $$$$$$$$$$$$77777777(((((( BD ! ! ! ! ####N  QQQQj  ))))Z r