ddZddlmZddlmZmZddlZddlZddlm Z m Z m Z m Z m Z mZmZddlZddlZddlmZddlmZmZddlmZdd lmZdd lmZdd lmZm Z dd l!m"Z"m#Z#m$Z$m%Z%ddl&m'cm(Z)dd l*m+Z+ddl,m-Z-ddl.m/Z/m0Z0ddl1m2Z2ddl3m4Z4GddZ5Gdde5Z6GddZ7GddZ8dS)zC Utilities for conversion to writer-agnostic Excel representation. ) annotations) lru_cachereduceN)AnyCallableHashableIterableMappingSequencecast) is_list_like) IndexLabelStorageOptions)doc)find_stack_level)missing)is_float is_scalar) DataFrameIndex MultiIndex PeriodIndex) _shared_docs) CSS4_COLORS) CSSResolver CSSWarning)get_level_lengths) pprint_thingc&eZdZdZeZ d d d ZdS) ExcelCellrowcolvalstyle mergestartmergeendNr"intr#r& int | Noner'returnNonecZ||_||_||_||_||_||_dSNr!)selfr"r#r$r%r&r's S/var/www/html/t/fyr/venv311/lib/python3.11/site-packages/pandas/io/formats/excel.py__init__zExcelCell.__init__=s2 $  )NNN) r"r(r#r(r&r)r'r)r*r+)__name__ __module__ __qualname__ __fields__ __slots__r0r1r/r r 9sBIJI!%#!!!!!!!r1r c eZdZdfd ZxZS) CssExcelCellr"r(r#r% dict | None css_styles3dict[tuple[int, int], list[tuple[str, Any]]] | Nonecss_rowcss_col css_converterCallable | Noner*r+c  |rB|r@d|||fD} t| } || }tjd||||d| dS)Nc>i|]\}}||Sr7lower).0propr$s r/ z)CssExcelCell.__init__..]s3   &/dC c   r1r"r#r$r%r7) frozensetitemssuperr0) r.r"r#r$r%r;r=r>r?kwargsdeclaration_dictunique_declarations __class__s r/r0zCssExcelCell.__init__Os  7- 7  3=gw>N3O    #,,<,B,B,D,D"E"E !M"566EJScs%JJ6JJJJJr1)r"r(r#r(r%r:r;r<r=r(r>r(r?r@r*r+)r2r3r4r0 __classcell__)rOs@r/r9r9NsGKKKKKKKKKKr1r9cteZdZUdZeZdddddddZdddddddddddddd Zdddd Zd d d d dZ ddDZ de d<dJdKdZ e ZdLdZdLdZdMdZdNd!ZdOd"ZdPd$ZdQd&ZdRd*ZdSd,ZdTd.ZdUd1ZdVd2ZdWd4ZdXd6ZdPd7ZdPd8ZdYd:ZdZd<Z dPd=Z!dYd>Z"d[d@Z#d\dBZ$d]dDZ%d^dGZ&d_dHZ'd^dIZ(dS)`CSSToExcelConverteraK 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)rSztext-topmiddlebaselinerUz text-bottomTF) boldbolder600700800900normallighter100200300400500)r^italicoblique)serifz sans-serifcursivefantasyc8i|]}||Sr7rC)rEr%s r/rGzCSSToExcelConverter.s2   ur1) dashed mediumDashDot dashDotDothairdottedmediumDashDotDotdoubledashDot slantDashDot mediumDashedzdict[str, str] | None inheritedN str | Noner*r+c||||_nd|_td|j|_dS)N)maxsize) compute_cssryr_call_uncached _call_cached)r.rys r/r0zCSSToExcelConverter.__init__sN  !--i88DNN!DN4Id333D4GHHr1 declarations str | frozenset[tuple[str, str]]dict[str, dict[str, str]]c,||S)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.rs r/__call__zCSSToExcelConverter.__call__s&  ...r1cb|||j}||Sr-)r}ry build_xlstyle)r.r propertiess r/r~z"CSSToExcelConverter._call_uncacheds/%%lDNCC !!*---r1propsMapping[str, str]c||||||||||d}dfd ||S)N) alignmentborderfillfont number_formatddict[str, str | None]r*r+ct|D]0\}}|||= t|tr||s||=1dS)z4Remove key where value is None, through nested dictsN)listrJ isinstancedict)rkv remove_nones r/rz6CSSToExcelConverter.build_xlstyle..remove_noneskQWWYY ! !19!4((!KNNN!aD  ! !r1)rrr*r+)build_alignment build_border build_fill build_fontbuild_number_format)r.routrs @r/rz!CSSToExcelConverter.build_xlstyles--e44''..OOE**OOE**!55e<<    ! ! ! ! ! !  C r1dict[str, bool | str | None]c|d||||dS)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr.rs r/rz#CSSToExcelConverter.build_alignmentsD ))L1144U;;//66   r1ch|d}|r|j|SdS)Nzvertical-align)r VERTICAL_MAP)r.rvertical_aligns r/rz+CSSToExcelConverter._get_vertical_alignments8#344  9$((88 8tr1 bool | Nonec^|ddSt|ddvS)Nz white-space)nowrapprezpre-line)rboolrs r/rz%CSSToExcelConverter._get_is_wrap_texts2 99] # # +4E-(0MMNNNr1 dict[str, dict[str, str | None]]c$fddDS)NcJi|]}|d|dd|dd|dd|ddS)zborder-z-stylez-widthz-color)r%color) _border_stylercolor_to_excel)rEsiderr.s r/rGz4CSSToExcelConverter.build_border.. s     ++II444455II444455'' 2HD2H2H2H(I(IJJ ,,UYY7M7M7M7M-N-NOO     r1rSrightrUleftr7rs``r/rz CSSToExcelConverter.build_border s6      ;    r1r%widthrcP|||dS||dS|dvrdS||}|dS|dvr|S|dkrdS|dkr|dvrdSdS|dkr|dvrdSd S||jvr |j|Stjd t |t t dS) Nnone)rhidden)Ngrooveridgeinsetoutsetsolidrurs)rrthinrtrorxzUnhandled border style format:  stacklevel)_get_width_nameBORDER_STYLE_MAPwarningswarnreprrr)r.r%rr width_names r/rz!CSSToExcelConverter._border_styles =U]u}4 =U]6 & & &6))%00  6 I I I  H  8 H  ---x%% H  ---x!> d+ + +(/ / M?$u++??+--     6r1 width_inputc`||}|dkrdS|dkrdS|dkrdSdS)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r.rrs r/rz#CSSToExcelConverter._get_width_namePsD$$[11 4<<4 S[[6 S[[8wr1floatc4|d}||S)N2pt) _pt_to_float)r.rs r/rz#CSSToExcelConverter._width_to_floatZs =E  '''r1 pt_stringstrct|dsJt|dS)Npt)endswithrrstrip)r.rs r/rz CSSToExcelConverter._pt_to_float_s8!!$'''''Y%%d++,,,r1ch|d}|dvr||ddSdS)Nzbackground-color)N transparentrr)fgColor patternType)rr)r.r fill_colors r/rzCSSToExcelConverter.build_fillcsFYY122 : : :#22:>>wWW W ; :r1rc|d}t|tr|ddn|}d|iS)Nz number-format§; format_code)rrrreplace)r.rfcs r/rz'CSSToExcelConverter.build_number_formatjsE YY ' '&0S&9&9 ARZZc " " "rr""r1$dict[str, bool | float | str | None]c ||}||}|r|dnd||||||||d|vrdndd|vpd||d||d S)Nr underlinesinglez line-throughr) namefamilysizerXrerstrikershadow) _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/rzCSSToExcelConverter.build_fontos))%00 ))%00 %/9JqMMT..z::''..%%e,,))%00&1Z&?&?((T%3<((7););<<&&u--   r1ch|d}|r|j|SdS)Nz font-weight)rBOLD_MAP)r.rweights r/rz CSSToExcelConverter._get_is_bolds6=))  -=$$V,, ,tr1ch|d}|r|j|SdS)Nz font-style)r ITALIC_MAP)r.r font_styles r/rz"CSSToExcelConverter._get_is_italics6YY|,,  3?&&z22 2tr1 Sequence[str]c\|d}||SdS)Nztext-decorationr7)rsplit)r.rrs r/rz#CSSToExcelConverter._get_decorations1YY011  !##%% %2r1rcd|vrdSdS)Nrrr7)r.rs r/_get_underlinez"CSSToExcelConverter._get_underlines * $ $8tr1c^d|vr(ttjd|dSdS)Nz text-shadowz ^[^#(]*[1-9])rresearchrs r/rzCSSToExcelConverter._get_shadows1 E ! ! .% 2FGGHH Htr1cptjd|dd}g}|D]}|dddkr|dddd}nA|dddkr|ddd d}n|}|r|||S) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyrg"z\"'z\')rfindallrrstripappend)r.rfont_names_tmprrs r/rz#CSSToExcelConverter._get_font_namess  IImR ( (    " ( (DBQBx3AbDz))%55bqbSAbDz))%55zz|| (!!$'''r1 float | Nonec^|d}||S||S)Nz font-size)rr)r.rrs r/rz"CSSToExcelConverter._get_font_sizes1yy%% <K  &&&r1r)cPd}|D] }|j|}|rn!|Sr-) FAMILY_MAPr)r.rrrs r/rz'CSSToExcelConverter._select_font_familysD  D_((..F   r1r$c|dS||r||S |j|S#t$r;t jdt |ttYnwxYwdS)NzUnhandled color format: r) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorrrrrrr.r$s r/rz"CSSToExcelConverter.color_to_excels ;4   c " " 3--c22 2 $S) )    M649966+--        ts =ABB color_stringrcFt|dS)N#)r startswith)r.rs r/rz!CSSToExcelConverter._is_hex_colorsL++C00111r1c|d}||r5|ddz|ddzz|ddzzS|S)Nrrrhrg)lstrip_is_shorthand_colorupperr.rcodes r/rz)CSSToExcelConverter._convert_hex_to_excelsm""3''  # #L 1 1 GaK$q'A+-Q! ;BBDD D::<< r1c|d}t|dkrdSt|dkrdStd|)zcCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. rTFzUnexpected color )rlen ValueErrorr!s r/rz'CSSToExcelConverter._is_shorthand_colorsV ""3'' t99>>4 YY!^^5???@@ @r1r-)ryrzr*r+)rrr*r)rrr*r)rrr*r)rrr*rz)rrr*r)rrr*r)r%rzrrzrrz)rrzr*rz)rrzr*r)rrr*r)rr)rrr*r)rrr*r)rrr*r)rrr*rz)rrr*r)r*r))r$rzr*rz)rrr*r)rrr*r))r2r3r4__doc__rrrrrrr__annotations__r0rr}rr~rrrrrrrrrrrrrrrrrrrrrrrrr7r1r/rRrRgs"L LH"J J  (%$$$IIIII+--K////*.... 0     OOOO     5555n(((( ----XXXX####     $    4'''' "2222     A A A A A Ar1rRceZdZdZdZdZ d7d8dZed9dZdZ d:d Z d:d!Z d:d"Z d:d#Z d:d$Zd:d%Zed;d&Zdd6ZdS)?ExcelFormattera9 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@rNTFinfna_repr float_formatrzcolsSequence[Hashable] | NoneheaderSequence[Hashable] | boolindexr index_labelIndexLabel | None merge_cellsinf_repstyle_converterr@r*r+c d|_||_t|ts?||_|j|j}| t} | |_nd|_d|_||_ |tt| |j stdtt| |j tt|krtd|||_ |j j |_ ||_||_||_||_||_| |_dS)Nrz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columns) rowcounterr-rrstyler_computedatarRr8dfr&r intersectionr:rsetreindexr.r3r4r1r6r7) r.r?r-r.r/r1r3r4r6r7r8s r/r0zExcelFormatter.__init__sI "i(( (DK K " " "B&"5"7"74CD DK#'D   uT{{// ;;<< OMNNN5;;++BJ7788CD NNJJOPPPjjj..DGw ( & & r1 dict[str, dict[str, str | bool]]c"ddidddddddddS) NrXTrrrTrS)rr)rbordersrr7r.s r/ header_stylezExcelFormatter.header_styleAs=TN   )1eDD   r1clt|rtj|r|j}nht |rYtj|r|j}n=tj|r d|j}n|jt|j|z}t|ddtd|S)N-tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rrisnar-risposinf_scalarr7isneginf_scalarr.rgetattrr'rs r/ _format_valuezExcelFormatter._format_valueNs S>> 5gl3// 5+CC c]] 5&s++ 5l(-- 5($,((".D-344 3$ ' ' 3@   r1Iterable[ExcelCell]c#rK|jjdkr|jstd|js |jsdS|j}||jdd}t|}d}d}|jrAt|j jtr"t|j jddz }|jrt|jD]\}}t||||jV tt#||j|jD]\}\}}} || } |D]_\} } d\} }| dkr ||| z| z}} t-||| zdz| | |jt/|jdd|| |j| | V`ntt#|D]j\} } d t7t8| }t-||| zdz||jt/|jdd|| |j Vk||_dS) Nrgz]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.FsparsifyadjoinnamesrrHNN ctx_columns r"r#r$r%r;r=r>r?r&r'.r"r#r$r%r;r=r>r?)r:nlevelsr3NotImplementedError _has_aliasesr1formatr6rrr?rr& enumeraterUr rGziplevelscodestakerJr9rNr<r8joinmaprr;)r.r: level_strs level_lengths coloffsetlnumrspansra level_codesvaluesispan_valr&r'rs r/_format_header_miz ExcelFormatter._format_header_mi`s < ! # #: )D ! T[  F,^^%e5$  **55   : 2*TW]J?? 2DGM!,--1I  + ' 66   d!+ 7@M7>7=AA77  22ufk [11#(;;==KAx+5(J!||/3Y]X5MH & %MA-"1I"/#*4; t#L#L $ !&*&:#-!)          ,'sJ'788   6HHSv6677"!A )+&t{M4HH "&"6       r1c #K|js|jr4d}|jr?d}t|jjt rt |jjj}|j}|jrtt|j|_t |jt |jkr:tdt |jdt |jd|j}t|D]F\}}t|j||z||jt!|jddd||jVEdSdS)NrrgzWriting z cols but got z aliasesrWrZ)r]r1r3rr?rr&rUr:r r r'r_r9r;rGrNr<r8)r.rhcolnamescolindexcolnames r/_format_header_regularz%ExcelFormatter._format_header_regularsw     Iz 9 dgmZ889 #DGM$7 8 8I|H  '"8T[99 t{##s4<'8'888$>3t|#4#4>>#&t{#3#3>>> ;%.x%8%8  !'" 9,+&t{M4HH$"&"6       '  $  r1ctjtr}n}d}jjjrdjjjDdgtjzz}tdtd|r+fdt|D}xj dz c_ tj||S)Nr7cg|]}||nd SNrr7)rExs r/ z1ExcelFormatter._format_header..s KKK! 112KKKr1rc |o|Sr-r7)rxys r/z/ExcelFormatter._format_header..s 17r1c|dkSrwr7)rxs r/r|z/ExcelFormatter._format_header..s !r'r1c3VK|]#\}}tj||jV$dSr-)r r;rG)rErrr$r.s r/ z0ExcelFormatter._format_header..sN%#doxd>OPPr1rg)rr:rrortr?r3rUr&rrer_r; itertoolschain)r.gengen2r"s` r/_format_headerzExcelFormatter._format_headers dlJ / / 0((**CC--//C$& 7=  %KKtw}7JKKKODL!!O""C**C0A0A3,G,GHH %)231$sD)))r1ct|jjtr|S|Sr-)rr?r3r_format_hierarchical_rows_format_regular_rowsrFs r/ _format_bodyzExcelFormatter._format_bodys< dgmZ 0 0 /1133 3,,.. .r1c #K|js|jr|xjdz c_|jr}|jr@t |jt ttj tfr|jd}n@|jr"t |jtr|j}n|j jj d}t |jtr|xjdz c_|r*|jdur!t!|jdz d||jV|j j}t |j jt$r|j j}t)|D]D\}}t+|j|zd||jt-|jdd|d|jVEd}nd}||Ed{VdS)NrgrF ctx_indexrZ)r]r1r;r3r4rrtuplenpndarrayrrr?rUr:rr rGr to_timestampr_r9rNr<r8_generate_body)r.r4 index_valuesidxidxvalrhs r/rz#ExcelFormatter._format_regular_rowss   !  ! OOq OO :%  5J 4 E"B%% 5#.q1 ! 5j1A3&G&G 5". "gm1!4 $, 33 %1$ Xt{%77! 3Q TEVWWWWW 7=L$'-55 <#w}99;; (66   V"#-+&t{KFF"&"6       III&&y11111111111r1c#6K|js|jr|xjdz c_d}|jrS|jjj}|jr9t|jtttj tfr|j}t|j tr|jr|xjdz c_t!j|r?|jdur6t%|D]&\}}t'|jdz |||jV'|jr |jjddd}t-|}t/||jjj|jjjD]\}}} || |j|j} |D]i\} } d\} }| dkr|j| z| zdz } |}t=|j| z|| | |jt?|j dd| ||j!| | Vj|dz }not/|jjD][}t%|D]D\}}t=|j|z|||jt?|j dd|||j! VE|dz }\|"|Ed{VdS) NrgrFTrR) allow_fill fill_valuerVrrXrZ)#r]r1r;r3r?rUr4rrrrrrr:rr6com any_not_noner_r rGr^rr`rarbrc _can_hold_na _na_valuerJr9rNr<r8r)r.gcolidx index_labelscidxrrfrgrjrarkrlrmrnr&r' indexcolvalsr indexcolvals r/rz(ExcelFormatter._format_hierarchical_rowss7   !  ! OOq OO :E !7=.L 0J 4 E"B%% 0 $/ $, 33 %8H %1$. X4;e3K3K"+L"9"9XXJD$#DOa$7tTEVWWWWWW1 !!W]11!%u2 !2* = = 25!47=#79L33!!.E6;$[[##)#6#)#3)F (-{{}} 8/9, H#a<<)-1)'1%-       qLGG5!<%($7 ! !L,5l,C,C  ([* $# 5 ' +"&"3'.t{K'N'N$'$+*.*>       qLGG&&w///////////r1c*t|jS)z1Whether the aliases for column names are present.)r r1rFs r/r]zExcelFormatter._has_aliases]sDK(((r1rhr(c #"Ktt|jD]j}|jjdd|f}t |D]B\}}t |j|z||z|dt|j dd|||j VCkdS)NctxrZ) ranger&r:r?ilocr_r9r;rNr<r8)r.rhcolidxseriesrmr$s r/rzExcelFormatter._generate_bodybsC --..  FW\!!!V),F#F++  3"!+*&t{E4@@""&"6          r1c#Ktj||D]%}||j|_|V&dSr-)rrrrrOr$)r.cells r/get_formatted_cellsz"ExcelFormatter.get_formatted_cellsrseOD$7$7$9$94;L;L;N;NOO  D))$(33DHJJJJ  r1storage_options)rSheet1r sheet_namestartrowstartcol freeze_panestuple[int, int] | Noneenginerc ddlm}|jj\} } | |jks | |jkr%t d| d| d|jd|j|} t||rd} n||||}d} | | |||| | r| d Sd S#| r| wwxYw) 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} .. versionadded:: 1.2.0 r) ExcelWriterz-This sheet is too large! Your sheet size is: z, z Max sheet size is: F)rrT)rrrN) pandas.io.excelrr?shapemax_rowsmax_colsr'rr _write_cellsclose) r.writerrrrrrrrnum_rowsnum_colsformatted_cells need_saves r/writezExcelFormatter.writews[@ 0/////!W]( dm # #x$-'?'?GGGHGG&*mGG7;}GG  2244 fk * * II![vFI    !!)        y   s B==C) rNNTTNFr,N)r-rr.rzr/r0r1r2r3rr4r5r6rr7rr8r@r*r+)r*rC)r*rP)r*r)rhr(r*rP)rrrNNN)rrrr(rr(rrrrzrrr*r+)r2r3r4r(rrr0propertyrGrOrortrrrrr]rrrrrr7r1r/r+r+s@HH #'*.,0)-!+/+++++Z    X  $CCCCJ>****,//// ,2,2,2,2\M0M0M0M0^)))X)   S&78999#/3!*.>>>>:9>>>r1r+)9r( __future__r functoolsrrrrtypingrrrr r r r rnumpyrpandas._libs.libr pandas._typingrrpandas.util._decoratorsrpandas.util._exceptionsrpandas.core.dtypesrpandas.core.dtypes.commonrrpandasrrrrpandas.core.commoncorecommonrpandas.core.shared_docsrpandas.io.formats._color_datarpandas.io.formats.cssrrpandas.io.formats.formatrpandas.io.formats.printingrr r9rRr+r7r1r/rs#""""" ))))))('''''444444&&&&&&  ! 000000555555766666333333!!!!!!!!*KKKKK9KKK2FAFAFAFAFAFAFAFAR FFFFFFFFFFr1