o wh @sdZddlmZddlZddlmZmZddlmZm Z ddl m Z dddZ ddd Z dd d Zdd d ZdddZ          dddZ dddZdS)z pyexcel_io.io ~~~~~~~~~~~~~~~~~~~ The io interface to file extensions :copyright: (c) 2014-2017 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details ) GeneratorTypeN)isstreamPY2)READERSWRITERScKs"t|f|dd|\}}||fS)aGet 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 keywords: any other library specific parameters :returns: an ordered dictionary T file_type streaming) _get_data)afilerkeywordsdatareaderr?/var/www/html/env/lib/python3.10/site-packages/pyexcel_io/io.py iget_datas rcKs8|dur |dur tdt|f|dd|\}}|S)amGet 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 file_type: used only when filename is not a physial file name :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 keywords: any other library specific parameters :returns: an ordered dictionary NTzPlease use iget_data insteadFr)warningswarnr )r rr r r _rrrget_data1s  rcKsft|r|t||p tjdn|dus|dur#|t||dn |t||dtdi|S)N file_streamr file_namer) file_contentrr)rupdatedict constantsFILE_FORMAT_CSV load_data)r rr rrrr Lsr c Ks|}t|ttf}|rd}tj|i}ntr|}nt|}t|dk}t|o-|du}|r3tj }t ||f||d|dS)aGSave 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 library: explicitly name a library for use. e.g. library='pyexcel-ods' :param keywords: any other parameters that python csv module's `fmtparams `_ TN)rsingle_sheet_in_book) isinstancelistrrDEFAULT_SHEET_NAMErkeyslenrr store_data) r r rr to_storeis_listr!r% no_file_typerrr save_data\s*      r+cKslt|r|t||dn |t||dtdi|}||WddS1s/wYdS)aNon public function to store data to afile :param filename: actual file name, a file stream or actual content :param data: the data to be written :param file_type: used only when filename is not a physial file name :param keywords: any other parameters rrNr)rrr get_writerwrite)r r rr writerrrrr's  "r'Fc Ks:i} |||g} dd| D} t| dkrttj|dur7|r"|}nz |dd}Wn ty6tdwt||}|rI|j |fi| n|rU|j |fi| n |r`|j |fi| |rh| |} n|durr| |} n|dur|||} n|} | dur| D] }t| || |<q|d}| |fS) aLoad data from any supported excel formats :param filename: actual file name, a file stream or actual content :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 sheet_name: the name of the sheet to be loaded :param sheet_index: the index of the sheet to be loaded :param keywords: any other parameters cSg|]}|dur|qSNr.0xrrr zload_data..r N.!file_name should be a string typeF)r&IOErrorrMESSAGE_ERROR_02splitAttributeError Exceptionr get_a_pluginopen open_content open_streamread_sheet_by_nameread_sheet_by_index read_manyread_allr%r#close)rrrrforce_file_type sheet_name sheet_indexsheetslibraryr r resultinputsnumber_of_none_inputsrkeyrrrrsB         rc Ks||g}dd|D}t|dkrttjd}|dur5|r5z |dd}Wn ty2tdwd }t||}|rU|rJ|j |fi||S|j |fi||S|r`|j |fi||S) zfind a suitable writercSr/r0rr1rrrr4r5zget_writer..r TNr6r7r8F) r&r9rr:r;r<r=rr>r@r?rA) rrrrKr rMrNfile_type_givenr.rrrr,s,     r,r0)NN) NNNNNNNNNF)NNNN)__doc__typesrrpyexcel_io._compactrrpyexcel_io.pluginsrrpyexcel_io.constantsrrrr r+r'rr,rrrrs0       ' ?