HfdZddlZddlmZddlmZddlmZmZddl m Z ddl m Z m Z mZddlmZdd lmZd Zd Ze ejd Ze ejd Ze ejdZe ejdZe ejdZe ej dZ!e ej"dZ#e ej$dZ%e ej&ddZ'e ej(ddZ)e ej*dZ+e ej,ddZ-e ej.dZ/dZ0dZ1dS)z pyexcel.core ~~~~~~~~~~~~~~~~~~~ A list of pyexcel signature functions :copyright: (c) 2015-2022 by Onni Software Ltd. :license: New BSD License N) constants) docstrings)Bookto_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.c i}tjD]}||vr||||<tjdi|}t |j|jfi|}|S)z@ Get an instance of :class:`Sheet` from an excel source )rVALID_SHEET_PARAMETERSpopsourcesget_sheet_streamrpayloadname)keywords sheet_paramsfield named_contentsheets N/var/www/ffwdstore.be/apps/py-env/lib/python3.11/site-packages/pyexcel/core.py get_sheetrsu L166 H  "*,,u"5"5L ,88x88M -'); L L| L LE Lc tjdi|}t||j|j}|S)z? Get an instance of :class:`Book` from an excel source )filenamepathr)rget_book_streamrto_dictrr)r book_streambooks rget_bookr$*sP )55H55K %     D Krc (tjdddi|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_demandTr)rr )rs r iget_bookr'8s   " > >T >X > >>rc tdi|\}}i}tjD]}||vr||||<t jdi|}|j}d|vr|d}t|j|fi|}t j |fi|S)z8 Save a sheet from a data source to another one sheet_namer) _split_keywordsrrrrrrrr save_sheet)r dest_keywordssource_keywordsrr sheet_streamoutput_sheet_namers rsave_asr0Cs &5%@%@x%@%@"M?L1== O # #"1"5"5e"<">o>>L$)}$$),7 ,&(9 J J\ J JE  e 5 5} 5 55rc tdi|\}}tjD]}||vrttt jdddi|}d|vr |d|_t j|fi|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. r&Tr)r) r*rr ExceptionSAVE_AS_EXCEPTIONrrrr+)rr,r-rrs risave_asr4Us&5%@%@x%@%@"M?1// O # #-.. . $  $ G Gt G G GE}$$"<0  e 5 5} 5 55rc tdi|\}}tjdi|}t|}tj|fi|S)z7 Save a book from a data source to another one r)r*rr r save_bookrr,r-r#s r save_book_asr8hsV &5%@%@x%@%@"M?  " 5 5_ 5 5D 4==D  T 3 3] 3 33rc jtdi|\}}tjdddi|}tj|fi|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. r&Tr)r*rr r6r7s r isave_book_asr:ssP&5%@%@x%@%@"M?  " E ET E_ E ED  T 3 3] 3 33rc Btdi|}|S)z Obtain an array from an excel source It accepts the same parameters as :meth:`~pyexcel.get_sheet` but return an array instead. r)rto_array)rrs r get_arrayr=s'  ! ! ! !E >>  rc Ftdd|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_rowr)rr!r?rrs rget_dictrAs+"  J J*= J J JE ==??rc `tdd|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) r?r)rlist to_recordsr@s r get_recordsrEs7"  J J*= J J JE   "" # ##rc 6tjdddi|}|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. r&Tr)rrr)rr.s r iget_arrayrGs(+GGdGhGGL  rc+lKtjdddi|}d}t|jD]\}}|dkr|}|rLt t ||t j}t}|D] }||||<|V\tt ||t jVdS)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. r&TNr) fillvaluer) rr enumeraterdictr r DEFAULT_NAr) custom_headersrr.headers row_indexrowtmp_dict ordered_dictrs r iget_recordsrSs+GGdGhGGLG#L$899 3 >>GG  8LMMM +}} *88D)1$L&&"""""" 8LMMMrc Btdi|}|S)z Obtain a dictionary of two dimensional arrays It accepts the same parameters as :meth:`~pyexcel.get_book` but return a dictionary instead. r)r$r!)rr#s r get_book_dictrUs%   h  D <<>>rc6tj|}|d}|S)z5 Return the io stream types, string or bytes Nstring)r get_io_type) file_typeio_types rrXrXs#!),,G Nrc i}i}|D]A\}}tjt|}|r|d}|||<<|||<B||fS)N)itemsrematchSTARTS_WITH_DESTgroup)rr,r-keyvalueresult parameters rr*r*swMOnn&&)) U*C00  ) QI',M) $ $#(OC / ))r)r)N)2__doc__r^pyexcelrrdocs pyexcel.bookrr pyexcel.sheetrpyexcel._compactrr r pyexcel.internalr r pyexcel_ior r`r3 GET_SHEETrGET_BOOKr$ IGET_BOOKr'SAVE_ASr0ISAVE_ASr4 SAVE_BOOK_ASr8 ISAVE_BOOK_ASr: GET_ARRAYr=GET_DICTrA GET_RECORDSrE IGET_ARRAYrG IGET_RECORDSrS GET_BOOK_DICTrUrXr*rrrr{s ******&&&&&&&&&&&&&&AAAAAAAAAA,,,,,,)))))):  DN    DM    DN??? DL666" DM666$ D 444 D  4 4  4 DN DM( D $$$$( DO    D > D   * * * * *r