o hv@s~dZddlZddlmZddlmZddlmZddl m m Z ddl mZmZddlmZddlmZmZmZdZdZeejdd Zeejd d Zeejd d ZeejddZeej ddZ!eej"ddZ#eej$ddZ%eej&ddZ'eej(d&ddZ)eej*d&ddZ+eej,ddZ-eej.d'ddZ/eej0d d!Z1d"d#Z2d$d%Z3dS)(z pyexcel.core ~~~~~~~~~~~~~~~~~~~ A list of pyexcel signature functions :copyright: (c) 2015-2017 by Onni Software Ltd. :license: New BSD License N)Bookto_book)Sheet) OrderedDict append_doc zip_longestz ^dest_(.*)z^This function does not accept parameters for pyexce.Sheet. Please use pyexcel.save_as instead.cKsPi}tjD] }||vr||||<qtjdi|}t|j|jfi|}|S)z@ Get an instance of :class:`Sheet` from an excel source N) constantsVALID_SHEET_PARAMETERSpopsourcesget_sheet_streamrpayloadname)keywords sheet_paramsfield named_contentsheetrr>/var/www/html/env/lib/python3.10/site-packages/pyexcel/core.py get_sheets rcKs*tjdi|}t||j|jd}|S)z? Get an instance of :class:`Book` from an excel source )filenamepathNr)r get_book_streamrto_dictrr)r book_streambookrrrget_book)srcKstjdddi|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_demandTNr)r r)rrrr iget_book7srcKstdi|\}}i}tjD] }||vr||||<qtjdi|}|j}d|vr/|d}t|j|fi|}tj |fi|S)z8 Save a sheet from a data source to another one sheet_nameNr) _split_keywordsr r r r r rrr save_sheet)r dest_keywordssource_keywordsrr sheet_streamoutput_sheet_namerrrrsave_asBs r'cKsftdi|\}}tjD] }||vrttq tjdddi|}d|vr*|d|_tj|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. rTr Nr) r!r r ExceptionSAVE_AS_EXCEPTIONr r rr")rr#r$rrrrrisave_asTs  r*cKs<tdi|\}}tjdi|}t|}tj|fi|S)z7 Save a book from a data source to another one Nr)r!r rr save_bookrr#r$rrrr save_book_asgsr-cKs8tdi|\}}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. rTNr)r!r rr+r,rrr isave_book_asrs r.cKtdi|}|S)z Obtain an array from an excel source It accepts the same parameters as :meth:`~pyexcel.get_sheet` but return an array instead. Nr)rto_array)rrrrr get_arrayr1cKstdd|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_rowNr)rrr3rrrrrget_dictsr5cKstdd|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) r3Nr)rlist to_recordsr4rrr get_recordss r8cKstjdddi|}|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. rTNr)r r r)rr%rrr iget_arraysr9c kstjdddi|}d}t|jD]4\}}|dkr|}q|r;tt||tjd}t}|D]}||||<q.|Vqtt||tjdVqdS)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) fillvaluer) r r enumeraterdictrr DEFAULT_NAr) custom_headersrr%headers row_indexrowtmp_dict ordered_dictrrrr iget_recordss$ rDcKr/)z Obtain a dictionary of two dimensional arrays It accepts the same parameters as :meth:`~pyexcel.get_book` but return a dictionary instead. Nr)rr)rrrrr get_book_dictr2rEcCst|}|dur d}|S)z5 Return the io stream types, string or bytes Nstring)manager get_io_type) file_typeio_typerrrrHs rHcKsNi}i}|D]\}}tt|}|r|d}|||<q|||<q||fS)N)itemsrematchSTARTS_WITH_DESTgroup)rr#r$keyvalueresult parameterrrrr!s    r!)r)N)4__doc__rMpyexcel.constantsr pyexcel.docstrings docstringsdocspyexcel_io.managerrGpyexcel.internal.coreinternalcorer pyexcel.bookrr pyexcel.sheetrpyexcel._compactrrrrOr) GET_SHEETrGET_BOOKr IGET_BOOKrSAVE_ASr'ISAVE_ASr* SAVE_BOOK_ASr- ISAVE_BOOK_ASr. GET_ARRAYr1GET_DICTr5 GET_RECORDSr8 IGET_ARRAYr9 IGET_RECORDSrD GET_BOOK_DICTrErHr!rrrrsP