ttjUddlmZddlmZmZmZmZmZddlm Z m Z m Z m Z m Z ddlmZddlmZmZe r$ddlmZeeZe deegefZiZd ed <dAdZdBdCdZdDdZdEdZdFdZe dGd Z e dHd"Z e dId#Z e dJd$Z dKd'Z e dLd+Z!e dMd-Z!dNd0Z!dOd6Z"dPd:Z#dQd?Z$d@S)R) annotations)CallableHashableIterableMutableMappingSequence) TYPE_CHECKINGAnyLiteralTypeVaroverloadimport_optional_dependency) is_integer is_list_like) ExcelWriter usecols_func)boundz"MutableMapping[str, ExcelWriter_t]_writersklass ExcelWriter_treturnNonecdt|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 ValueError_enginer)r engine_names S/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/pandas/io/excel/_util.pyregister_writerr "s9 E??CABBB-K!H[readerextstrmodeLiteral['reader', 'writer']cdddddd}ddddd}|dvsJ|dkr td d }|rd |d <||S||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. openpyxlpyxlsbxlrdodf)xlsxxlsmxlsbxlsods)r,r-r.r0)r"writerr1 xlsxwriterwarn)errorsr,r)r#r%_default_readers_default_writersr2s rget_default_enginer72s$   ' ' ' ' ' x/ VLLL  4'3 V $$$$$r!rcj t|S#t$r}td|d|d}~wwxYw)NzNo Excel writer '')rKeyErrorr)rerrs r get_writerr<[sRF $$ FFF;[;;;<<#EFs  2-2xintc&d}|D]d}t|}|tdks|tdkrtd||dz|ztdz dz}e|dz S)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=indexccps r _excel2numrJbs& E WWYY__  // VV C==BSMM8Q8899 9 R#c((*Q. 19r!areas list[int]c Jg}|dD]}d|vrb|d}|tt|dt|ddzh|t||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] ,:rrC)splitextendrangerJappend)rKcolsrngrngss r _range2colsrWs*D{{3)) #::99S>>D KKja11:d1g3F3F3JKK L L L L KK 3 ( ( ( ( Kr!usecolsstr | list[int]cdSNrXs rmaybe_convert_usecolsr^BE#r! list[str]cdSr[r\r]s rr^r^s).0items r z(validate_freeze_panes..s=* * &*JtS ! !* * * * * * r!TzLfreeze_panes must be of form (row, column) where row and column are integersF)lenallrrls rrmrmsk |   ! !c* * .:* * * ' ' !4 0    5r!rowlist[Hashable] control_row list[bool]!tuple[list[Hashable], list[bool]]c|d}tdt|D]9}||s||}||dks|||||<,d||<||}:||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 rrCNF)rRrx)rzr|lastis rfill_mi_headerrs* q6D 1c#hh  1~ q6D q6R<<3q6>CFF"KNq6DD  r! index_colint | Sequence[int]&tuple[Hashable | None, list[Hashable]]ct|r't|tsJt|}nt|trJ|}||}|dkrdn|}|g|d|d||dzdfS)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. rNrC)rrgrmax)rzrr header_names rpop_header_namers*I)X.....  NNi22222 a&K%++$$K 5#bqb'525AEGG 5 55r! engine_kwargsdict[str, Any] | Nonekwargsdictcb|i}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 )copyupdate)rrresults rcombine_kwargsr0s9&##%% MM& Mr!N)rrrr)r")r#r$r%r&rr$)rr$rr)r=r$rr>)rKr$rrL)rXrYrrL)rXr`rr`)rXrrr)rXrrr)rXrdrre)rhrirrj)rhrrrn)rhrprrq)rzr{r|r}rr~)rzr{rrrr)rrrrrr)% __future__rcollections.abcrrrrrtypingr r r r r pandas.compat._optionalrpandas.core.dtypes.commonrrpandas.io.excel._basertyperobjectrr__annotations__r r7r<rJrWr^rmrrrr\r!rrs"""""""?>>>>> O111111%M7>8*f:L1MNNNL/11111 " " " " &%&%&%&%&%RFFFF@B EEE E ??? ? EEE E 555 5> NNN N DDD D"    F6666Dr!