U [e& @sdZddlZddlZddlmZddlmZddlmZddl m Z ddl m Z m Z ddlmZdd lmZmZdd d Zdd d ZdddZdddZdddZdddZeZdS)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(SupportingPluginAvailableButNotInstalledcKs"t|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)afiler keywordsdatareaderrO/var/www/html/services/stratfitenv/lib/python3.8/site-packages/pyexcel_io/io.py iget_datas rcKs8|dk r|dkrtdt|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)rr r rr_rrrget_data:s  rcKsbt|r"|t||ptjdn6|dks2|dkrF|t||dn|t||dtf|S)N file_streamr  file_namer ) file_contentr )rupdatedictrFILE_FORMAT_CSV load_data)rr rrrrr\src Ks|}t|ttf}|r&d}tj|i}nt|}t|dk}t|oL|dk}|rXtj}t|rt| t ||dn| t ||d||d<t f|} | |W5QRXdS)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 `_ TNrrsingle_sheet_in_book) isinstancelistrrZDEFAULT_SHEET_NAMEkeyslenrr!rr get_writerwrite) rrr rZto_storeZis_listr$r'Z no_file_typewriterrrr save_datals     r,Fc  Ksi} |||g} dd| D} t| dkr2ttj|dkrv|rD|}n2z|dd}Wntk rtttjYnXzt ||}Wn"t t fk rt ||}YnXz|r|j |f| n0|r|j|f| n|r|j|f| ntd|r||} n4|dk r||} n|dk r.||} n|} | dkrl| D]}t| || |<qH|d}| |fWSt k r|rtj|rtj|rnttj|nttj|nYnXdS) 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 cSsg|]}|dk r|qSNr.0xrrr szload_data..r#N.zUnrecognized optionsF)r(IOErrorrMESSAGE_ERROR_02splitAttributeError Exception"MESSAGE_FILE_NAME_SHOULD_BE_STRINGr get_a_pluginr r ropen open_content open_streamZread_sheet_by_nameZread_sheet_by_indexZ read_manyZread_allr'r&closeospathexistsisfileZMESSAGE_NOT_FILE_FORMATTERZMESSAGE_FILE_DOES_NOT_EXIST)rrrr force_file_typeZ sheet_nameZ sheet_indexZsheetslibraryr rresultinputsnumber_of_none_inputsrkeyrrrr"sb           r"c Ks||g}dd|D}t|dkr,ttjd}|dkr||r||rF|}n2z|dd}Wntk rvttjYnXd}zt ||} Wn"t t fk rt ||} YnX|r|r| j |f|q| j|f|n|r| j|f|| S) zfind a suitable writercSsg|]}|dk r|qSr-rr.rrrr1szget_writer..r#TNr2r3F)r(r4rr5r6r7r8r9rr:r r rr<r;r=) rrr rDrCrrFrGZfile_type_givenr+rrrr)s0    r))N)NN)N)N) NNNNNNNNNF)NNNNN)__doc__r?rtypesrZ pyexcel_iorZpyexcel_io.readerrZpyexcel_io.writerrZpyexcel_io.pluginsrrZpyexcel_io._compactrZpyexcel_io.exceptionsr r rrrr,r"r)Z store_datarrrrs>       ! "  ' U -