MhSrSSKJr SSKJrJrJrJr SSKrSSK r SSK r SSK J r J r JrJr SSKrSSKrSSKJr SSKJr SSKJr SS KJr SS KJrJr SS KJrJ r J!r!J"r" SSK#J$s J%r& SS K'J(r( SS K)J*r* SSK+J,r,J-r- SSK.J/r/ SSK0J1r1 \ (aSSK2J3r3J4r4J5r5J6r6 SSKJ7r7 "SS5r8"SS\85r9"SS5r:"SS5r;g)zC Utilities for conversion to writer-agnostic Excel representation. ) annotations)HashableIterableMappingSequenceN) TYPE_CHECKINGAnyCallablecast) is_list_like)doc)find_stack_level)missing)is_float is_scalar) DataFrameIndex MultiIndex PeriodIndex) _shared_docs) CSS4_COLORS) CSSResolver CSSWarning)get_level_lengths) pprint_thing)FilePath IndexLabelStorageOptionsWriteExcelBuffer ExcelWritercB\rSrSrSr\rSSSjjrSrg) ExcelCell?rowcolvalstyle mergestartmergeendNcLXlX lX0lX@lXPlX`lgNr%)selfr&r'r(r)r*r+s I/var/www/html/env/lib/python3.13/site-packages/pandas/io/formats/excel.py__init__ExcelCell.__init__Cs" $ )r'r+r*r&r)r()NNN) r&intr'r3r* int | Noner+r4returnNone)__name__ __module__ __qualname____firstlineno__ __fields__ __slots__r0__static_attributes__r2r/r#r#?sQIJI!%#! !!  !! !!r2r#cL^\rSrSrSU4SjjrSrU=r$) CssExcelCellTc  >U(aQU(aJXVU4V Vs0sHupU R5U_M n n n[U R55n U"U 5n[T U]"SXWUS.U D6 gs snn f)Nr&r'r(r)r>)lower frozensetitemssuperr0)r.r&r'r(r) css_stylescss_rowcss_col css_converterkwargspropdeclaration_dictunique_declarations __class__s r/r0CssExcelCell.__init__Us~ -4>w>N3O 3Oid c!3O  #,,<,B,B,D"E !"56E JSs%J6J sA/r>)r&r3r'r3r) dict | NonerHz3dict[tuple[int, int], list[tuple[str, Any]]] | NonerIr3rJr3rKCallable | Noner5r6)r7r8r9r:r0r= __classcell__)rPs@r/r@r@TsfK KK  K H KKK'K KKr2r@c\rSrSr%Sr\rSSSSSSS.rSSSSSSSSSSSSSS . rSSSS .r S S S SS.r SVVs0sHnUR5U_M snnr S\ S'S0S1Sjjr\"5rS2SjrS2SjrS3SjrS4SjrS5SjrS6SjrS7SjrS8SjrS9SjrS:SjrS;SjrSS"jrS6S#jrS6S$jr S?S%jr!S@S&jr"S6S'jr#S?S(jr$SAS)jr%SBS*jr&SCS+jr'SDS,jr(SES-jr)SDS.jr*S/r+gs snnf)FCSSToExcelConverterma A callable for converting CSS declarations to ExcelWriter styles Supports parts of CSS 2.2, with minimal CSS 3.0 support (e.g. text-shadow), focusing on font styling, backgrounds, borders and alignment. Operates by first computing CSS styles in a fairly generic way (see :meth:`compute_css`) then determining Excel style properties from CSS properties (see :meth:`build_xlstyle`). Parameters ---------- inherited : str, optional CSS declarations understood to be the containing scope for the CSS processed by :meth:`__call__`. topcenterbottom)rXztext-topmiddlebaselinerZz text-bottomTF) boldbolder600700800900normallighter100200300400500)rcitalicoblique)serifz sans-serifcursivefantasy) dashed mediumDashDot dashDotDothairdottedmediumDashDotDotdoubledashDot slantDashDot mediumDashedzdict[str, str] | None inheritedNcUbURU5UlOSUl[R"UR5Ulgr-) compute_cssr} functoolscache_call_uncached _call_cached)r.r}s r/r0CSSToExcelConverter.__init__s:  !--i8DN!DN&OOD,?,?@r2c$URU5$)a} Convert CSS declarations to ExcelWriter style. Parameters ---------- declarations : str | frozenset[tuple[str, str]] CSS string or set of CSS declaration tuples. e.g. "font-weight: bold; background: blue" or {("font-weight", "bold"), ("background", "blue")} Returns ------- xlstyle : dict A style as interpreted by ExcelWriter when found in ExcelCell.style. )r)r. declarationss r/__call__CSSToExcelConverter.__call__s&  ..r2cZURXR5nURU5$r-)rr} build_xlstyle)r.r propertiess r/r"CSSToExcelConverter._call_uncacheds)%%lNNC !!*--r2c^URU5URU5URU5URU5UR U5S.nSU4SjjmT"U5 U$)N) alignmentborderfillfont number_formatc>[UR55H6upUcX M [U[5(dM#T"U5 U(aM4X M8 g)z4Remove key where value is None, through nested dictsN)listrF isinstancedict)dkv remove_nones r/r6CSSToExcelConverter.build_xlstyle..remove_nonesAQWWY94((N1D (r2)rdict[str, str | None]r5r6)build_alignment build_border build_fill build_fontbuild_number_format)r.propsoutrs @r/r!CSSToExcelConverter.build_xlstyles`--e4''.OOE*OOE*!55e<   ! C r2chURS5URU5URU5S.$)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr.rs r/r#CSSToExcelConverter.build_alignments6 ))L144U;//6  r2cjURS5nU(aURRU5$g)Nzvertical-align)r VERTICAL_MAP)r.rvertical_aligns r/r+CSSToExcelConverter._get_vertical_alignments.#34 $$((8 8r2cJURS5cg[USS;5$)Nz white-space)nowrapprezpre-line)rboolrs r/r%CSSToExcelConverter._get_is_wrap_text s* 99] # +E-(0MMNNr2c0SVs0sHnUURURSUS35URSUS35URURSUS3555URURSUS355S._M sn$s snf)NrXrightrZleftzborder-z-stylez-widthz-color)r)color) _border_stylercolor_to_excel)r.rsides r/r CSSToExcelConverter.build_borders;  ; ++IIvV45IIvV45'' GD62H(IJ ,,UYYf7M-NO  ;   sB BcLUcUcUcgUcUcgUS;agURU5nUcgUS;aU$US:XagUS:XaUS;aggUS:XaUS;agg XR;aURU$[R"S [ U53[ [ 5S 9 g) Nnone)rhidden)Ngrooveridgeinsetoutsetsolidryrw)rvthinrxrsr|zUnhandled border style format:  stacklevel)_get_width_nameBORDER_STYLE_MAPwarningswarnreprrr)r.r)widthr width_names r/r!CSSToExcelConverter._border_styles =U]u} =U] & &))%0   I I  H  H --% H --! ++ +((/ / MM1$u+?+-  r2cPURU5nUS:agUS:agUS:agg)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r. width_inputrs r/r#CSSToExcelConverter._get_width_nameVs3$$[1 4< S[ S[r2c.UcSnURU5$)N2pt) _pt_to_float)r.rs r/r#CSSToExcelConverter._width_to_float`s =E  ''r2cfURS5(de[URS55$)Npt)endswithfloatrstrip)r. pt_strings r/r CSSToExcelConverter._pt_to_floates/!!$''''Y%%d+,,r2cZURS5nUS;aURU5SS.$g)Nzbackground-color)N transparentrr)fgColor patternType)rr)r.r fill_colors r/rCSSToExcelConverter.build_fillis7YY12 : :#22:>wW W ;r2c~URS5n[U[5(aURSS5OUnSU0$)Nz number-format§; format_code)rrstrreplace)r.rfcs r/r'CSSToExcelConverter.build_number_formatps9 YY '&0S&9&9RZZc "rr""r2c pURU5nURU5nU(aUSOSURU5URU5UR U5UR U5SU;aSOSSU;=(d SUR URS55URU5S. $)Nr underlinesinglez line-throughr) namefamilysizer]rjrstrikershadow) _get_font_names_get_decoration_select_font_family_get_font_size _get_is_bold_get_is_italicrr _get_shadow)r.r font_names decorations r/rCSSToExcelConverter.build_fontus))%0 ))%0 %/JqMT..z:''.%%e,))%0&1Z&?(T%3<((7);<&&u-  r2cjURS5nU(aURRU5$g)Nz font-weight)rBOLD_MAP)r.rweights r/r CSSToExcelConverter._get_is_bolds+=) ==$$V, ,r2cjURS5nU(aURRU5$g)Nz font-style)r ITALIC_MAP)r.r font_styles r/r"CSSToExcelConverter._get_is_italics+YY|, ??&&z2 2r2cLURS5nUbUR5$g)Nztext-decorationr>)rsplit)r.rrs r/r#CSSToExcelConverter._get_decorations)YY01  !##% %r2cSU;agg)Nrrr>)r.rs r/_get_underline"CSSToExcelConverter._get_underlines * $r2cVSU;a#[[R"SUS55$g)Nz text-shadowz ^[^#(]*[1-9])rresearchrs r/rCSSToExcelConverter._get_shadows( E ! .% 2FGH Hr2c:[R"SURSS55n/nUHknUSSS:XaUSSRSS5nO/USSS:XaUSSRS S5nOUR 5nU(dMZUR U5 Mm U$) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyrl"z\"'z\')rfindallrrstripappend)r.rfont_names_tmprrs r/r#CSSToExcelConverter._get_font_namess  IImR (   "DBQx3Abz))%5bqSAbz))%5zz|t!!$'#r2cPURS5nUcU$URU5$)Nz font-size)rr)r.rrs r/r"CSSToExcelConverter._get_font_sizes+yy% <K  &&r2cfSnUH(nURRU5nU(dM' U$ U$r-) FAMILY_MAPr)r.rrrs r/r'CSSToExcelConverter._select_font_familys9D__((.Fv   r2cUcgURU5(aURU5$URU$![a1 [R "S[ U53[[5S9 gf=f)NzUnhandled color format: r) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorrrrrrr.r(s r/r"CSSToExcelConverter.color_to_excelsy ;   c " "--c2 2 $$S) )  MM*49+6+-    s<8A76A7c6[URS55$)N#)r startswith)r. color_strings r/r&!CSSToExcelConverter._is_hex_colorsL++C011r2cURS5nURU5(a(USS-USS--USS--R5$UR5$)Nr-rrmrl)lstrip_is_shorthand_colorupperr.r/codes r/r')CSSToExcelConverter._convert_hex_to_excels`""3'  # #L 1 1GaK$q'A+-Q! ;BBD D::< r2cURS5n[U5S:Xag[U5S:Xag[SU35e)zSCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. r-TFzUnexpected color )r2len ValueErrorr5s r/r3'CSSToExcelConverter._is_shorthand_colorsC ""3' t9> Y!^0?@ @r2)rr}r-)r} str | Noner5r6)rz str | frozenset[tuple[str, str]]r5dict[str, dict[str, str]])rMapping[str, str]r5r?)rr@r5zdict[str, bool | str | None])rr@r5r>)rr@r5z bool | None)rr@r5z dict[str, dict[str, str | None]])r)r>rr>rr>)rr>r5r>)rr>r5r)rrr5r)rr@)rr@r5r)rr@r5z$dict[str, bool | float | str | None])rr@r5 Sequence[str])rrAr5r>)rr@r5z float | None)rrAr5r4)r(r>r5r>)r/rr5r)r/rr5r),r7r8r9r:__doc__rr(rrr r#rDr__annotations__r0rrrrrrrrrrrrrrrrrrrrrrrrrr&r'r3r=).0r)s00r/rVrVms"L LH"J J    E  u  (%$A-K/</ "/*.<. ". 0  O  &  )  5n( -X#  & - $    4' "2  AA sC>rVc:\rSrSrSrSrSrSSSjjr\SSj5r Sr SS jr SS jr SS jr SS jrSS jrSSjr\SSj5rSSjrSSjr\"\SS9SSSjj5rSrg)ExcelFormatteria Class for formatting a DataFrame to a list of ExcelCells, Parameters ---------- df : DataFrame or Styler na_rep: na representation float_format : str, default None Format string for floating point numbers cols : sequence, optional Columns to write header : bool or sequence of str, default True Write out column names. If a list of string is given it is assumed to be aliases for the column names index : bool, default True output row names (index) index_label : str or sequence, default None Column label for index column(s) if desired. If None is given, and `header` and `index` are True, then the index names are used. A sequence should be given if the DataFrame uses MultiIndex. merge_cells : bool, default False Format MultiIndex and Hierarchical Rows as merged cells. inf_rep : str, default `'inf'` representation for np.inf values (which aren't representable in Excel) A `'-'` sign will be added in front of -inf. style_converter : callable, optional This translates Styler styles (CSS) into ExcelWriter styles. Defaults to ``CSSToExcelConverter()``. It should have signature css_declarations string -> excel style. This is only called for body cells. ii@Nc SUlX l[U[5(d@XlURR 5 UR nU c [5n XlOSUlSUlXl Ub[[U5RUR55(d [S5e[[U5RUR55[[U55:wa [S5eUR!US9Ul URRUl X0lX`lXplXPlXlXlg)Nrz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columns) rowcounterna_reprrstyler_computedatarVstyle_converterdfr;r intersectionrHr)setreindex float_formatindex index_labelheader merge_cellsinf_rep) r.rOrJrScolsrVrTrUrWrXrNs r/r0ExcelFormatter.__init__s  "i((K KK "B&"5"74C DK#'D   uT{// ;<<MNN5;++BJJ78CD NJOPPjjj.DGww ( & & r2c"SS0SSSSS.SSS.S.$) Nr]TrrrYrX)rr)rbordersrr>r.s r/ header_styleExcelFormatter.header_styleGs0TN   )1eD  r2c[U5(a([R"U5(a URnO[ U5(ax[R "U5(a UR nOP[R"U5(aSUR 3nO%URb[URU-5n[USS5b [S5eU$)N-tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rrisnarJrisposinf_scalarrXisneginf_scalarrSrgetattrr<r*s r/ _format_valueExcelFormatter._format_valueTs S>>gll3//++C c]]&&s++ll((--$,,("".D--34 3$ ' 3@   r2c## URRS:aUR(d [S5eUR(dUR (dgURnUR URSS9n[U5nSnSnUR(aN[URR[5(a%[URRS5S- nUR(a[UR5HupV[UUUUR S9v M [[#X1R$UR&55Hunupxn UR)U 5n UR+5H[upSupU S:aXTU -U -p[-UXK-S-XUR [/UR0SS5UU UR2U US 9 v M] M Oy[[#U65HdupS R5[7[8U 55n[-UXK-S-UUR [/UR0SS5UU UR2S 9v Mf XPlg7f) Nrlz]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.Fsparsify include_namesrrCNN ctx_columns r&r'r(r)rHrIrJrKr*r+.r&r'r(r)rHrIrJrK)rHnlevelsrTNotImplementedError _has_aliasesrV _format_multirWrrrOrr; enumeratenamesr#r^ziplevelscodestakerFr@rfrKrNjoinmaprrI)r.rH level_strs level_lengths coloffsetlnumrspansry level_codesvaluesispan_valr*r+rs r/_format_header_mi ExcelFormatter._format_header_mifs+ <<  ! #::)D !!T[[ ,,**%%U+ **5   ::*TWW]]J??DGGMM!,-1I   ' 6 !++ 77@M>>7==A722uk [1#(;;=KA+5(J!|/3]X5MH& %MA-"I"//#*4;; t#L $ !&*&:&:#-!)   $1 7,'sJ'78 HHSv67"! )++&t{{M4H "&"6"6  9sI,I.c #0# UR(dUR(GaoSnUR(aTSn[URR[ 5(a)[ URRR5nURnUR(a[[UR5Ul[ UR5[ UR5:wa8[S[ UR5S[ UR5S35eURn[U5HLup4[URX1-UUR[!UR"SS5SUUR$S9v MN gg7f)NrrlzWriting z cols but got z aliasesrnrq)rtrVrTrrOrr;rwrHr rr<rvr@rIr^rfrKrN)r.rcolnamescolindexcolnames r/_format_header_regular%ExcelFormatter._format_header_regulars2    Izz dggmmZ88 #DGGMM$7$7 8I||H  "8T[[9 t{{#s4<<'88$"3t||#4"56##&t{{#3"4H> ;;%.x%8!" ,++&t{{M4H$"&"6"6  &9%!,sFFcB^[TR[5(aTR5nOTR 5nSnTR R R(aTR R RVs/sH o3bUOSPM snS/[TR5--n[R"SSU55(a*U4Sj[U55nT=RS- sl [R"X5$s snf)Nr>rcU=(a U$r-r>)xys r//ExcelFormatter._format_header..s QW1Wr2c3*# UH oS:gv M g7f)rNr>)rDrs r/ 0ExcelFormatter._format_header..s6L1Bwsc3j># UH(up[TRXTR5v M* g7fr-)r#rIr^)rDrr(r.s r/rrs0)7 dooxd>O>OPP)7s03rl)rrHrrrrOrTrwr;rreducervrI itertoolschain)r.gengen2rr&s` r/_format_headerExcelFormatter._format_headers dllJ / /((*C--/C$& 77==  7;ww}}7J7JK7J! 12-7JKODLL!O""C 46L6LMM)231$s))Ls Dc[URR[5(aUR 5$UR 5$r-)rrOrTr_format_hierarchical_rows_format_regular_rowsr]s r/ _format_bodyExcelFormatter._format_bodys5 dggmmZ 0 0113 3,,. .r2c ## UR(dUR(aU=RS- slUR(GaUR(aI[ UR[ [[R[45(aURSnO`UR(a,[ UR[5(a URnO#URRRSn[ UR[5(aU=RS- slU(a5URSLa&[!URS- SXR"5v URRn[ URR[$5(a$URRR'5n[)U5HMup4[+URU-SUUR"[-UR.SS5USUR0S9v MO SnOSnUR3U5ShvN gN7f)NrlrF ctx_indexrq)rtrVrIrTrUrrtuplenpndarrayrrrOrwrHrr#r^r to_timestamprvr@rfrKrN_generate_body)r.rU index_valuesidxidxvalrs r/r#ExcelFormatter._format_regular_rowss    OOq O :::J  4 E"B%%#..q1 !!j1A1A3&G&G".. "ggmm11!4 $,, 331$t{{%7! 3Q EVEVWW 77==L$''--55#ww}}99; (6 "#-++&t{{KF"&"6"6   7II&&y111sI IIIc## UR(dUR(aU=RS- slSnUR(GaURRR nUR (aE[UR [[[R[45(a UR n[UR[5(a&UR(aU=RS- sl[ R""U6(aIURSLa:[%U5H+up4['URS- X4UR(5v M- UR(Ga2URRR+SSS9n[-U5n[/X`RRR0URRR25Hupxn UR5U UR6UR8S9n UR;5HrupSupU S:aURU -U -S- n Un[=URU -UXUR([?UR@SS5U UURBU US 9 v Mt US- nM O[/URR6Hen[%U5HNunn[=URU-UUUR([?UR@SS5UUURBS 9v MP US- nMg UREU5ShvN gN7f) NrlrFTrj) allow_fill fill_valuermrrorq)#rtrVrIrTrOrwrUrrrrrrrHrrWcom any_not_nonervr#r^rurrxryrzr{ _can_hold_na _na_valuerFr@rfrKrNr)r.gcolidx index_labelscidxrr~rrryrrrrr*r+ indexcolvalsr indexcolvals r/r(ExcelFormatter._format_hierarchical_rowss    OOq O :::77==..LJ  4 E"B%% $// $,, 338H8H1$.4;;e3K"+L"9JD#DOOa$7TEVEVWW#:!WW]]88!9 !2* = 25!77==#7#79L9L3.E;$[[##)#6#6#)#3#3)F (-{{} /9, #a<)-1)*>'1%-   (5"qLG53<%($7L,5l,C([* $# 5 ' +"&"3"3'.t{{K'N$'$+*.*>*>  -DqLG%8&&w///sMMM Mc,[UR5$)z1Whether the aliases for column names are present.)r rVr]s r/rtExcelFormatter._has_aliasescsDKK((r2c #8# [[UR55HtnURRSS2U4n[ U5HEupE[ URU-X!-US[URSS5UUURS9v MG Mv g7f)Nctxrq) ranger;rHrOilocrvr@rIrfrKrN)r.rcolidxseriesrr(s r/rExcelFormatter._generate_bodyhsC -.FWW\\!V),F#F+"!+*&t{{E4@""&"6"6  ,/sBBc## [R"UR5UR55H'nUR UR 5UlUv M) g7fr-)rrrrrgr()r.cells r/get_formatted_cells"ExcelFormatter.get_formatted_cellsxsHOOD$7$7$94;L;L;NOD))$((3DHJPsA A"storage_options)rc SSKJn URRupXR:dXR :a+[ SU SU SURSUR 35eUc0nUR5n [X5(aSn O U "UUUUS9nS n URU UUUUS 9 U (aUR5 gg!U (aUR5 ff=f) a writer : path-like, file-like, or ExcelWriter object File path or existing ExcelWriter sheet_name : str, default 'Sheet1' Name of sheet which will contain DataFrame startrow : upper left cell row to dump data frame startcol : upper left cell column to dump data frame freeze_panes : tuple of integer (length 2), default None Specifies the one-based bottommost row and rightmost column that is to be frozen engine : string, default None write engine to use if writer is a path - you can also set this via the options ``io.excel.xlsx.writer``, or ``io.excel.xlsm.writer``. {storage_options} engine_kwargs: dict, optional Arbitrary keyword arguments passed to excel engine. rr z-This sheet is too large! Your sheet size is: z, z Max sheet size is: NF)enginer engine_kwargsT)startrowstartcol freeze_panes) pandas.io.excelr!rOshapemax_rowsmax_colsr<rr _write_cellsclose)r.writer sheet_namerrrrrrr!num_rowsnum_colsformatted_cells need_saves r/writeExcelFormatter.write}sD 0!WW]] mm #x--'??zH:V&&*mm_Bt}}oG   M224 f * *I  /+ F I    !!)   y s CC") rHrOrSrVrTrUrXrWrJrIrNrK) rNNTTNFinfN)rJrrSr>rYzSequence[Hashable] | NonerVzSequence[Hashable] | boolrTrrUzIndexLabel | NonerWrrXrrNrSr5r6)r5z dict[str, dict[str, str | bool]])r5Iterable[ExcelCell])r5r)rr3r5r)Sheet1rrNNNN)rz)FilePath | WriteExcelBuffer | ExcelWriterrrrr3rr3rztuple[int, int] | Nonerr>rzStorageOptions | NonerrRr5r6)r7r8r9r:rBrrr0propertyr^rgrrrrrrrtrrr rrr=r>r2r/rFrFs@HH #'*.,0)-!+/++! + ( + * ++'+++)+ +Z    $CJ>*,/ ,2\M0^))   &789#/3!15%)D9DD D  D - DD/D#D D:Dr2rF)r2r/rs#   )'4&  ! 0573#!!*K9K2FAFAR LLr2