a oEb@sUddlmZddlmZmZmZmZmZmZm Z m Z m Z m Z ddl mZddlmZmZerddlmZeeZe deegefdZiZded <d d d d dZdFddddddZdd dddZdddddZdddddZe d dd!d"d#Ze d$d$d!d%d#Ze ddd!d&d#Ze d d d!d'd#Zd(d)d!d*d#Ze d+d,d-d.d/Z e d d0d-d1d/Z d2d3d-d4d/Z d5d6d7d8d9d:Z!d5d;dd?Z"d@dAdAdBdCdDZ#dES)G) annotations) TYPE_CHECKINGAnyCallableHashableIterableLiteralMutableMappingSequenceTypeVaroverloadimport_optional_dependency) is_integer is_list_like) ExcelWriter usecols_func)boundz"MutableMapping[str, ExcelWriter_t]_writers ExcelWriter_tNone)klassreturncCs0t|std|j}t|ts$J|t|<dS)z Add engine to the excel writer registry.io.excel. You must use this method to integrate with ``to_excel``. Parameters ---------- klass : ExcelWriter z&Can only register callables as enginesN)callable ValueErrorZengine isinstancestrr)r engine_namerU/home/ja/django-apps/lartica_env/lib/python3.9/site-packages/pandas/io/excel/_util.pyregister_writer s r readerrzLiteral['reader', 'writer'])extmodercCs`dddddd}dddddd}|dvs,J|dkrTtd d d }|rLd |d <||S||Sd S)a Return the default reader/writer for the given extension. Parameters ---------- ext : str The excel file extension for which to get the default engine. mode : str {'reader', 'writer'} Whether to get the default engine for reading or writing. Either 'reader' or 'writer' Returns ------- str The default engine for the extension. ZopenpyxlZpyxlsbZxlrdZodf)xlsxZxlsmZxlsbZxlsZodsZxlwt)r!writerr% xlsxwriterwarn)errorsr$Nr )r"r#Z_default_readersZ_default_writersr&rrrget_default_engine2s&  r))rrc CsFz t|WSty@}ztd|d|WYd}~n d}~00dS)NzNo Excel writer '')rKeyErrorr)rerrrrr get_writer\s r-int)xrcCsdd}|D]J}t|}|tdks4|tdkrBtd||d|tdd}q|dS)ai Convert Excel column name like 'AB' to 0-based column index. Parameters ---------- x : str The Excel column name to convert to a 0-based column index. Returns ------- num : int The column index corresponding to the name. Raises ------ ValueError Part of the Excel column name was invalid. rAZzInvalid column name: )upperstripordr)r/indexccprrr _excel2numcsr:z list[int])areasrcCs^g}|dD]J}d|vrJ|d}|tt|dt|ddq|t|q|S)a Convert comma separated list of column names and ranges to indices. Parameters ---------- areas : str A string containing a sequence of column ranges (or areas). Returns ------- cols : list A list of 0-based column indices. Examples -------- >>> _range2cols('A:E') [0, 1, 2, 3, 4] >>> _range2cols('A,C,Z:AB') [0, 2, 25, 26, 27] ,:rr3)splitextendranger:append)r;colsrngZrngsrrr _range2colss &rDzstr | list[int])usecolsrcCsdSNrrErrrmaybe_convert_usecolssrHz list[str]cCsdSrFrrGrrrrHscCsdSrFrrGrrrrHscCsdSrFrrGrrrrHsz1str | list[int] | list[str] | usecols_func | Nonez+None | list[int] | list[str] | usecols_funccCs2|dur |St|rtdt|tr.t|S|S)a Convert `usecols` into a compatible format for parsing in `parsers.py`. Parameters ---------- usecols : object The use-columns object to potentially convert. Returns ------- converted : object The compatible format of `usecols`. Nz}Passing an integer for `usecols` is no longer supported. Please pass in a list of int from 0 to `usecols` inclusive instead.)rrrrrDrGrrrrHs ztuple[int, int]z Literal[True]) freeze_panesrcCsdSrFrrIrrrvalidate_freeze_panessrKzLiteral[False]cCsdSrFrrJrrrrKsztuple[int, int] | NoneboolcCs6|dur2t|dkr*tdd|Dr*dStddS)Ncss|]}t|tVqdSrF)rr.).0itemrrr sz(validate_freeze_panes..TzLfreeze_panes must be of form (row, column) where row and column are integersF)lenallrrJrrrrKszlist[Hashable]z list[bool]z!tuple[list[Hashable], list[bool]])row control_rowrcCsf|d}tdt|D]F}||s*||}||dksB||durL|||<qd||<||}q||fS)a Forward fill blank entries in row but only inside the same parent index. Used for creating headers in Multiindex. Parameters ---------- row : list List of items in a single row. control_row : list of bool Helps to determine if particular column is in same parent index as the previous value. Used to stop propagation of empty cells between different indexes. Returns ------- Returns changed row and control_row rr3NF)r@rQ)rSrTlastirrrfill_mi_headers  rXzint | Sequence[int]z&tuple[Hashable | None, list[Hashable]])rS index_colrcCspt|r t|tsJt|}nt|tr.J|}||}|dkrFdn|}||d|dg||ddfS)a Pop the header name for MultiIndex parsing. Parameters ---------- row : list The data row to parse for the header name. index_col : int, list The index columns for our data. Assumed to be non-null. Returns ------- header_name : str The extracted header name. trimmed_row : list The original data row with the header name removed. rUNr3)rrrmax)rSrYrW header_namerrrpop_header_names r\zdict[str, Any] | Nonedict) engine_kwargskwargsrcCs$|duri}n|}|||S)a Used to combine two sources of kwargs for the backend engine. Use of kwargs is deprecated, this function is solely for use in 1.3 and should be removed in 1.4/2.0. Also _base.ExcelWriter.__new__ ensures either engine_kwargs or kwargs must be None or empty respectively. Parameters ---------- engine_kwargs: dict kwargs to be passed through to the engine. kwargs: dict kwargs to be psased through to the engine (deprecated) Returns ------- engine_kwargs combined with kwargs N)copyupdate)r^r_resultrrrcombine_kwargs7s  rcN)r!)$ __future__rtypingrrrrrrr r r r Zpandas.compat._optionalrZpandas.core.dtypes.commonrrZpandas.io.excel._basertyperobjectrr__annotations__r r)r-r:rDrHrKrXr\rcrrrrs<0   * !#"