i%tdZddlmZddlmZmZmZmZmZddl Z ddl Z ddl Z ddl m Z mZmZddlZddlZddlmZddlmZddlmZdd lmZmZdd lmZmZmZm Z m!Z!ddl"m#cm$Z%dd l&m'Z'dd l(m)Z)m*Z*dd l+m,Z,e rddl-m.Z.m/Z/m0Z0m1Z1m2Z2ddlm3Z3GddZ4Gdde4Z5GddZ6GddZ7y)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 ExcelWriterc6eZdZdZeZ d ddZy) ExcelCellrowcolvalstyle mergestartmergeendNcX||_||_||_||_||_||_yNr#)selfr$r%r&r'r(r)s Y/var/www/pod-logistic/pod-ai/venv/lib/python3.12/site-packages/pandas/io/formats/excel.py__init__zExcelCell.__init__Cs. $  )NNN) r$intr%r0r( int | Noner)r1returnNone)__name__ __module__ __qualname__ __fields__ __slots__r.r/r-r"r"?sLIJI!%#! !!  !! !r/r"c@eZdZ dfd ZxZS) CssExcelCellc  |rK|rI|||fD cic]\} }| j|} } }t| j} || }t |d|||d| ycc}} w)Nr$r%r&r'r9)lower frozensetitemssuperr.)r,r$r%r&r' css_stylescss_rowcss_col css_converterkwargspropdeclaration_dictunique_declarations __class__s r-r.zCssExcelCell.__init__Us -4>gw>N3O &/dC c!   #,,<,B,B,D"E !"56E JScs%J6J sA$)r$r0r%r0r' dict | NonerBz3dict[tuple[int, int], list[tuple[str, Any]]] | NonerCr0rDr0rECallable | Noner2r3)r4r5r6r. __classcell__)rJs@r-r;r;TsfK KK  K H KKK'K KKr/r;ceZdZUdZeZdddddddZdddddddddddddd Zdddd Zd d d d dZ dDcic]}|j|c}}Z de d<d-d.dZ eZ d/dZ d/dZd0dZd1dZd2dZd3dZ d4dZ d5dZd6dZd7dZd8dZd9dZd:d Z d;d!Zd3d"Zd3d#Zdd(Z$d?d)Z%d@d*Z&dAd+Z'd@d,Z(ycc}}w)BCSSToExcelConverteraK 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)rPztext-topmiddlebaselinerRz text-bottomTF) boldbolder600700800900normallighter100200300400500)r[italicoblique)serifz sans-serifcursivefantasy) dashed mediumDashDot dashDotDothairdottedmediumDashDotDotdoubledashDot slantDashDot mediumDashedzdict[str, str] | None inheritedNc||j||_nd|_tj|j|_yr+) compute_cssru functoolscache_call_uncached _call_cached)r,rus r-r.zCSSToExcelConverter.__init__s:  !--i8DN!DN&OOD,?,?@r/c$|j|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, declarationss r-__call__zCSSToExcelConverter.__call__s&  ..r/c\|j||j}|j|Sr+)rwru build_xlstyle)r,r} propertiess r-rzz"CSSToExcelConverter._call_uncacheds+%%lDNNC !!*--r/c|j||j||j||j||j |d}dfd ||S)N) alignmentborderfillfont number_formatct|jD]*\}}|||= t|ts||r(||=,y)z4Remove key where value is None, through nested dictsN)listr@ isinstancedict)dkv remove_nones r-rz6CSSToExcelConverter.build_xlstyle..remove_nonesGQWWY !19!4(NaD  !r/)rdict[str, str | None]r2r3)build_alignment build_border build_fill build_fontbuild_number_format)r,propsoutrs @r-rz!CSSToExcelConverter.build_xlstyles`--e4''.OOE*OOE*!55e<   ! C r/ch|jd|j||j|dS)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr,rs r-rz#CSSToExcelConverter.build_alignments6 ))L144U;//6  r/c`|jd}|r|jj|Sy)Nzvertical-align)r VERTICAL_MAP)r,rvertical_aligns r-rz+CSSToExcelConverter._get_vertical_alignments.#34 $$((8 8r/cF|jdyt|ddvS)Nz white-space)nowrapprezpre-line)rboolrs r-rz%CSSToExcelConverter._get_is_wrap_text s* 99] # +E-(0MMNNr/c*dDcic]}||j|jd|d|jd|d|j|jd|d|j|jd|ddc}Scc}w)N)rPrightrRleftzborder-z-stylez-widthz-color)r'color) _border_stylercolor_to_excel)r,rsides r-rz CSSToExcelConverter.build_borders;   ++IIvV45IIvV45'' GD62H(IJ ,,UYYf7M-NO     sBBc|||yy|dvry|j|}|y|dvr|S|dk(ry|dk(r|dvryy|dk(r|dvryy ||jvr|j|Stjd |tt y) Nnone)rhidden)Ngrooveridgeinsetoutsetsolidrqro)rnthinrprkrtzUnhandled border style format:  stacklevel)_get_width_nameBORDER_STYLE_MAPwarningswarnrr )r,r'widthr width_names r-rz!CSSToExcelConverter._border_styles" =U]} & &))%0   I I  H  H --% H --! d++ +((/ / MM1%;+-  r/cJ|j|}|dkry|dkry|dkryy)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r, width_inputrs r-rz#CSSToExcelConverter._get_width_nameXs3$$[1 4< S[ S[r/c,|d}|j|S)N2pt) _pt_to_float)r,rs r-rz#CSSToExcelConverter._width_to_floatbs =E  ''r/c\|jdsJt|jdS)Npt)endswithfloatrstrip)r, pt_strings r-rz CSSToExcelConverter._pt_to_floatgs,!!$'''Y%%d+,,r/cV|jd}|dvr|j|ddSy)Nzbackground-color)N transparentrr)fgColor patternType)rr)r,r fill_colors r-rzCSSToExcelConverter.build_fillks7YY12 : :#22:>wW W ;r/ct|jd}t|tr|jddn|}d|iS)Nz number-format§; format_code)rrstrreplace)r,rfcs r-rz'CSSToExcelConverter.build_number_formatrs6 YY '&0S&9RZZc "rr""r/c V|j|}|j|}|r|dnd|j||j||j ||j |d|vrdndd|vxsd|j |jd|j|d S)Nr underlinesinglez line-throughr) namefamilysizerUrbrstrikershadow) _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_fontws))%0 ))%0 %/JqMT..z:''.%%e,))%0&1Z&?(T%3<((7);<&&u-  r/c`|jd}|r|jj|Sy)Nz font-weight)rBOLD_MAP)r,rweights r-rz CSSToExcelConverter._get_is_bolds+=) ==$$V, ,r/c`|jd}|r|jj|Sy)Nz font-style)r ITALIC_MAP)r,r font_styles r-rz"CSSToExcelConverter._get_is_italics+YY|, ??&&z2 2r/cJ|jd}||jSy)Nztext-decorationr9)rsplit)r,rrs r-rz#CSSToExcelConverter._get_decorations)YY01  !##% %r/cPd|vr"ttjd|dSy)Nz text-shadowz ^[^#(]*[1-9])rresearchrs r-rzCSSToExcelConverter._get_shadows( E ! .% 2FGH Hr/c$tjd|jdd}g}|D]b}|dddk(r|ddjdd}n.|dddk(r|ddjd d}n|j }|sR|j |d|S) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyrd"z\"'z\')rfindallrrstripappend)r,rfont_names_tmprrs r-rz#CSSToExcelConverter._get_font_namess  IImR (   " (DBQx3Abz))%5bqSAbz))%5zz|!!$' (r/cN|jd}||S|j|S)Nz font-size)rr)r,rrs r-rz"CSSToExcelConverter._get_font_sizes+yy% <K  &&r/cXd}|D]"}|jj|}|s!|S|Sr+) FAMILY_MAPr)r,rrrs r-rz'CSSToExcelConverter._select_font_familys< D__((.F    r/c|y|j|r|j|S |j|S#t$r*t j d|t tYywxYw)NzUnhandled color format: r) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorrrrr r,r&s r-rz"CSSToExcelConverter.color_to_excelsr ;   c "--c2 2 $$S) )  MM*3'2+-    s60A)(A)c6t|jdS)N#)r startswith)r, color_strings r-rz!CSSToExcelConverter._is_hex_colorsL++C011r/c|jd}|j|r(|ddz|ddzz|ddzzjS|jS)Nrrrerd)lstrip_is_shorthand_colorupperr,r codes r-rz)CSSToExcelConverter._convert_hex_to_excels]""3'  # #L 1GaK$q'A+-Q! ;BBD D::< r/c||jd}t|dk(ryt|dk(rytd|)zcCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. rTFzUnexpected color )r len ValueErrorrs r-r z'CSSToExcelConverter._is_shorthand_colorsC ""3' t9> Y!^0?@ @r/r+)ru str | Noner2r3)r}z str | frozenset[tuple[str, str]]r2dict[str, dict[str, str]])rMapping[str, str]r2r)rrr2zdict[str, bool | str | None])rrr2r)rrr2z bool | None)rrr2z dict[str, dict[str, str | None]])r'rrrrrr2r)rrr2r)rrr2r)rrr2r)rr)rrr2r)rrr2z$dict[str, bool | float | str | None])rrr2 Sequence[str])rrr2z float | None)rrr2r1)r&rr2r)r rr2r)r rr2r))r4r5r6__doc__rrrrrrr>r__annotations__r.rrwr~rzrrrrrrrrrrrrrrrrrrrrrrr ).0r's00r-rOrOms"L LH"J J     u(%$A-K/</ "/*.<. ". 0  O  &  )  77(27;E7 7r( -X#  & - $   4' "2  A{ sCrOceZdZdZdZdZ d ddZdZddZddZ dd Z dd Z dd Z dd Z edd ZddZddZddZ d ddZy)ExcelFormattera> 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 d|_||_t|tsA||_|jj |j }| t} | |_nd|_d|_||_ |tt|j|js tdtt|j|jtt|k7r td|j!||_ |jj|_ ||_||_||_||_t|t*s|dk7rt-d|d||_| |_| |_y)Nrz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columnsr z!Unexpected value for merge_cells=.) rowcounterna_reprrstyler_computedatarOstyle_converterdfrr intersectionr rsetreindex float_formatindex index_labelheaderrr merge_cellsinf_rep autofilter) r,r(r#r,colsr/r-r.r0r1r'r2s r-r.zExcelFormatter.__init__sD "i(DK KK "B&"5"74CD DK#'D   uT{// ;<MNN5;++BJJ78CD NJOPPjjj.DGww ( & +t, 1IA[N!DE E& $r/c|t|r"tj|r |j}nvt |rktj |r |j }nItj|rd|j }n$|jt|j|z}t|dd td|S)N-tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rrisnar#risposinf_scalarr1isneginf_scalarr,rgetattrrrs r- _format_valuezExcelFormatter._format_valueNs S>gll3/++C c]&&s+ll((-$,,("".D--34 3$ ' 3@   r/c#K|jjdkDr|js td|js |j sy|j}|j dv}|j|d}t|}d}d}|jrGt|jjtr#|jjjdz }t|jD]\}}t|||dtt||j |j"d D]\}\}} } | j%| } |j'D]Z\} } d \}}|r| dkDr ||| z| z}}t)||| zdz| | dt+|j,d d|| |j.|| \||_yw) Nrdz]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.>Tr Fsparsify include_namesrr=TstrictNN ctx_columns r$r%r&r'rBrCrDrEr(r))r nlevelsr-NotImplementedError _has_aliasesr/r0 _format_multirrr(r enumeratenamesr"ziplevelscodestaker@r;r:r$r'r")r,r  merge_columns level_strs level_lengths coloffsetlnumrspansrL level_codesvaluesispan_valr(r)s r-_format_header_miz ExcelFormatter._format_header_mi`s <<  ! #::)D !!T[[ ,,((,== **MQV*W )*5   ::*TWW]]J? --1I#GMM2 JD$   3<  w~~w}}T J3   .D.5&+[[-F${{}  8'1$ H X\+/Q1IJ"!A )q &t{{M4H "&"6"6)%      (sGGc #K|js |jrXd}|jrOd}t|jjt r)t |jjj}|j}|jrtt|j|_t |jt |jk7r8tdt |jdt |jd|j}t|D]F\}}t|j||z|dt|j ddd||j"Hyyw)NrrdzWriting z cols but got z aliasesrCr$r%r&r'rBrCrDrE)rGr/r-rr(rrrJr r rrrIr;r"r:r$r')r,rRcolnamescolindexcolnames r-_format_header_regularz%ExcelFormatter._format_header_regulars1    Izz dggmmZ8 #DGGMM$7$7 8I||H  "8T[[9 t{{#s4<<'88$"3t||#4"56##&t{{#3"4H> ;;%.x%8 !'" 9,&t{{M4H$"&"6"6   %!,sE3E5ctjtrj}nj }d}j j jrj j jDcgc]}||nd c}dgtjzz}tjdd|Dr)fdt|D}xjdz c_ tj||Scc}w)Nr9rc|xr|Sr+r9)xys r-z/ExcelFormatter._format_header..s QW1r/c3&K|] }|dk7 yw)rNr9)rrbs r- z0ExcelFormatter._format_header..s6L1qBw6Lsc3TK|]\}}tj||d!ywr+)r"r")rr]r&r,s r-rfz0ExcelFormatter._format_header..s,%#dooxdCs%(rd)rr rrYr_r(r-rJrrxreducerIr" itertoolschain)r,gengen2rbr$s` r-_format_headerzExcelFormatter._format_headers dllJ /((*C--/C$& 77==  7;ww}}7J7JK! 12-KODLL!O""C 46L6LM)231$sD))Ls Dct|jjtr|j S|j Sr+)rr(r-r_format_hierarchical_rows_format_regular_rowsr,s r- _format_bodyzExcelFormatter._format_bodys2 dggmmZ 0113 3,,. .r/c #(K|js |jr|xjdz c_|jr|jrDt |jt ttjtfr|jd}nV|jr't |jtr |j}n#|jjjd}t |jtr|xjdz c_|r+|jdurt!|jdz d|d|jj}t |jjt"r$|jjj%}t'|D]F\}}t)|j|zd|dt+|j,dd|d|j.Hd}nd}|j1|Ed{y7w)NrdrF ctx_indexr[)rGr/r"r-r.rrtuplenpndarrayrrr(rJr rr"r to_timestamprIr;r:r$r'_generate_body)r,r. index_valuesidxidxvalrRs r-rpz#ExcelFormatter._format_regular_rowss    OOq O ::J  4 E"B%#..q1 !!j1A1A3&G".. "ggmm11!4 $,, 31$t{{%7! 3Q TJJ 77==L$''--5#ww}}99; (6  V"#-&t{{KF"&"6"6   II&&y111sHH H Hc#K|js |jr|xjdz c_d}|jr|jjj }|j r@t|j tttjtfr |j }t|jtr|xjdz c_tj |r>|jdur0t#|D]"\}}t%|jdz ||d$|j&rf|j&dk7rV|jjj)dd}t+|}t-||jjj.|jjj0dD]\}}} |j3| |j4|j6} t| dt8r| j;} |j=D]l\} } d \} }| dkDr|j| z| zdz } |}t?|j| z|| | dtA|jBd d| ||jD| | n|dz }nt-|jjd diD]{}t#|D]f\}}t|t8r|j;}t?|j|z||dtA|jBd d|||jD h|dz }}|jG|Ed{y7w)NrdrFr Tr=r@) allow_fill fill_valuerBrtrDrAr[)$rGr/r"r-r(rJr.rrrurvrwrr rcom any_not_nonerIr"r0rHrrKrLrMrN _can_hold_na _na_valuerrxr@r;r:r$r'ry)r,gcolidx index_labelscidxrrPrQrTrLrUrVrWrXr(r) indexcolvalsr{ indexcolvals r-roz(ExcelFormatter._format_hierarchical_rowss     OOq O ::77==..LJ  4 E"B% $// $,, 31$.4;;e3K"+L"9KJD$#DOOa$7tTJJKD$4$4 $A!WW]]88!9 !2* = 25!GGMM((GGMM'' 3 !.E6; $[[##)#6#6#)#3#3)F "&)V4!'!4!4!6',{{} 8/9, H#a<)-1)*>'1%-   "qLGA !H%($Dt$D!L,5l,C([%k6:*5*B*B*DK* $# 5 ' +"&'.t{{K'N$'$+*.*>*>   qLG!!$&&w///sM MMMc,t|jS)z1Whether the aliases for column names are present.)r r/rqs r-rGzExcelFormatter._has_aliasesTsDKK((r/c #:Ktt|jD]v}|jjdd|f}t |D]I\}}t |j|z||z|dt|jdd|||jKxyw)Nctxr[) rangerr r(ilocrIr;r"r:r$r')r,rRcolidxseriesrWr&s r-ryzExcelFormatter._generate_bodyYsC -. FWW\\!V),F#F+ 3"!+*&t{{E4@""&"6"6    sBBc#Ktj|j|jD]&}|j |j |_|(ywr+)rirjrmrrr;r&)r,cells r-get_formatted_cellsz"ExcelFormatter.get_formatted_cellsisMOOD$7$7$94;L;L;NO D))$((3DHJ sAAc|dkrtd|d}|dkDs|s)t|d\}}td|z|z}|dkDr&|s)|S)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)rdivmodchr)r,r- column_name remainders r- _num2excelzExcelFormatter._num2excelnsc& 199%AB B ai{%eR0 E9b9n- ;Kai{r/c ddlm} |jj\} } | |jkDs| |j kDr+t d| d| d|jd|j |jrd} d} | dk(rd}n|jrd}t|jjtr:|jr t d|jjjdz }t|jtrI|jr t d|jj} |jjdz} nd}|j||| z}|j|| z|z}||| z| z}|d |}nd }|i}|j}t|| rd }n| |||| }d } |j!|||||||r|j#y y #|r|j#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 : 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: rdzwExcel 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 r(shapemax_rowsmax_colsrr2r-rrr0rEr rr _write_cellsclose)r,writer sheet_namerrrrrrr num_rowsnum_colsstartrowsoffset endrowsoffset indexoffsetstartautofilter_end_columnendrformatted_cells need_saves r-writezExcelFormatter.writes-R 0!WW]]( dmm #x$--'??zH:V&&*mm_Bt}}oG  ??OM1}  dggmmZ8''(6 '+ggmm&;&;a&? dllJ7''(6 +/,,*>*>(, (<(*,/ ,2\V0p))  >#/3!15%)u9uu u  u - uu/u#u ur/r)8r __future__rcollections.abcrrrrrrxrirtypingr r r rnumpyrvpandas._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;rOrr9r/r-rs#  )4& ! 57#!!*K9K2CACAL LLr/