a Of@sUddlmZddlmZmZmZmZddlmZm Z m Z m Z m Z m Z ddlmZddlmZmZerddlmZeeZe de egefdZiZd ed <d d d ddZdGddddddZdd dddZdddddZddddd Ze d!dd"d#d$Z e d%d%d"d&d$Z e ddd"d'd$Z e d d d"d(d$Z d)d*d"d+d$Z e d,d-d.d/d0Z!e d d1d.d2d0Z!d3d4d.d5d0Z!d6d7d8d9d:d;Z"d6dd?d@Z#dAdBdBdCdDdEZ$dFS)H) annotations)HashableIterableMutableMappingSequence) TYPE_CHECKINGAnyCallableLiteralTypeVaroverloadimport_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_namerN/var/www/ai-form-bot/venv/lib/python3.9/site-packages/pandas/io/excel/_util.pyregister_writer"s rreaderstrzLiteral['reader', 'writer'])extmodercCs^dddddd}ddddd}|dvs*J|dkrRtd d d }|rJd |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)xlsxxlsmxlsbZxlsods)r#r$r%r&)rwriterr' 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)r1indexccprrr _excel2numbsr<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] ,:rr5)splitextendranger<append)r=colsrngZrngsrrr _range2colss &rFzstr | list[int])usecolsrcCsdSNrrGrrrmaybe_convert_usecolssrJz list[str]cCsdSrHrrIrrrrJscCsdSrHrrIrrrrJscCsdSrHrrIrrrrJsz1str | 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.)rr isinstancer rFrIrrrrJs ztuple[int, int]z Literal[True]) freeze_panesrcCsdSrHrrLrrrvalidate_freeze_panessrNzLiteral[False]cCsdSrHrrMrrrrNsztuple[int, int] | NoneboolcCs6|dur2t|dkr*tdd|Dr*dStddS)Ncss|]}t|tVqdSrH)rKr0).0itemrrr sz(validate_freeze_panes..TzLfreeze_panes must be of form (row, column) where row and column are integersF)lenallrrMrrrrNszlist[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 rr5NF)rBrT)rVrWlastirrrfill_mi_headers  r[zint | Sequence[int]z&tuple[Hashable | None, list[Hashable]])rV 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. rXNr5)rrKrmax)rVr\rZ 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)rarbresultrrrcombine_kwargs6s  rfN)r)% __future__rcollections.abcrrrrtypingrrr r r r Zpandas.compat._optionalrZpandas.core.dtypes.commonrrZpandas.io.excel._basertyperobjectrr__annotations__rr+r/r<rFrJrNr[r_rfrrrrs>   ) !#"