+ NV-j%Rt^RIHt^RIHtHtHtHtHt^RI t ^RI t ^RI t ^RI H t HtHt^RIt^RIt^RIHt^RIHt^RIHt^RIHtHt^R IHtHtHtH t H!t!^RI"H#uH$t%^R I&H't'^R I(H)t)H*t*^R I+H,t,] 'd^R I-H.t.H/t/H0t0H1t1H2t2^RIH3t3!RR4t4!RR]44t5!RR4t6!RR4t7R#)zC Utilities for conversion to writer-agnostic Excel representation. ) annotations)CallableHashableIterableMappingSequenceN) TYPE_CHECKINGAnycast) is_list_like)find_stack_level)missing)is_float is_scalar) DataFrameIndex MultiIndexPeriod PeriodIndex) CSS4_COLORS) CSSResolver CSSWarning)get_level_lengths)ExcelWriterMergeCellsFilePath IndexLabelStorageOptionsWriteExcelBuffer ExcelWriterc.]tRt^?tRt]tRRRlltRtR#) ExcelCellNc ,V^8dQhRRRRRRRRRR/#) rowintcol mergestart int | NonemergeendreturnNone)formats"h/Volumes/fast/ai/experiments/ui-tars-smoke/.venv/lib/python3.14/site-packages/pandas/io/formats/excel.py __annotate__ExcelCell.__annotate__Cs<!! !!  !! !c NWnW nW0nW@nWPnW`nR#Nr$r&valstyler'r))selfr$r&r5r6r'r)s&&&&&&&r.__init__ExcelCell.__init__Cs" $ r1)r&r)r'r$r6r5r4)NNN)__name__ __module__ __qualname____firstlineno__ __fields__ __slots__r8__static_attributes__r,r1r.r!r!?sIJI!!r1r!c.a]tRt^TtRV3RlltRtV;t#) CssExcelCellc8V^8dQhRRRRRRRRRRR RR R R R /#)r#r$r%r&r6 dict | None css_stylesz3dict[tuple[int, int], list[tuple[str, Any]]] | Nonecss_rowcss_col css_converterCallable | Noner*r+r,)r-s"r.r/CssExcelCell.__annotate__UseKK KK  K H KKK'K Kr1c <V'dVV'dNWVV3,U Uu/uFwrV P4VbK p p p\V P44p V!V 4p\S V`!RRVRVRXRV/V BR#uupp i)r$r&r5r6Nr,)lower frozensetitemssuperr8)r7r$r&r5r6rErFrGrHkwargspropdeclaration_dictunique_declarations __class__s&&&&&&&&&, r.r8CssExcelCell.__init__Us -4>w>N3O 3Oid c!3O  #,,<,B,B,D"E !"56E JSJcJsJ%J6J sA9r,)r:r;r<r=r8r@ __classcell__)rTs@r.rBrBTsKKr1rBc8]tRt^mt$Rt]tRRRRRRRRRRRR/tR R R R R R R R RR RR RRRRRRRRRRRRRR/ tRRRR RR /t R^R^R^R^/t RVUu/uFpVP4VbK upt R] R&RWR!R"llt]!4tR#R$ltR%R&ltR'R(ltR)R*ltR+R,ltR-R.ltR/R0ltR1R2ltR3R4ltR5R6ltR7R8ltR9R:ltR;R<ltR=R>ltR?R@ltRARBlt RCRDlt!RERFlt"RGRHlt#RIRJlt$RKRLlt%RMRNlt&RORPlt'RQRRlt(RSRTlt)RUt*R #uupi)XCSSToExcelConvertera 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__`. topztext-topmiddlecenterbaselinebottomz text-bottomboldTbolder600700800900normalFlighter100200300400500italicobliqueserifz sans-serifcursivefantasyzdict[str, str] | None inheritedNc V^8dQhRRRR/#)r#rp str | Noner*r+r,)r-s"r.r/ CSSToExcelConverter.__annotate__sAA*AAr1c VeVPV4VnMRVn\P!VP4VnR#r3) compute_cssrp functoolscache_call_uncached _call_cached)r7rps&&r.r8CSSToExcelConverter.__init__s:  !--i8DN!DN&OOD,?,?@r1c V^8dQhRRRR/#r# declarationsz str | frozenset[tuple[str, str]]r*dict[str, dict[str, str]]r,)r-s"r.r/rss//</ "/r1c $VPV4#)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. )ry)r7r}s&&r.__call__CSSToExcelConverter.__call__s&  ..r1c V^8dQhRRRR/#r|r,)r-s"r.r/rss..<. ".r1c ZVPWP4pVPV4#r3)rurp build_xlstyle)r7r} propertiess&& r.rx"CSSToExcelConverter._call_uncacheds)%%lNNC !!*--r1c V^8dQhRRRR/#)r#propsMapping[str, str]r*r~r,)r-s"r.r/rss#49Rr1c  aRVPV4RVPV4RVPV4RVPV4RVP V4/pRV3RlloS!V4V#) alignmentborderfillfont number_formatc V^8dQhRRRR/#)r#ddict[str, str | None]r*r+r,)r-s"r.r/7CSSToExcelConverter.build_xlstyle..__annotate__s ! !0 !T !r1c<\VP44F9wrVfWK \V\4'gK%S!V4V'dK7WK; R#)z4Remove key where value is None, through nested dictsN)listrN isinstancedict)rkv remove_nones& r.r6CSSToExcelConverter.build_xlstyle..remove_nonesAQWWY94((N1D (r1)build_alignment build_border build_fill build_fontbuild_number_format)r7routrs&& @r.r!CSSToExcelConverter.build_xlstyleso --e4 d''. DOOE* DOOE* T55e<   ! ! C r1c V^8dQhRRRR/#)r#rrr*zdict[str, bool | str | None]r,)r-s"r.r/rss  %6 ;W r1c lRVPR4RVPV4RVPV4/#) horizontalz text-alignvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr7rs&&r.r#CSSToExcelConverter.build_alignments< %))L1 44U; //6  r1c V^8dQhRRRR/#)r#rrr*rrr,)r-s"r.r/rss->:r1c nVPR4pV'dVPPV4#R#)zvertical-alignN)r VERTICAL_MAP)r7rvertical_aligns&& r.r+CSSToExcelConverter._get_vertical_alignments.#34 $$((8 8r1c V^8dQhRRRR/#r#rrr*z bool | Noner,)r-s"r.r/rs sOO'8O[Or1c VVPR4fR#\VR,R94#)z white-spaceN)nowrapprezpre-line)rboolrs&&r.r%CSSToExcelConverter._get_is_wrap_text s* 99] # +E-(0MMNNr1c V^8dQhRRRR/#)r#rrr*z dict[str, dict[str, str | None]]r,)r-s"r.r/rss   &  )  r1c 0RUu/uFpVRVPVPRV R24VPRV R24VPVPRV R2444RVPVPRV R244/bK up#uupi)rYr6zborder-z-stylez-widthz-colorcolor)rYrightr]left) _border_stylercolor_to_excel)r7rsides&& r.r CSSToExcelConverter.build_borders;  ; ++IIvV45IIvV45'' GD62H(IJ ,,UYYf7M-NO  ;   sB Bc(V^8dQhRRRRRRRR/#)r#r6rrwidthrr*r,)r-s"r.r/rss,777(27;E7 7r1c jVf Vf VfR#R#VR 9dR#VPV4pVfR#VR 9dV#VR8XdR#VR8Xd VR 9dR#R#VR8Xd VR 9dR#R#WP9dVPV,#\P!RV: 2\\ 4R7R#) NnonedoubledottedmediumDashDotDotdashed mediumDashedzUnhandled border style format:  stacklevel)rhidden)Ngrooveridgeinsetoutsetsolid)hairthin)_get_width_nameBORDER_STYLE_MAPwarningswarnrr )r7r6rr width_names&&&& r.r!CSSToExcelConverter._border_styles" =U]} & &))%0   I I  H  H --% H --! ++ +((/ / MM1%;+-  r1c V^8dQhRRRR/#)r# width_inputrrr*r,)r-s"r.r/rsXs:*r1c ^VPV4pVR8dR#VR8dR#VR8dR#R#)gh㈵>Ng?rgffffff@mediumthick)_width_to_float)r7rrs&& r.r#CSSToExcelConverter._get_width_nameXs3$$[1 4< S[ S[r1c V^8dQhRRRR/#)r#rrrr*floatr,)r-s"r.r/rsbs((Z(E(r1c 0VfRpVPV4#)N2pt) _pt_to_float)r7rs&&r.r#CSSToExcelConverter._width_to_floatbs =E  ''r1c V^8dQhRRRR/#)r# pt_stringstrr*rr,)r-s"r.r/rsgs--c-e-r1c hVPR4'gQh\VPR44#)pt)endswithrrstrip)r7rs&&r.r CSSToExcelConverter._pt_to_floatgs/!!$''''Y%%d+,,r1cV^8dQhRR/#)r#rrr,)r-s"r.r/rsksXX 1Xr1c `VPR4pVR9dRVPV4RR/#R#)zbackground-colorNfgColor patternTyper)N transparentr)rr)r7r fill_colors&& r.rCSSToExcelConverter.build_fillks;YY12 : :t22:> wW W ;r1c V^8dQhRRRR/#)r#rrr*rr,)r-s"r.r/rsrs##):#?T#r1c VPR4p\V\4'dVPRR4MTpRV/#)z number-format§; format_code)rrrreplace)r7rfcs&& r.r'CSSToExcelConverter.build_number_formatrs9 YY '&0S&9&9RZZc "rr""r1c V^8dQhRRRR/#)r#rrr*z$dict[str, bool | float | str | None]r,)r-s"r.r/rsws  & - r1c VPV4pVPV4pRV'd V^,MRRVPV4RVPV4RVP V4RVP V4RRV9dRMRRR V9;'gRR VP VPR 44R VPV4/ #) nameNfamilysizer^rk underlinesinglestrikez line-throughrshadow) _get_font_names_get_decoration_select_font_family_get_font_size _get_is_bold_get_is_italicrr _get_shadow)r7r font_names decorations&& r.rCSSToExcelConverter.build_fontws))%0 ))%0 ZJqMT d..z: D''. D%%e, d))%0 kZ&?(T ~3<< T((7);< d&&u-  r1c V^8dQhRRRR/#rr,)r-s"r.r/rss"3 r1c nVPR4pV'dVPPV4#R#)z font-weightN)rBOLD_MAP)r7rweights&& r.r  CSSToExcelConverter._get_is_bolds+=) ==$$V, ,r1c V^8dQhRRRR/#rr,)r-s"r.r/rss$5+r1c nVPR4pV'dVPPV4#R#)z font-styleN)r ITALIC_MAP)r7r font_styles&& r.r "CSSToExcelConverter._get_is_italics+YY|, ??&&z2 2r1c V^8dQhRRRR/#r#rrr* Sequence[str]r,)r-s"r.r/rss%6=r1c PVPR4pVeVP4#R#)ztext-decorationr,)rsplit)r7rrs&& r.r #CSSToExcelConverter._get_decorations+YY01  !##% %Ir1c V^8dQhRRRR/#rr,)r-s"r.r/rss!2{r1c bRV9d(\\P!RVR,44#R#)z text-shadowz ^[^#(]*[1-9]N)rresearchrs&&r.rCSSToExcelConverter._get_shadows( E ! .% 2FGH Hr1c V^8dQhRRRR/#rr,)r-s"r.r/rss%6=r1c P\P!RVPRR44p.pVFvpVR,R8XdV^RPRR4pM4VR,R8XdV^RPRR4pMVP 4pV'gKeVP V4Kx V#) z(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-family:NN"z\"'z\')r$findallrrstripappend)r7rfont_names_tmprrs&& r.r#CSSToExcelConverter._get_font_namess  IImR (   "DBx3Abz))%5bSAbz))%5zz|t!!$'#r1c V^8dQhRRRR/#)r#rrr*z float | Noner,)r-s"r.r/rss''$5','r1c RVPR4pVfV#VPV4#)z font-size)rr)r7rrs&& r.r "CSSToExcelConverter._get_font_sizes+yy% <K  &&r1c V^8dQhRRRR/#)r#rrr*r(r,)r-s"r.r/rssm r1c hRpVF)pVPPV4pV'gK(V# V#r3) FAMILY_MAPr)r7rrrs&& r.r 'CSSToExcelConverter._select_font_familys9D__((.Fv   r1c V^8dQhRRRR/#)r#r5rrr*r,)r-s"r.r/rss*r1c VfR#VPV4'dVPV4#VPV,# \d.\P !RT: 2\ \4R7R#i;i)NzUnhandled color format: r) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorrrrr r7r5s&&r.r"CSSToExcelConverter.color_to_excelsu ;   c " "--c2 2 $$S) )  MM*3'2+-    sA4A;:A;c V^8dQhRRRR/#r# color_stringrr*rr,)r-s"r.r/rss22#2$2r1c 6\VPR44##)r startswith)r7rDs&&r.r<!CSSToExcelConverter._is_hex_colorsL++C011r1c V^8dQhRRRR/#)r#rDrr*r,)r-s"r.r/rss  # # r1c VPR4pVPV4'dIV^,^,V^,^,,V^,^,,P4#VP4#rF)lstrip_is_shorthand_colorupperr7rDcodes&& r.r=)CSSToExcelConverter._convert_hex_to_excels`""3'  # #L 1 1GaK$q'A+-Q! ;BBD D::< r1c V^8dQhRRRR/#rCr,)r-s"r.r/rss A A A Ar1c VPR4p\V4^8XdR#\V4^8XdR#\RV 24h)zSCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. rGTFzUnexpected color )rLlen ValueErrorrOs&& r.rM'CSSToExcelConverter._is_shorthand_colorsC ""3' t9> Y!^0?@ @r1)ryrp) r mediumDashDot dashDotDotrrrrdashDot slantDashDotrr3)+r:r;r<r=__doc__rr>rrrr8rLr__annotations__r8rrurrxrrrrrrrrrrrrr r r rrr r rr<r=rMr@)r6s0r.rXrXms"L uE(H(x L $ t t t t%5 u u u u uH" %$4J a11 J    E  u  (%$A-K/*. 0  O  7r( -X#  $   4' "2  A A{ s DrXc]tRtRtRtRtRtR RRlltRtRRlt R R lt R R lt R Rlt RRlt RRlt]RRl4tRRltRRltRRltR!RRlltRtR#)"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 or 'columns', default False Format MultiIndex column headers and Hierarchical Rows as merged cells if True. Merge MultiIndex column headers only if 'columns'. .. versionchanged:: 3.0.0 Added the 'columns' option. 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. autofilter : bool, default False If True, add automatic filters to all columns. NcDV^8dQhRRRRRRRRR R R R R RRRRRRR RR/ #)r#na_repr float_formatrrcolszSequence[Hashable] | NoneheaderzSequence[Hashable] | boolindexr index_labelzIndexLabel | None merge_cellsrinf_repstyle_converterrI autofilterr*r+r,)r-s"r.r/ExcelFormatter.__annotate__sz0%0%0%! 0% ( 0% * 0%0%'0%+0%0%)0%0% 0%r1c  *^VnW n\V\4'gBWnVPP 4VP pV f \4p WnMRVnRVnWn Ve\\V4PVP44'g \R4h\\V4PVP44\\V448wd \R4hVP!VR7Vn VPPVn W0nW`nWpnWPn\V\*4'gVR8wd\-RV: R24hWnWnWnR#)Nz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columnsrmz!Unexpected value for merge_cells=.) rowcounterr`rrstyler_computedatarXrhdfrTr intersectionrmr?setreindexrardrercrrUrfrgri) r7rsr`rarbrcrdrerfrgrhris &&&&&&&&&&&&r.r8ExcelFormatter.__init__s7 "i((K KK "B&"5"74C DK#'D   uT{// ;<<MNN5;++BJJ78CD NJOPPjjj.DGww ( & +t,, 1IA[N!DE E& $r1c \V4'd*\P!V4'dVPpM\ V4'd\P !V4'dVP pMV\P!V4'dRVP 2pM*VPe\VPV,4p\VRR4e \R4hV#)-Ntzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rr isnar`risposinf_scalarrgisneginf_scalarrargetattrrUr@s&&r. _format_valueExcelFormatter._format_valueNs S>>gll3//++C c]]&&s++ll((--$,,("".D--34 3$ ' 3@   r1cV^8dQhRR/#r#r*Iterable[ExcelCell]r,)r-s"r.r/rj`s11#61r1c# "VPP^8dVP'g \R4hVP'gVP 'gR#VPpVP R 9pVPVRR7p\V4p^p^pVP'dR\VPP\4'd(VPPP^, p\VP4Fwrg\VVVRR7xK \\WAP VP"RR74Fwpwrp V P%V 4p VP'4FpwrRRrV'dV ^8dYeV ,V ,r\)VW\,^,W,R\+VP,RR4VV VP.VVR 7 xKr K W`nR#5i) r*z]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.NTFsparsify include_names)r$r&r5r6strict ctx_columns r$r&r5r6rErFrGrHr'r)>Trm)rmnlevelsrdNotImplementedError _has_aliasesrcrf _format_multirrrsr enumeratenamesr!ziplevelscodestakerNrBr~rprhro)r7rm merge_columns level_strs level_lengths coloffsetlnumrspansr level_codesvaluesispan_valr'r)s& r._format_header_mi ExcelFormatter._format_header_mi`s <<  ! #:::)D !!!T[[[ ,,((,== **MQV*W )*5   :::*TWW]]J?? --1I#GMM2JD  33<  ~~w}}T J3 .D.5+[[-F${{} '+TH X\+/Q1I"! ) &t{{M4H "&"6"6)%   - 3 (s-HH HF&HcV^8dQhRR/#rr,)r-s"r.r/rjs(;r1c # :"VP'gVP'Edr^pVP'dV^p\VPP\ 4'd*\ VPPP4pVPpVP'd\\VP4Vn\ VP4\ VP48wd9\R\ VP4 R\ VP4 R24hVPp\V4FIwr4\VPW1,VR\VP RR4^VVP"R7xKK R#R#5i)rlzWriting z cols but got z aliasesNrr$r&r5r6rErFrGrH)rrcrdrrsrrTrrmr rrUrrBror~rprh)r7rcolnamescolindexcolnames& r._format_header_regular%ExcelFormatter._format_header_regulars4     Izzz dggmmZ88 #DGGMM$7$7 8I||H   "8T[[9 t{{#s4<<'88$"3t||#4"56##&t{{#3"4H> ;;%.x%8!" ,&t{{M4H$"&"6"6  &9%!,s%FFA2F/C,FcV^8dQhRR/#rr,)r-s"r.r/rjs** 3*r1c `a\SP\4'dSP4pMSP 4pRpSP P P'dSP P PUu.uF q3eTMRNK upR.\SP4,,p\P!RRV44'd/V3Rl\V44pS;P^, un \P!W4#uupi)Nr)cT;'dT#r3r,)xys&&r./ExcelFormatter._format_header..s QWW1Wr1c3*"TF qR8gxK R#5i)r)Nr,).0rs& r. 0ExcelFormatter._format_header..s6L1Bwsc3V<"TFwr\SPWR4xK R#5ir3)r!ro)rrr5r7s& r.rrs*)7 dooxdCC)7s&)r,)rrmrrrrsrdrrTrvreducerro itertoolschain)r7gengen2rr$sf r._format_headerExcelFormatter._format_headers dllJ / /((*C--/C$& 77==   7;ww}}7J7JK7J! 12-7JKODLL!O""C 46L6LMM)231$s))Ls D+cV^8dQhRR/#rr,)r-s"r.r/rjs//1/r1c \VPP\4'dVP 4#VP 4#r3)rrsrdr_format_hierarchical_rows_format_regular_rowsr7s&r. _format_bodyExcelFormatter._format_bodys5 dggmmZ 0 0113 3,,. .r1cV^8dQhRR/#rr,)r-s"r.r/rjs,2,2&9,2r1c # "VP'gVP'dV;P^, unVP'EdVP'dO\ VP\ \\P\34'dVP^,pMfVP'd.\ VP\4'dVPpM'VPPP^,p\ VP\4'dV;P^, unV'd2VPRJd"\!VP^, ^VR4xVPPp\ VPP\"4'd%VPPP%4p\'V4FJwr4\)VPV,^VR\+VP,RR4V^VP.R7xKL ^pM^pVP1V4RjxL R#L5i)r*FN ctx_indexr)rrcrordrerrtuplenpndarrayrrrsrrmrr!r to_timestamprrBr~rprh_generate_body)r7re index_valuesidxidxvalrs& r.r#ExcelFormatter._format_regular_rowss     OOq O :::J  4 E"B%%#..q1 !!!j1A1A3&G&G".. "ggmm11!4 $,, 331$t{{%7! 3Q TJJ 77==L$''--55#ww}}99; (6 "#-&t{{KF"&"6"6   7II&&y111s1$I*+I*I*%AI*BI*DI*!I("I*cV^8dQhRR/#rr,)r-s"r.r/rjsV0V0+>V0r1c# "VP'gVP'dV;P^, un^pVP'Ed]VPPP pVP 'dG\VP \\\P\34'd VP p\VP\4'dV;P^, un\P !V!'dEVPRJd5\#V4F%wr4\%VP^, W4R4xK' VP&'EdVP&R8wEdzVPPP)RRR7p\+V4p\-VVPPP.VPPP0RR7Fwrxp VP3V VP4VP6R7p \V ^,\84'dV P;4p VP=4FwrRRrV ^8d$VPV ,V ,^, p Tp\?VPV ,VW,R\AVPBRR4V VVPDV VR 7 xK V^, pK M\-VPPR R/Fp\#V4Fqwpp\V\84'dVP;4p\?VPV,VVR\AVPBRR4VVVPDR 7xKs V^, pK VPGV4RjxL R#L5i) r*FNrmTrr) allow_fill fill_valuerrrr)$rrcrordrsrrerrrrrrrmrcom any_not_nonerr!rfrrrrrr _can_hold_na _na_valuerrrNrBr~rprhr)r7gcolidx index_labelscidxrrrrrrrrrr'r) indexcolvalsr indexcolvals& r.r(ExcelFormatter._format_hierarchical_rowss     OOq O :::77==..LJ  4 E"B%% $// $,, 331$..4;;e3K"+L"9JD#DOOa$7TJJ#:D$4$4 $A!WW]]88!9 !2* = 25!GGMM((GGMM'' 3.E; $[[##)#6#6#)#3#3)F "&)V44!'!4!4!6',{{} /3TH#a<)-1)*>'1%-   (5"qLGA3H%($Dt$DL,5l,C([%k6::*5*B*B*DK* $# 5 ' +"&'.t{{K'N$'$+*.*>*>   -DqLG!%E$&&w///s1$O-O1OBO AO7IOO OcV^8dQhRR/#)r#r*rr,)r-s"r.r/rjUs))d)r1c ,\VP4#)z1Whether the aliases for column names are present.)r rcrs&r.rExcelFormatter._has_aliasesTsDKK((r1c V^8dQhRRRR/#)r#rr%r*rr,)r-s"r.r/rjYs0Cr1c # T"\\VP44FpVPPRV3,p\ V4FPwrE\ VPV,W!,VR\VPRR4VVVPR7xKR K R#5i):NNNNctxr) rangerTrmrsilocrrBror~rprh)r7rcolidxseriesrr5s&& r.rExcelFormatter._generate_bodyYsC -.FWW\\!V),F#F+"!+*&t{{E4@""&"6"6  ,/sB&B(cV^8dQhRR/#rr,)r-s"r.r/rjis%8r1c# "\P!VP4VP44F'pVP VP 4VnVxK) R#5ir3)rrrrrr5)r7cells& r.get_formatted_cells"ExcelFormatter.get_formatted_cellsisHOOD$7$7$94;L;L;NOD))$((3DHJPsA!A#c V^8dQhRRRR/#)r#rdr%r*rr,)r-s"r.r/rjnsr1c V^8d\RV 24hRpV^8g V'g*\V^4wr\^AV,4V,pK8V#)a Convert 0-based column index to Excel column name. Parameters ---------- index : int The numeric column index to convert to an Excel column name. Returns ------- column_name : str The column name corresponding to the index. Raises ------ ValueError Index is negative zIndex cannot be negative: r))rUdivmodchr)r7rd column_name remainders&& r. _num2excelExcelFormatter._num2excelnsT& 199%AB B ai{%eR0 Eb9n- ;Kr1c<V^8dQhRRRRRRRRRR R R R R RRRR/ #)r#writerz)FilePath | WriteExcelBuffer | ExcelWriter sheet_namerstartrowr%startcol freeze_panesztuple[int, int] | Noneenginerrstorage_optionszStorageOptions | None engine_kwargsrDr*r+r,)r-s"r.r/rjsouu9uu u  u - uu/u#u ur1c  ^RIHp VPPwrWP8gWP 8d,\ RV RV RVP RVP 24hVP'EdX^p ^p V ^8Xd^pMVP'd^p\VPP\4'dEVP'd \ R4hVPPP^, p\VP\4'dQVP'd \ R4hVPPp VPP^,p MR pVPV4 W<, 2pVPWK,V,4pV W:,V , 2pV RV 2pMRpVf/pVP4p\W4'dRpMV !VVVVR 7pR pVP!VVVVVVR 7V'dVP#4R#R# T'dTP#4ii;i) 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 : dict, optional Extra options that make sense for a particular storage connection, e.g. host, port, username, password, etc. For HTTP(S) URLs the key-value pairs are forwarded to ``urllib.request.Request`` as header options. For other URLs (e.g. starting with "s3://", and "gcs://") the key-value pairs are forwarded to ``fsspec.open``. Please see ``fsspec`` and ``urllib`` for more details, and for more examples on storage options refer `here `_. engine_kwargs: dict, optional Arbitrary keyword arguments passed to excel engine. rz-This sheet is too large! Your sheet size is: z, z Max sheet size is: zwExcel filters merged cells by showing only the first row. 'autofilter' and 'merge_cells' cannot be used simultaneously.:NF)rrrT)rrrautofilter_ranger-)pandas.io.excelrrsshapemax_rowsmax_colsrUrirdrrrfrrmrr _write_cellsclose)r7rrrrrrrrrnum_rowsnum_colsstartrowsoffset endrowsoffset indexoffsetstartautofilter_end_columnendrformatted_cells need_saves&&&&&&&&& r.writeExcelFormatter.writes3R 0!WW]] mm #x--'??zH:V&&*mm_Bt}}oG  ???OM1}  dggmmZ88'''(6 '+ggmm&;&;a&? dllJ77'''(6 +/,,*>*>(, (<(*,/ ,2\V0p))  8uur1r^)8r[ __future__rcollections.abcrrrrrrvrr$typingrr r rnumpyrpandas._libs.libr pandas.util._exceptionsr pandas.core.dtypesr pandas.core.dtypes.commonrrpandasrrrrrpandas.core.commoncorecommonrpandas.io.formats._color_datarpandas.io.formats.cssrrpandas.io.formats.formatrpandas._typingrrrrrrr!rBrXr^r,r1r.r's#  )4& ! 57#!!*K9K2CACAL LLr1