cMhUddlmZddlmZmZmZmZddlmZm Z m Z m Z m Z m Z ddlmZddlmZmZer$ddlmZeeZe de egefZiZd 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)HashableIterableMutableMappingSequence) TYPE_CHECKINGAnyCallableLiteralTypeVaroverloadimport_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 U/var/www/html/test/jupyter/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^Cr! list[str]cdSr[r\r]s rr^r^r_r!cdSr[r\r]s rr^r^r_r!cdSr[r\r]s rr^r^r_r!1str | list[int] | list[str] | usecols_func | None+None | list[int] | list[str] | usecols_funcc||St|rtdt|trt |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$rWr]s rr^r^s] '  R   '3$7### Nr! freeze_panestuple[int, int] Literal[True]cdSr[r\rhs rvalidate_freeze_panesrmr_r!Literal[False]cdSr[r\rls rrmrmr_r!tuple[int, int] | Noneboolc|=t|dkrtd|DrdStddS)Nc3@K|]}t|tVdSr[)rgr>).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|}||d|dgz||dzdzfS)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 BQB2$QUWW5 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_kwargsr6s9&##%% 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.abcrrrrtypingrr 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        >    "    F6666Dr!