A>i%~SrSSKJr SSKJrJrJrJrJr SSK r SSK r SSK r SSK J r JrJr SSKrSSKrSSKJr SSKJr SSKJr SS KJrJr SS KJrJrJrJ r J!r! SSK"J#s J$r% SS K&J'r' SS K(J)r)J*r* SS K+J,r, \ (aSSK-J.r.J/r/J0r0J1r1J2r2 SSKJ3r3 "SS5r4"SS\45r5"SS5r6"SS5r7g)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 ExcelWritercB\rSrSrSr\rSSSjjrSrg) ExcelCell?rowcolvalstyle mergestartmergeendNcLXlX lX0lX@lXPlX`lgNr$)selfr%r&r'r(r)r*s V/var/www/html/land-tabula/venv/lib/python3.13/site-packages/pandas/io/formats/excel.py__init__ExcelCell.__init__Cs" $ )r&r*r)r%r(r')NNN) r%intr&r2r) int | Noner*r3returnNone)__name__ __module__ __qualname____firstlineno__ __fields__ __slots__r/__static_attributes__r1r.r"r"?sQIJI!%#! !!  !! !!r1r"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 frozensetitemssuperr/)r-r%r&r'r( css_stylescss_rowcss_col css_converterkwargspropdeclaration_dictunique_declarations __class__s r.r/CssExcelCell.__init__Us~ -4>w>N3O 3Oid c!3O  #,,<,B,B,D"E !"56E JSs%J6J sA/r=)r%r2r&r2r( dict | NonerGz3dict[tuple[int, int], list[tuple[str, Any]]] | NonerHr2rIr2rJCallable | Noner4r5)r6r7r8r9r/r< __classcell__)rOs@r.r?r?TsfK KK  K H KKK'K KKr1r?c\rSrSr%Sr\rSSSSSSS.rSSSSSSSSSSSSSS . rSSSS .r S S S SS.r SVVs0sHnUR5U_M snnr S\ S'S/S0Sjjr\"5rS1SjrS1SjrS2SjrS3SjrS4SjrS5SjrS6SjrS7SjrS8SjrS9SjrS:SjrS;S jrSS%jr!S5S&jr"S>S'jr#S?S(jr$S@S)jr%SAS*jr&SBS+jr'SCS,jr(SBS-jr)S.r*gs snnf)DCSSToExcelConverterma 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)rWztext-topmiddlebaselinerYz text-bottomTF) boldbolder600700800900normallighter100200300400500)rbitalicoblique)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.r/CSSToExcelConverter.__init__s:  !--i8DN!DN&OOD,?,?@r1c$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&  ..r1cZURXR5nURU5$r,)r~r| build_xlstyle)r-r propertiess r.r"CSSToExcelConverter._call_uncacheds)%%lNNC !!*--r1c^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)listrE isinstancedict)dkv remove_nones r.r6CSSToExcelConverter.build_xlstyle..remove_nonesAQWWY94((N1D (r1)rdict[str, str | None]r4r5)build_alignment build_border build_fill build_fontbuild_number_format)r-propsoutrs @r.r!CSSToExcelConverter.build_xlstyles`--e4''.OOE*OOE*!55e<   ! C r1chURS5URU5URU5S.$)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr-rs r.r#CSSToExcelConverter.build_alignments6 ))L144U;//6  r1cjURS5nU(aURRU5$g)Nzvertical-align)r VERTICAL_MAP)r-rvertical_aligns r.r+CSSToExcelConverter._get_vertical_alignments.#34 $$((8 8r1cJURS5cg[USS;5$)Nz white-space)nowrapprezpre-line)rboolrs r.r%CSSToExcelConverter._get_is_wrap_text s* 99] # +E-(0MMNNr1c0SVs0sHnUURURSUS35URSUS35URURSUS3555URURSUS355S._M sn$s snf)N)rWrightrYleftzborder-z-stylez-widthz-color)r(color) _border_stylercolor_to_excel)r-rsides r.r CSSToExcelConverter.build_borders;  ; ++IIvV45IIvV45'' GD62H(IJ ,,UYYf7M-NO  ;   sB Bc0UcUcUcggUS;agURU5nUcgUS;aU$US:XagUS:XaUS;aggUS:XaUS;agg XR;aURU$[R"S U<3[[ 5S 9 g) Nnone)rhidden)Ngrooveridgeinsetoutsetsolidrxrv)ruthinrwrrr{zUnhandled border style format:  stacklevel)_get_width_nameBORDER_STYLE_MAPwarningswarnrr )r-r(widthr width_names r.r!CSSToExcelConverter._border_styles" =U]} & &))%0   I I  H  H --% H --! ++ +((/ / MM1%;+-  r1cPURU5nUS:agUS:agUS:agg)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r- width_inputrs r.r#CSSToExcelConverter._get_width_nameXs3$$[1 4< S[ S[r1c.UcSnURU5$)N2pt) _pt_to_float)r-rs r.r#CSSToExcelConverter._width_to_floatbs =E  ''r1cfURS5(de[URS55$)Npt)endswithfloatrstrip)r- pt_strings r.r CSSToExcelConverter._pt_to_floatgs/!!$''''Y%%d+,,r1cZURS5nUS;aURU5SS.$g)Nzbackground-color)N transparentrr)fgColor patternType)rr)r-r fill_colors r.rCSSToExcelConverter.build_fillks7YY12 : :#22:>wW W ;r1c~URS5n[U[5(aURSS5OUnSU0$)Nz number-format§; format_code)rrstrreplace)r-rfcs r.r'CSSToExcelConverter.build_number_formatrs9 YY '&0S&9&9RZZc "rr""r1c pURU5nURU5nU(aUSOSURU5URU5UR U5UR U5SU;aSOSSU;=(d SUR URS55URU5S. $)Nr underlinesinglez line-throughr) namefamilysizer\rirstrikershadow) _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_fontws))%0 ))%0 %/JqMT..z:''.%%e,))%0&1Z&?(T%3<((7);<&&u-  r1cjURS5nU(aURRU5$g)Nz font-weight)rBOLD_MAP)r-rweights r.r CSSToExcelConverter._get_is_bolds+=) ==$$V, ,r1cjURS5nU(aURRU5$g)Nz font-style)r ITALIC_MAP)r-r font_styles r.r"CSSToExcelConverter._get_is_italics+YY|, ??&&z2 2r1cLURS5nUbUR5$g)Nztext-decorationr=)rsplit)r-rrs r.r#CSSToExcelConverter._get_decorations)YY01  !##% %r1cVSU;a#[[R"SUS55$g)Nz text-shadowz ^[^#(]*[1-9])rresearchrs r.rCSSToExcelConverter._get_shadows( E ! .% 2FGH Hr1c:[R"SURSS55n/nUHknUSSS:XaUSSRSS5nO/USSS:XaUSSRS S5nOUR 5nU(dMZUR U5 Mm U$) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyrk"z\"'z\')r findallrrstripappend)r-rfont_names_tmprrs r.r#CSSToExcelConverter._get_font_namess  IImR (   "DBQx3Abz))%5bqSAbz))%5zz|t!!$'#r1cPURS5nUcU$URU5$)Nz font-size)rr)r-rrs r.r"CSSToExcelConverter._get_font_sizes+yy% <K  &&r1cfSnUH(nURRU5nU(dM' U$ U$r,) FAMILY_MAPr)r-rrrs r.r'CSSToExcelConverter._select_font_familys9D__((.Fv   r1cUcgURU5(aURU5$URU$![a) [R "SU<3[ [5S9 gf=f)NzUnhandled color format: r) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorrrrr r-r's r.r"CSSToExcelConverter.color_to_excelsu ;   c " "--c2 2 $$S) )  MM*3'2+-    s<0A/.A/c6[URS55$)N#)r startswith)r- color_strings r.r !CSSToExcelConverter._is_hex_colorsL++C011r1cURS5nURU5(a(USS-USS--USS--R5$UR5$)Nr'rrlrk)lstrip_is_shorthand_colorupperr-r)codes r.r!)CSSToExcelConverter._convert_hex_to_excels`""3'  # #L 1 1GaK$q'A+-Q! ;BBD D::< r1cURS5n[U5S:Xag[U5S:Xag[SU35e)zSCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. r'TFzUnexpected color )r,len ValueErrorr/s r.r-'CSSToExcelConverter._is_shorthand_colorsC ""3' t9> Y!^0?@ @r1)rr|r,)r| str | Noner4r5)rz str | frozenset[tuple[str, str]]r4dict[str, dict[str, str]])rMapping[str, str]r4r9)rr:r4zdict[str, bool | str | None])rr:r4r8)rr:r4z bool | None)rr:r4z dict[str, dict[str, str | None]])r(r8rr8rr8r4r8)rr8r4r8)rr8r4r)rrr4r)rr:)rr:r4r)rr:r4z$dict[str, bool | float | str | None])rr:r4 Sequence[str])rr:r4z float | None)rr;r4r3)r'r8r4r8)r)rr4r)r)rr4r)+r6r7r8r9__doc__rr"rrrrrCr__annotations__r/rr~rrrrrrrrrrrrrrrrrrrrrrr r!r-r<).0r(s00r.rUrUms"L LH"J J    E  u  (%$A-K/</ "/*.<. ". 0  O  &  )  77(27;E7 7r( -X#  & - $   4' "2  A{ sDrUc\rSrSrSrSrSrSSSjjrSrSSjr SS jr SS jr SS jr SS jr SS jr\SSj5rSSjrSSjrSSjrSSSjjrSrg)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. 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`lXplXPl[U[*5(dUS:wa[-SU<S35eXlXlXlg)Nrz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columnsrBz!Unexpected value for merge_cells=.) rowcounterna_reprrstyler_computedatarUstyle_converterdfr5r intersectionrBr#setreindex float_formatindex index_labelheaderrr6 merge_cellsinf_rep autofilter) r-rJrErNcolsrQrOrPrRrSrIrTs r.r/ExcelFormatter.__init__s7 "i((K KK "B&"5"74C DK#'D   uT{// ;<<MNN5;++BJJ78CD NJOPPjjj.DGww ( & +t,, 1IA[N!DE E& $r1c[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.) rrisnarErisposinf_scalarrSisneginf_scalarrNrgetattrr6r$s r. _format_valueExcelFormatter._format_valueNs S>>gll3//++C c]]&&s++ll((--$,,("".D--34 3$ ' 3@   r1c## URRS:aUR(d [S5eUR(dUR (dgURnUR S;nURUSS9n[U5nSnSnUR(aL[URR[5(a#URRRS- n[UR5Hupg[UUUSS9v M [[XAR UR"SS 95Hunupn U R%U 5n UR'5HXupS upU(aU S:aXeU -U -p[)UX\-S-XS[+UR,S S5UU UR.UUS 9 v MZ M X`lg7f) Nrkz]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.>TrBFsparsify include_namesrrBTstrictNN ctx_columns r%r&r'r(rGrHrIrJr)r*)rBnlevelsrONotImplementedError _has_aliasesrQrR _format_multirrrJr enumeratenamesr"ziplevelscodestakerEr?r]rFrIrD)r-rB merge_columns level_strs level_lengths coloffsetlnumrspansrp 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${{} '1$  X\+/Q1I"! ) &t{{M4H "&"6"6)%   - 3 (sGGc ## UR(dUR(GaeSnUR(aTSn[URR[ 5(a)[ URRR5nURnUR(a[[UR5Ul[ UR5[ UR5:wa8[S[ UR5S[ UR5S35eURn[U5HBup4[URX1-US[UR SS5SUUR"S9v MD gg7f)NrrkzWriting z cols but got z aliasesrgr%r&r'r(rGrHrIrJ)rkrQrOrrJrr5rnrBr rr6rmr?rDr]rFrI)r-rvcolnamescolindexcolnames r._format_header_regular%ExcelFormatter._format_header_regulars,    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%!,sF F cB^[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 QW1Wr1c3*# UH oS:gv M g7f)rNr=)r>rs r. 0ExcelFormatter._format_header..s6L1Bwsc3V># UHup[TRXS5v M g7fr,)r"rD)r>rr'r-s r.rrs*)7 dooxdCC)7s&)rk)rrBrr}rrJrOrnr5rreducermrD 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,)rrJrOr_format_hierarchical_rows_format_regular_rowsr-s r. _format_bodyExcelFormatter._format_bodys5 dggmmZ 0 0113 3,,. .r1c ## UR(dUR(aU=RS- slUR(GaUR(aI[ UR[ [[R[45(aURSnO`UR(a,[ UR[5(a URnO#URRRSn[ UR[5(aU=RS- slU(a,URSLa[!URS- SUS5v URRn[ URR["5(a$URRR%5n['U5HCup4[)URU-SUS[+UR,SS5USUR.S9v ME SnOSnUR1U5ShvN gN7f)NrkrF ctx_indexr)rkrQrDrOrPrrtuplenpndarrayrrrJrnrBrr"r to_timestamprmr?r]rFrI_generate_body)r-rP index_valuesidxidxvalrvs 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&&y111sH9I;I<Ic## UR(dUR(aU=RS- slSnUR(GaURRR nUR (aE[UR [[[R[45(a UR n[UR[5(aU=RS- sl[R "U6(a?URSLa0[#U5H!up4[%URS- X4S5v M# UR&(GaaUR&S:wGaPURRR)SSS9n[+U5n[-UURRR.URRR0SS9Hupxn UR3U UR4UR6S9n [U S[85(aU R;5n UR=5HhupS upU S:aURU -U -S- n Un[?URU -UXS[AURBS S5U UURDU US 9 v Mj US- nM O[-URRS S06Hn[#U5Hiunn[U[85(aUR;5n[?URU-UUS[AURBS S5UUURDS 9v Mk US- nM URGU5ShvN gN7f)NrkrFrBTrard) allow_fill fill_valuerfrrhrer)$rkrQrDrOrJrnrPrrrrrrrBrcom any_not_nonermr"rRrlrrorprqrr _can_hold_na _na_valuerrrEr?r]rFrIr)r-gcolidx index_labelscidxrrtrurxrpryrzr{r|r)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',{{} /9, #a<)-1)*>'1%-   (5"qLGA3H%($Dt$DL,5l,C([%k6::*5*B*B*DK* $# 5 ' +"&'.t{{K'N$'$+*.*>*>   -DqLG!%E$&&w///sM7N9M?:Nc,[UR5$)z1Whether the aliases for column names are present.)r rQrs r.rkExcelFormatter._has_aliasesTsDKK((r1c #8# [[UR55HtnURRSS2U4n[ U5HEupE[ URU-X!-US[URSS5UUURS9v MG Mv g7f)Nctxr) ranger5rBrJilocrmr?rDr]rFrI)r-rvcolidxseriesr{r's r.rExcelFormatter._generate_bodyYsC -.FWW\\!V),F#F+"!+*&t{{E4@""&"6"6  ,/sBBc## [R"UR5UR55H'nUR UR 5UlUv M) g7fr,)rrrrr^r')r-cells r.get_formatted_cells"ExcelFormatter.get_formatted_cellsisHOOD$7$7$94;L;L;NOD))$((3DHJPsA A"cUS:a[SU35eSnUS:dU(d0[US5up[SU-5U-nUS:aM'U(dM0U$)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 rzIndex cannot be negative: rA)r6divmodchr)r-rO column_name remainders r. _num2excelExcelFormatter._num2excelnsc& 199%AB B ai{%eR0 Eb9n- ;Kai{{r1c ^SSKJn URRupXR:dXR :a+[ SU SU SURSUR 35eUR(Ga5Sn Sn U S:XaSnOUR(aSn[URR[5(a?UR(a [ S5eURRRS- n[UR[5(aKUR(a [ S5eURRn URRS-n OSnURU5X<-3nURXK-U-5nUX:-U -3nUS U3nOS nUc0nUR5n[X5(aS nO U "UUUUS 9nS nUR!UUUUUUS9 U(aUR#5 g g !U(aUR#5 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 : 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. rrz-This sheet is too large! Your sheet size is: z, z Max sheet size is: rkzwExcel filters merged cells by showing only the first row. 'autofilter' and 'merge_cells' cannot be used simultaneously.r:NF)enginestorage_options engine_kwargsT)startrowstartcol freeze_panesautofilter_range)pandas.io.excelr rJshapemax_rowsmax_colsr6rTrOrrrRrirBrr _write_cellsclose)r-writer sheet_namerrrrrrr num_rowsnum_colsstartrowsoffset endrowsoffset indexoffsetstartautofilter_end_columnendrformatted_cells need_saves r.writeExcelFormatter.writes+R 0!WW]] mm #x--'??zH:V&&*mm_Bt}}oG  ???OM1}  dggmmZ88''(6 '+ggmm&;&;a&? dllJ77''(6 +/,,*>*>(, (<(*,/ ,2\V0p))  >#/3!15%)u9uu u  u - uu/u#u uur1r@)8r< __future__rcollections.abcrrrrrrrr typingr r r rnumpyrpandas._libs.libr pandas.util._exceptionsr pandas.core.dtypesrpandas.core.dtypes.commonrrpandasrrrrrpandas.core.commoncorecommonrpandas.io.formats._color_datarpandas.io.formats.cssrrpandas.io.formats.formatrpandas._typingrrrrrr r"r?rUr@r=r1r.rs#  )4& ! 57#!!*K9K2CACAL LLr1