Mh%SSKJr SSKJrJrJrJr SSKJrJ r J r J r J r J r SSKJr SSKJrJr \(aSSKJr \\r\ "S\ \/\4S9r0rS \S 'SS jrSSS jjrSS jrS SjrS!Sjr\ S"Sj5r \ S#Sj5r \ S$Sj5r \ S%Sj5r S&Sjr \ S'Sj5r!\ S(Sj5r!S)Sjr!S*Sjr"S+Sjr#S,Sjr$g)-) annotations)HashableIterableMutableMappingSequence) TYPE_CHECKINGAnyCallableLiteralTypeVaroverloadimport_optional_dependency) is_integer is_list_like) ExcelWriter usecols_func)boundz"MutableMapping[str, ExcelWriter_t]_writerscd[U5(d [S5eURnU[U'g)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)klass engine_names G/var/www/html/env/lib/python3.13/site-packages/pandas/io/excel/_util.pyregister_writerr"s, E??ABB--K!H[cxSSSSSS.nSSSSS.nUS;deUS:Xa[S S S 9nU(aS US 'X0$X $) 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&r()readerwriterr* xlsxwriterwarn)errorsr$r)extmode_default_readers_default_writersr+s rget_default_enginer22sv$   ' '' ' x/ VL '3 V $$$$$rcZ[U$![an[SUS35UeSnAff=f)NzNo Excel writer '')rKeyErrorr)rerrs r get_writerr7[s<F $$ F,[M;<#EFs *%*cSnUR5R5HQn[U5nU[S5:dU[S5:a[SU35eUS-U-[S5- S-nMS US- $)a1 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)xindexccps r _excel2numrDbsx& E WWY__  V C=BSM4QC89 9 R#c(*Q.  19rc  /nURS5HlnSU;aIURS5nUR[[US5[US5S-55 MRUR [U55 Mn U$)aT 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] ,:rr<)splitextendrangerDappend)areascolsrngrngss r _range2colsrPsq*D{{3 #:99S>D KKja1:d1g3F3JK L KK 3 (   KrcgNusecolss rmaybe_convert_usecolsrVrcgrRrSrTs rrVrVrWrcgrRrSrTs rrVrVrWrcgrRrSrTs rrVrVrWrcUcU$[U5(a [S5e[U[5(a [ U5$U$)z 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`. z}Passing an integer for `usecols` is no longer supported. Please pass in a list of int from 0 to `usecols` inclusive instead.)rr isinstancestrrPrTs rrVrVsK ' R  '37## NrcgrRrS freeze_paness rvalidate_freeze_panesrarWrcgrRrSr_s rrararWrcnUb2[U5S:Xa[SU55(ag[S5eg)Nc3B# UHn[U[5v M g7frR)r\int).0items r (validate_freeze_panes..s* .:dJtS ! !lsTzLfreeze_panes must be of form (row, column) where row and column are integersF)lenallrr_s rrarasJ |  !c* .:* ' '  0   rcUSn[S[U55H+nX(dXnXS:XdXcX U'M#SX'XnM- X4$)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 rr<F)rJrk)row control_rowlastis rfill_mi_headerrss]* q6D 1c#h ~6D 6R<36>F"KN6D   rc[U5(a#[U[5(de[U5nO[U[5(aeUnXnUS:XaSOUnX0SUS/-XS-S-4$)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. rnNr<)rr\rmax)ro index_colrr header_names rpop_header_namerxsz*I)X....  Ni2222 &K%+$K BQ2$UW5 55rcTUc0nOUR5nURU5 U$)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) engine_kwargskwargsresults rcombine_kwargsr6s.&##% MM& MrN)r ExcelWriter_treturnNone)r))r.r]r/zLiteral['reader', 'writer']rr])rr]rr)r@r]rrf)rLr]r list[int])rUzstr | list[int]rr)rU list[str]rr)rUrrr)rUrrr)rUz1str | list[int] | list[str] | usecols_func | Nonerz+None | list[int] | list[str] | usecols_func)r`ztuple[int, int]rz Literal[True])r`rrzLiteral[False])r`ztuple[int, int] | Nonerbool)rolist[Hashable]rpz list[bool]rz!tuple[list[Hashable], list[bool]])rorrvzint | Sequence[int]rz&tuple[Hashable | None, list[Hashable]])r|zdict[str, Any] | Noner}dictrr)% __future__rcollections.abcrrrrtypingrr r r r r pandas.compat._optionalrpandas.core.dtypes.commonrrpandas.io.excel._basertyperobjectrr__annotations__rr2r7rDrPrVrarsrxrrSrrrsK" ? 1%M>8*f:L1MNL/1 ,1 " &%RF@B         >0>    "   &0 & F6 6$76+6Dr