U ±[Öe‹ã@sxdZddlZddlmZddlmZddlmZmZddl m Z ddl m Z m Z mZddlmZdd lmZd Zd Ze ejƒd d „ƒZe ejƒdd„ƒZe ejƒdd„ƒZe ejƒdd„ƒZe ejƒdd„ƒZe ej ƒdd„ƒZ!e ej"ƒdd„ƒZ#e ej$ƒdd„ƒZ%e ej&ƒd*dd„ƒZ'e ej(ƒd+dd„ƒZ)e ej*ƒd d!„ƒZ+e ej,ƒd,d"d#„ƒZ-e ej.ƒd$d%„ƒZ/d&d'„Z0d(d)„Z1dS)-z¨ pyexcel.core ~~~~~~~~~~~~~~~~~~~ A list of pyexcel signature functions :copyright: (c) 2015-2022 by Onni Software Ltd. :license: New BSD License éN)Ú constants)Ú docstrings)ÚBookÚto_book)ÚSheet)Ú OrderedDictÚ append_docÚ zip_longest)Úcore)Úmanagerz ^dest_(.*)z^This function does not accept parameters for pyexce.Sheet. Please use pyexcel.save_as instead.cKsHi}tjD]}||kr | |¡||<q tjf|Ž}t|j|jf|Ž}|S)z@ Get an instance of :class:`Sheet` from an excel source )rÚVALID_SHEET_PARAMETERSÚpopÚsourcesÚget_sheet_streamrÚpayloadÚname)ÚkeywordsÚ sheet_paramsÚfieldZ named_contentÚsheet©rúN/var/www/html/services/stratfitenv/lib/python3.8/site-packages/pyexcel/core.pyÚ get_sheets  rcKs&tjf|Ž}t| ¡|j|jd}|S)z? Get an instance of :class:`Book` from an excel source )ÚfilenameÚpath)rÚget_book_streamrÚto_dictrr)rZ book_streamÚbookrrrÚget_book*s ýrcKstjfddi|—ŽS)z¢ Get an instance of :class:`BookStream` from an excel source First use case is to get all sheet names without extracting the sheets into memory. Ú on_demandT)rr)rrrrÚ iget_book8sr cKsttf|Ž\}}i}tjD]}||kr| |¡||<qtjf|Ž}|j}d|krV|d}t|j|f|Ž}tj |f|ŽS)z8 Save a sheet from a data source to another one Ú sheet_name) Ú_split_keywordsrr r rrrrrÚ save_sheet)rÚ dest_keywordsÚsource_keywordsrrÚ sheet_streamZoutput_sheet_namerrrrÚsave_asCs  r'cKs^tf|Ž\}}tjD]}||krttƒ‚qtjfddi|—Ž}d|krP|d|_tj|f|ŽS)zá Save a sheet from a data source to another one with less memory It is simliar to :meth:`pyexcel.save_as` except that it does not accept parameters for :class:`pyexcel.Sheet`. And it read when it writes. rTr!) r"rr Ú ExceptionÚSAVE_AS_EXCEPTIONrrrr#)rr$r%rrrrrÚisave_asUs    r*cKs0tf|Ž\}}tjf|Ž}t|ƒ}tj|f|ŽS)z7 Save a book from a data source to another one )r"rrrÚ save_book©rr$r%rrrrÚ save_book_ashs r-cKs0tf|Ž\}}tjfddi|—Ž}tj|f|ŽS)zÚ Save a book from a data source to another one It is simliar to :meth:`pyexcel.save_book_as` but it read when it writes. This function provide some speedup but the output data is not made uniform. rT)r"rrr+r,rrrÚ isave_book_asss r.cKstf|Ž}| ¡S)z‘ Obtain an array from an excel source It accepts the same parameters as :meth:`~pyexcel.get_sheet` but return an array instead. )rZto_array)rrrrrÚ get_arrays r/cKstfd|i|—Ž}| ¡S)a“ Obtain a dictionary from an excel source It accepts the same parameters as :meth:`~pyexcel.get_sheet` but return a dictionary instead. Specifically: name_columns_by_row : specify a row to be a dictionary key. It is default to 0 or first row. If you would use a column index 0 instead, you should do:: get_dict(name_columns_by_row=-1, name_rows_by_column=0) Úname_columns_by_row)rr©r0rrrrrÚget_dictsr2cKstfd|i|—Ž}t| ¡ƒS)a¬ Obtain a list of records from an excel source It accepts the same parameters as :meth:`~pyexcel.get_sheet` but return a list of dictionary(records) instead. Specifically: name_columns_by_row : specify a row to be a dictionary key. It is default to 0 or first row. If you would use a column index 0 instead, you should do:: get_records(name_columns_by_row=-1, name_rows_by_column=0) r0)rÚlistZ to_recordsr1rrrÚ get_records¢sr4cKstjfddi|—Ž}|jS)z¤ Obtain a generator of an two dimensional array from an excel source It is similiar to :meth:`pyexcel.get_array` but it has less memory footprint. rT)rrr)rr&rrrÚ iget_array·sr5c kstjfddi|—Ž}d}t|jƒD]h\}}|dkr8|}q"|rttt||tjdƒ}tƒ}|D]}||||<qZ|Vq"tt||tjdƒVq"dS)aK Obtain a generator of a list of records from an excel source It is similiar to :meth:`pyexcel.get_records` but it has less memory footprint but requires the headers to be in the first row. And the data matrix should be of equal length. It should consume less memory and should work well with large files. rTNr)Ú fillvalue) rrÚ enumeraterÚdictr rZ DEFAULT_NAr) Zcustom_headersrr&ÚheadersZ row_indexÚrowZtmp_dictZ ordered_dictrrrrÚ iget_recordsÃs ÿÿr;cKstf|Ž}| ¡S)z Obtain a dictionary of two dimensional arrays It accepts the same parameters as :meth:`~pyexcel.get_book` but return a dictionary instead. )rr)rrrrrÚ get_book_dictãs r<cCst |¡}|dkrd}|S)z5 Return the io stream types, string or bytes NÚstring)r Ú get_io_type)Ú file_typeZio_typerrrr>ïs r>cKsNi}i}| ¡D]4\}}t t|¡}|r<| d¡}|||<q|||<q||fS)Né)ÚitemsÚreÚmatchÚSTARTS_WITH_DESTÚgroup)rr$r%ÚkeyÚvalueÚresultZ parameterrrrr"ùs    r")r)r)N)2Ú__doc__rBZpyexcelrrÚdocsZ pyexcel.bookrrZ pyexcel.sheetrZpyexcel._compactrrr Zpyexcel.internalr rZ pyexcel_ior rDr)Z GET_SHEETrZGET_BOOKrZ IGET_BOOKr ZSAVE_ASr'ZISAVE_ASr*Z SAVE_BOOK_ASr-Z ISAVE_BOOK_ASr.Z GET_ARRAYr/ZGET_DICTr2Z GET_RECORDSr4Z IGET_ARRAYr5Z IGET_RECORDSr;Z GET_BOOK_DICTr<r>r"rrrrÚsN      ÿ