o 5cY~@s\dZddlmZddlmZmZddlZddlZddlm 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'm(Z)dd l*m+Z+ddl,m-Z-ddl.m/Z/m0Z0ddl1m2Z2ddl3m4Z4GdddZ5Gddde5Z6GdddZ7GdddZ8dS)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@s&eZdZdZeZ   d dd d ZdS) ExcelCellrowcolvalstyle mergestartmergeendNr intr!r$ int | Noner%returnNonecCs(||_||_||_||_||_||_dSNr)selfr r!r"r#r$r%r,M/var/www/html/gps/gps/lib/python3.10/site-packages/pandas/io/formats/excel.py__init__=s   zExcelCell.__init__)NNN) r r&r!r&r$r'r%r'r(r))__name__ __module__ __qualname__ __fields__ __slots__r.r,r,r,r-r9srcseZdZdfdd ZZS) CssExcelCellr r&r!r# dict | None css_styles3dict[tuple[int, int], list[tuple[str, Any]]] | Nonecss_rowcss_col css_converterCallable | Noner(r)c  sR|r|rdd|||fD} t| } || }tjd||||d| dS)NcSsi|] \}}||qSr,)lower).0propr"r,r,r- ]sz)CssExcelCell.__init__..r r!r"r#r,) frozensetitemssuperr.) r+r r!r"r#r6r8r9r:kwargsdeclaration_dictunique_declarations __class__r,r-r.Os    zCssExcelCell.__init__)r r&r!r&r#r5r6r7r8r&r9r&r:r;r(r))r/r0r1r. __classcell__r,r,rGr-r4Nsr4c@seZdZUdZeZdddddddZdddddddddddddd Zdddd Zd d d d dZ de d<dcddddZ e Z deddZdeddZdfd d!Zdgd#d$Zdhd%d&Zdid(d)Zdjd+d,Zdkd0d1Zdld3d4Zdmd6d7Zdnd:d;Zdod.remove_none)ryrzr(r))build_alignment build_border build_fill build_fontbuild_number_format)r+rroutr,rr-rps  z!CSSToExcelConverter.build_xlstyledict[str, bool | str | None]cCs|d||||dS)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr+rrr,r,r-rsz#CSSToExcelConverter.build_alignmentcC|d}|r |j|SdS)Nzvertical-align)r VERTICAL_MAP)r+rrvertical_alignr,r,r-r  z+CSSToExcelConverter._get_vertical_alignment bool | NonecCs"|ddur dSt|ddvS)Nz white-space)nowrapprezpre-line)rboolrr,r,r-rsz%CSSToExcelConverter._get_is_wrap_text dict[str, dict[str, str | None]]csfdddDS)Ncsfi|]/}|d|dd|dd|dd|ddqS)zborder-z-stylez-widthz-color)r#color) _border_stylercolor_to_excel)r=siderrr+r,r-r?s z4CSSToExcelConverter.build_border..rKrightrMleftr,rr,rr-rs  z CSSToExcelConverter.build_borderr#widthrcCs|dur|dur|durdS|dur|durdS|dks |dkr"dS||}|dur-dS|dvr3|S|dkr9dS|dkrE|dvrCdSdS|dkrQ|dvrOdSd SdS) Nnonehidden)Ngrooveridgeinsetoutsetsoliddoubledotted)hairthinmediumDashDotDotdashed mediumDashed)_get_width_name)r+r#rr width_namer,r,r-r s, z!CSSToExcelConverter._border_style width_inputcCs2||}|dkr dS|dkrdS|dkrdSdS)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r+rrr,r,r-r6s z#CSSToExcelConverter._get_width_namefloatcCs|durd}||S)N2pt) _pt_to_float)r+rr,r,r-r@s z#CSSToExcelConverter._width_to_float pt_stringstrcCs|dsJt|dS)Npt)endswithrrstrip)r+rr,r,r-rEsz CSSToExcelConverter._pt_to_floatcCs&|d}|dvr||ddSdS)Nzbackground-color)N transparentrr)fgColor patternType)rr)r+rr fill_colorr,r,r-rIs zCSSToExcelConverter.build_fillrzcCs,|d}t|tr|ddn|}d|iS)Nz number-format§; format_code)rr|rreplace)r+rrfcr,r,r-rPs z'CSSToExcelConverter.build_number_format$dict[str, bool | float | str | None]c Csv||}||}|r|dnd||||||||d|vr'dndd|vp-d||d||d S)Nr underlinesinglez line-throughr) namefamilysizerPr]rstrikershadow) _get_font_names_get_decoration_select_font_family_get_font_size _get_is_bold_get_is_italicrr _get_shadow)r+rr font_names decorationr,r,r-rUs   zCSSToExcelConverter.build_fontcCr)Nz font-weight)rBOLD_MAP)r+rrweightr,r,r-rgrz CSSToExcelConverter._get_is_boldcCr)Nz font-style)r ITALIC_MAP)r+rr font_styler,r,r-rmrz"CSSToExcelConverter._get_is_italic Sequence[str]cCs|d}|dur |SdS)Nztext-decorationr,)rsplit)r+rrrr,r,r-rss z#CSSToExcelConverter._get_decorationrcCsd|vrdSdS)Nrrr,)r+rr,r,r-_get_underlinezsz"CSSToExcelConverter._get_underlinecCs d|vrttd|dSdS)Nz text-shadowz ^[^#(]*[1-9])rresearchrr,r,r-rszCSSToExcelConverter._get_shadowcCstd|dd}g}|D]3}|dddkr#|dddd}n|dddkr6|ddd d}n|}|rA||q|S) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyr_"z\"'z\')rfindallrrstripappend)r+rrfont_names_tmprrr,r,r-rs   z#CSSToExcelConverter._get_font_names float | NonecCs |d}|dur |S||S)Nz font-size)rr)r+rrrr,r,r-rs  z"CSSToExcelConverter._get_font_sizer'cCs(d}|D] }|j|}|r|Sq|Sr*) FAMILY_MAPr)r+rrrr,r,r-rs z'CSSToExcelConverter._select_font_familyr"cCs^|durdS||r||Sz|j|WSty.tjdt|ttdYdSw)NzUnhandled color format: ) stacklevel) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorwarningswarnreprrrr+r"r,r,r-rs     z"CSSToExcelConverter.color_to_excel color_stringrcCst|dS)N#)r startswith)r+rr,r,r-rsz!CSSToExcelConverter._is_hex_colorcCsD|d}||r|dd|dd|ddS|S)Nrrr`r_)lstrip_is_shorthand_colorupperr+rcoder,r,r-rs  (z)CSSToExcelConverter._convert_hex_to_excelcCs8|d}t|dkr dSt|dkrdStd|)zcCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. rTFzUnexpected color )rlen ValueErrorrr,r,r-rs   z'CSSToExcelConverter._is_shorthand_colorr*)rfrgr(r))rlrmr(rn)rrrsr(rn)rrrsr(r)rrrsr(rg)rrrsr(r)rrrsr(r)r#rgrrgrrg)rrgr(rg)rrgr(r)rrr(r)rrrs)rrrsr(rz)rrrsr(r)rrrsr(r)rrr(rg)rrrsr(r)r(r')r"rgr(rg)rrr(r)rrr(r)(r/r0r1__doc__rrrrrr__annotations__r.rrirorjrprrrrrrrrrrrrrrrrrrrrrrrr,r,r,r-rJgs|            -              rJc@seZdZdZdZdZ         dDdEddZedFddZd d!Z dGd#d$Z dGd%d&Z dGd'd(Z dGd)d*Z dGd+d,ZdGd-d.ZedHd/d0ZdId3d4ZdGd5d6Zeed7d8 9 : :   dJdKdBdCZdS)LExcelFormattera9 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_formatrgcolsSequence[Hashable] | NoneheaderSequence[Hashable] | boolindexr index_labelIndexLabel | None merge_cellsinf_repstyle_converterr;r(r)c Csd|_||_t|ts!||_|j|j}| durt} | |_nd|_d|_||_ |durWt t | |j st d|S)N-tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rrisnarrisposinf_scalarrisneginf_scalarrrgetattrrrr,r,r- _format_value5s   zExcelFormatter._format_valueIterable[ExcelCell]ccs|jjdkr|jstd|js|jsdS|j}|j|jddd}t|}d}d}|jr>t |j jt r>t |j jdd}|jrt |jD]\}}t||||jdVqFt t||j|jD]B\}\}}} || } |D]1\} } d\} }| dkr||| | } }t||| d| | |jt|jdd|| |j| |d Vqoq_n+t t|D]$\} } d tt| }t||| d||jt|jdd|| |jd Vq||_dS) Nr_z]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.Fsparsifyadjoinnamesrr@NN ctx_columns r r!r"r#r6r8r9r:r$r%.r r!r"r#r6r8r9r:)rnlevelsr NotImplementedError _has_aliasesrformatr rr|rrr enumerater(rrziplevelscodestakerBr4r"rrjoinmaprr)r+r level_strs level_lengths coloffsetlnumrspansr4 level_codesvaluesispan_valr$r%rr,r,r-_format_header_miGsx          z ExcelFormatter._format_header_mic cs|js|jrgd}|jrd}t|jjtrt|jjj}|j}|jrGt t |j|_t|jt|jkrDt dt|jdt|jd|j}t |D]\}}t |j||||jt|jddd||jdVqKdSdS)Nrr_zWriting z cols but got z aliasesr*r-)r0rr r|rrrr(rr r rr2r4rrr"rr)r+r;colnamescolindexcolnamer,r,r-_format_header_regulars<   z%ExcelFormatter._format_header_regularcstjtr }n}d}jjjrFddjjjDdgtj}t ddt dd|rFfdd t |D}j d 7_ t ||S) Nr,cSsg|] }|dur |ndqSNrr,)r=xr,r,r- sz1ExcelFormatter._format_header..rcSs|o|Sr*r,)rHyr,r,r-z/ExcelFormatter._format_header..cSs|dkSrGr,)rHr,r,r-rKrLc3s&|]\}}tj||jVqdSr*)rrr)r=rDr"rr,r- s  z0ExcelFormatter._format_header..r_)r|rrrBrFrr r(rrr8r2r itertoolschain)r+gengen2r r,rr-_format_headers     zExcelFormatter._format_headercCst|jjtr |S|Sr*)r|rr r_format_hierarchical_rows_format_regular_rowsrr,r,r- _format_bodyszExcelFormatter._format_bodyc cs2|js|jr|jd7_|jr|jr%t|jtttj t fr%|jd}n|jr2t|jt r2|j}n|j jj d}t|jtrF|jd7_|rY|jdurYt|jdd||jV|j j}t|j jtrj|j j}t|D]\}}t|j|d||jt|jdd|d|jdVqnd}nd}||EdHdS)Nr_rF ctx_indexr-)r0rrr r r|r{tuplenpndarrayrrrr(rrrrr to_timestampr2r4r"rr_generate_body)r+r  index_valuesidxidxvalr;r,r,r-rTs@       z#ExcelFormatter._format_regular_rowsccs|js|jr|jd7_d}|jr|jjj}|jr)t|jtt t j t fr)|j}t|j tr9|jr9|jd7_tj|rX|jdurXt|D]\}}t|jd|||jVqG|jr|jjjdddd}t|}t||jjj|jjjD]J\}}} |j| |j|jd} |D]2\} } d\} }| dkr|j| | d} |}t|j| || | |jt|j dd| ||j!| |d Vq|d7}qun-t|jjD]&}t|D]\}}t|j||||jt|j dd|||j!d Vq|d7}q|"|EdHdS) Nr_rFTr%) allow_fill fill_valuer)rVr+r-)#r0rrr rr(r r|r{rWrXrYrrrr com any_not_noner2rrr1rr3r4r5r6 _can_hold_na _na_valuerBr4r"rrr[)r+gcolidx index_labelscidxrr9r:r=r4r>r?r@rAr$r% indexcolvalsr] indexcolvalr,r,r-rSsz      z(ExcelFormatter._format_hierarchical_rowscCs t|jS)z1Whether the aliases for column names are present.)r rrr,r,r-r0Gs zExcelFormatter._has_aliasesr;r&c csptt|jD]-}|jjdd|f}t|D]\}}t|j||||dt|j dd|||j dVqqdS)Nctxr-) rangerrrilocr2r4rr"rr)r+r;colidxseriesr@r"r,r,r-r[Ls   zExcelFormatter._generate_bodyccs4t||D] }||j|_|Vq dSr*)rNrOrRrUr#r")r+cellr,r,r-get_formatted_cells\s z"ExcelFormatter.get_formatted_cellsstorage_options)rqSheet1r sheet_namestartrowstartcol freeze_panestuple[int, int] | Noneenginerc Csddlm}|jj\} } | |jks| |jkr(td| d| d|jd|j|} t||r4d} n ||||d}d} z|j | ||||d W| rQ| d Sd S| rZ| ww) 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``, ``io.excel.xls.writer``, and ``io.excel.xlsm.writer``. .. deprecated:: 1.2.0 As the `xlwt `__ package is no longer maintained, the ``xlwt`` engine will be removed in a future version of pandas. {storage_options} .. versionadded:: 1.2.0 r) ExcelWriterz-This sheet is too large! Your sheet size is: z, z Max sheet size is: F)rxrqT)rtrurvN) pandas.io.excelryrshapemax_rowsmax_colsrrpr| _write_cellsclose) r+writerrsrtrurvrxrqrynum_rowsnum_colsformatted_cells need_saver,r,r-writeas< &    zExcelFormatter.write) rNNTTNFrN)rrrrgrrrr r rr r r rrrrr;r(r))r(r)r(r$)r(r)r;r&r(r$)rrrrNNN)rsrrtr&rur&rvrwrxrgrqrr(r))r/r0r1rr|r}r.propertyrr#rBrFrRrUrTrSr0r[rprrrr,r,r,r-rsF  .   E   .Q    r)9r __future__r functoolsrrrNrtypingrrrrr r r rnumpyrXpandas._libs.libr pandas._typingr rpandas.util._decoratorsrpandas.util._exceptionsrpandas.core.dtypesrpandas.core.dtypes.commonrrpandasrrrrpandas.core.commoncorecommonrapandas.core.shared_docsrpandas.io.formats._color_datarpandas.io.formats.cssrrpandas.io.formats.formatrpandas.io.formats.printingrrr4rJrr,r,r,r-s6 $         q