U Zj@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_CHECKINGAnyCallableHashableIterableLiteralMutableMappingSequenceTypeVaroverload)import_optional_dependency) is_integer is_list_like) ExcelWriter usecols_func)boundz"MutableMapping[str, ExcelWriter_t]_writers ExcelWriter_tNone)klassreturncCs"t|std|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 ValueErrorZ_enginer)r engine_namerX/var/www/html/TRUCKING_PROJECT/venv/lib/python3.8/site-packages/pandas/io/excel/_util.pyregister_writer s rreaderstrzLiteral[('reader', 'writer')])extmodercCs`dddddd}dddddd}|dks,t|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)rwriterr# xlsxwriterwarn)errorsr"N)AssertionErrorr )r r!Z_default_readersZ_default_writersr$rrrget_default_engine0s&  r()rrc CsDz t|WStk r>}ztd|d|W5d}~XYnXdS)NzNo Excel writer '')rKeyErrorr)rerrrrr get_writerZs 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 _excel2numasr9z list[int])areasrcCs^g}|dD]J}d|krJ|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] ,:rr2)splitextendranger9append)r:colsrngZrngsrrr _range2colss &rCzstr | list[int])usecolsrcCsdSNrrDrrrmaybe_convert_usecolssrGz list[str]cCsdSrErrFrrrrGscCsdSrErrFrrrrGscCsdSrErrFrrrrGsz1str | list[int] | list[str] | usecols_func | Nonez+None | list[int] | list[str] | usecols_funccCs2|dkr |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.)rr isinstancerrCrFrrrrGs ztuple[int, int]z Literal[True]) freeze_panesrcCsdSrErrIrrrvalidate_freeze_panessrKzLiteral[False]cCsdSrErrJrrrrKsztuple[int, int] | NoneboolcCs6|dk r2t|dkr*tdd|Dr*dStddS)Ncss|]}t|tVqdSrE)rHr-).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||dkrL|||<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 rr2NF)r?rQ)rSrTlastirrrfill_mi_headers  rXzint | Sequence[int]z&tuple[Hashable | None, list[Hashable]])rS index_colrcCspt|r t|tstt|}nt|tr.t|}||}|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. rUNr2)rrHrr'max)rSrYrW header_namerrrpop_header_names r\zdict[str, Any] | Nonedict) engine_kwargskwargsrcCs$|dkri}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_kwargs5s  rcN)r)$ __future__rtypingrrrrrrr r r r Zpandas.compat._optionalr Zpandas.core.dtypes.commonrrZpandas.io.excel._basertyperobjectrr__annotations__rr(r,r9rCrGrKrXr\rcrrrrs> 0   * !#"