Ë
|
nñúhâ ã ó d Z ddlmZ ddlmZmZmZmZ ddlZddl Z ddl
|
Z
|
ddl m Z m Z mZmZ ddlZddlZddlmZ ddlmZ ddlmZ dd lmZ dd
|
lm Z m Z dd l m Z m Z m!Z!m"Z" ddl#m$c m%Z& dd l'm(Z( dd l)m*Z* ddl+m,Z,m-Z- ddl.m/Z/ ddl0m1Z1 e rddl2m3Z3m4Z4m5Z5m6Z6 ddl m7Z7 G d d« Z8 G d de8« Z9 G d d« Z: G d d« Z;y)zC
|
Utilities for conversion to writer-agnostic Excel representation.
|
é )Ú annotations)ÚHashableÚIterableÚMappingÚSequenceN)Ú TYPE_CHECKINGÚAnyÚCallableÚcast)Ú is_list_like)Údoc)Úfind_stack_level)Úmissing)Úis_floatÚ is_scalar)Ú DataFrameÚIndexÚ
|
MultiIndexÚ PeriodIndex)Ú _shared_docs)Ú CSS4_COLORS)Ú CSSResolverÚ
|
CSSWarning)Úget_level_lengths)Ú pprint_thing)ÚFilePathÚ
|
IndexLabelÚStorageOptionsÚWriteExcelBuffer©Ú ExcelWriterc ó6 e Zd ZdZeZ d ddZy)Ú ExcelCell©ÚrowÚcolÚvalÚstyleÚ
|
mergestartÚmergeendNc óX || _ || _ || _ || _ || _ || _ y ©Nr$ )Úselfr% r& r' r( r) r* s úJH:\Change_password\venv_build\Lib\site-packages\pandas/io/formats/excel.pyÚ__init__zExcelCell.__init__C s. ð ØØØ
|
Ø$Ø ó )NNN)
|
r% Úintr& r1 r) ú
|
int | Noner* r2 ÚreturnÚNone)Ú__name__Ú
|
__module__Ú __qualname__Ú
|
__fields__Ú __slots__r/ © r0 r. r# r# ? sL ØIJØIð Ø!%Ø #ð!à ð!ð ð!ð ð !ð ð!ð
|
ô!r0 r# c ó@ e Zd Z d fd Z xZS )Ú CssExcelCellc óÔ |rK|rI|||f D
|
ci c] \ }
|
}|
|
j « | } }
|
}t | j « « } || « }t | d|||d| ¤ y c c}}
|
w )N©r% r& r' r( r: )ÚlowerÚ frozensetÚitemsÚsuperr/ )r- r% r& r' r( Ú
|
css_stylesÚcss_rowÚcss_colÚ css_converterÚkwargsÚpropÚdeclaration_dictÚunique_declarationsÚ __class__s r. r/ zCssExcelCell.__init__U s ø ñ -ð 4>¸gÀwÐ>NÑ3O÷ Ù&/ d¨C
|
|
cÑ!ð Ð ñ ô #,Ð,<×,BÑ,BÓ,DÓ"EÐ Ù!Ð"5Ó6Eä ÑÐJS c¨s¸%ÑJÀ6ÓJùó s A$)r% r1 r& r1 r( ú dict | NonerC z3dict[tuple[int, int], list[tuple[str, Any]]] | NonerD r1 rE r1 rF úCallable | Noner3 r4 )r5 r6 r7 r/ Ú __classcell__)rK s @r. r< r< T sf ø ðKà ðKð ðKð
|
ð Kð Hð Kð ðKð ðKð 'ðKð
|
÷Kñ Kr0 r< c óÂ e Zd ZU dZeZdddddddZdddddddddddddd Zdddd Zd
|
d d d dZ dD ci c] }|j « | c}} Z de d< d.d/dZ e« Z d0dZ d0dZd1dZd2dZd3dZd4dZ d5dZd6dZd7d Zd8d Zd9d Zd:d Zd;d Z d<d!Z d4d"Z d4d#Z d=d$Z d>d%Z!d4d&Z"d=d'Z#d?d(Z$d@d)Z%dAd*Z&dBd+Z'dCd,Z(dBd-Z)yc c}} w )DÚ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__`.
|
ÚtopÚcenterÚbottom)rQ ztext-topÚmiddleÚbaselinerS z text-bottomTF) ÚboldÚbolderÚ600Ú700Ú800Ú900ÚnormalÚlighterÚ100Ú200Ú300Ú400Ú500)r\ ÚitalicÚobliqueé é é é )Úserifz
|
sans-serifÚcursiveÚfantasy)
|
ÚdashedÚ mediumDashDotÚ
|
dashDotDotÚhairÚdottedÚmediumDashDotDotÚdoubleÚdashDotÚ slantDashDotÚ mediumDashedzdict[str, str] | NoneÚ inheritedNc ó || j |« | _ nd | _ t j | j « | _ y r, )Ú compute_cssrv Ú functoolsÚcacheÚ_call_uncachedÚ _call_cached)r- rv s r. r/ z CSSToExcelConverter.__init__¾ s: Ø Ð Ø !× -Ñ -¨iÓ 8DNà !DNô &OO¨D×,?Ñ,?Ó @Õr0 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__z CSSToExcelConverter.__call__Ê s ð& × Ñ Ó.Ð.r0 c ó\ | j || j « }| j |« S r, )rx rv Ú build_xlstyle)r- r~ Ú
|
propertiess r. r{ z"CSSToExcelConverter._call_uncachedß s+ ð ×%Ñ% l°D·N±NÓC
|
Ø×!Ñ! *Ó-Ð-r0 c óÊ | j |« | j |« | j |« | j |« | j |« d}dfd |« |S )N)Ú alignmentÚborderÚfillÚfontÚ number_formatc ó t | j « « D ]* \ }}|| |= t |t « s |« |r(| |= , y)z4Remove key where value is None, through nested dictsN)ÚlistrA Ú
|
isinstanceÚdict)ÚdÚkÚvÚ remove_nones r. r z6CSSToExcelConverter.build_xlstyle.<locals>.remove_noneð sG ø ä QWWYò !1Ø9Ø!Ü ¤4Õ(Ù NÚ Ø aDñ !r0 )r údict[str, str | None]r3 r4 )Úbuild_alignmentÚ build_borderÚ
|
build_fillÚ
|
build_fontÚbuild_number_format)r- ÚpropsÚoutr s @r. r z!CSSToExcelConverter.build_xlstyleå s` ø à ×-Ñ-¨eÓ4Ø×'Ñ'¨Ó.ØOO EÓ*ØOO EÓ*Ø !× 5Ñ 5°eÓ <ñ
|
õ !ñ CÔØ
|
r0 c óh |j d« | j |« | j |« dS )Nz
|
text-align)Ú
|
horizontalÚverticalÚ wrap_text)ÚgetÚ_get_vertical_alignmentÚ_get_is_wrap_text©r- r s r. r z#CSSToExcelConverter.build_alignmentý s6 ð )) LÓ1Ø ×4Ñ4°UÓ;Ø ×/Ñ/°Ó6ñ
|
ð
|
r0 c ó` |j d« }|r| j j |« S y )Nzvertical-align)r Ú VERTICAL_MAP)r- r Úvertical_aligns r. r z+CSSToExcelConverter._get_vertical_alignment s. Ø Ð#3Ó4Ù Ø×$Ñ$×(Ñ(¨ Ó8Ð 8Ør0 c óF |j d« y t |d dv« S )Nz white-space)ÚnowrapÚprezpre-line)r Úboolr s r. r z%CSSToExcelConverter._get_is_wrap_text s* Ø 99]Ó #Ð +ØÜE-Ñ(Ð0MÐMÓNÐNr0 c ó* dD ci c] }|| j |j d| d« |j d| d« | j |j d| d« « « | j |j d| d« « d
c}S c c}w )N©rQ ÚrightrS Úleftzborder-z-stylez-widthz-color)r( Úcolor)Ú _border_styler Úcolor_to_excel)r- r Úsides r. r z CSSToExcelConverter.build_border sª ð ;ö
|
|
ð ð Ø ×+Ñ+ØII ¨ v¨VÐ 4Ó5ØII ¨ v¨VÐ 4Ó5Ø×'Ñ'¨¯ © °G¸D¸6ÀÐ2HÓ(IÓJóð
|
×,Ñ,¨U¯Y©Y¸ÀÀÀfÐ7MÓ-NÓOñ ñ ò
|
|
ð
|
|
ùò
|
|
s
BBc ó, |||y ||y|dv ry| j |« }|y|dv r|S |dk( ry|dk( r|dv ryy|dk( r|dv ryy || j v r| j | S t j d
|
t |« t
|
t « ¬ « y) NÚnone)r± Úhidden)NÚgrooveÚridgeÚinsetÚoutsetÚsolidrr rp )ro Úthinrq rl ru z Unhandled border style format: ©Ú
|
stacklevel)Ú_get_width_nameÚBORDER_STYLE_MAPÚwarningsÚwarnÚreprr r )r- r( Úwidthr¬ Ú
|
width_names r. r z!CSSToExcelConverter._border_style sÔ ð =U]¨u¨}àà =U]àà Ð&Ñ &Øà×)Ñ)¨%Ó0
|
Ø Ð Øà ÐIÑ Ià Ð à HÒ ØØ HÒ ØÐ -Ñ-Ø Ø%Ø HÒ ØÐ -Ñ-Ø Ø!Ø d×+Ñ+Ñ +à×(Ñ(¨Ñ/Ð /ä MMØ1´$°u³+° Ð?ÜÜ+Ó-õ ð
|
r0 c óJ | j |« }|dk ry |dk ry|dk ryy)Ngñhãµøä>gÍÌÌÌÌÌô?r¸ gffffff@ÚmediumÚthick)Ú_width_to_float)r- Ú width_inputrÀ s r. r» z#CSSToExcelConverter._get_width_nameV s3 Ø×$Ñ$ [Ó1Ø 4<ØØ S[ØØ S[ØØr0 c ó, |d}| j |« S )NÚ2pt)Ú _pt_to_float)r- rÀ s r. rÅ z#CSSToExcelConverter._width_to_float` s Ø =ØEØ× Ñ Ó'Ð'r0 c ó\ |j d« sJ t |j d« « S )NÚpt)ÚendswithÚfloatÚrstrip)r- Ú pt_strings r. rÉ z CSSToExcelConverter._pt_to_floate s, Ø×!Ñ! $Ô'Ð'Ð'ÜY×%Ñ% dÓ+Ó,Ð,r0 c óV |j d« }|dvr| j |« ddS y )Nzbackground-color)NÚ transparentr± r· )ÚfgColorÚ patternType)r r® )r- r Ú
|
fill_colors r. r z CSSToExcelConverter.build_filli s7 ð YYÐ 1Ó2
|
Ø Ð :Ñ :Ø #× 2Ñ 2°:Ó >ÈwÑWÐ Wð ;r0 c ót |j d« }t |t « r|j dd« n|}d|iS )Nz number-formatõ §ú;Ú format_code)r r ÚstrÚreplace)r- r Úfcs r. r z'CSSToExcelConverter.build_number_formatp s6 Ø YYÓ 'Ü&0°´SÔ&9RZZcÔ "¸rØ rÐ"Ð"r0 c óV | j |« }| j |« }|r|d nd | j |« | j |« | j |« | j |« d|v rdnd d|v xs d | j |j d« « | j |« d S )Nr Ú underlineÚsinglez line-throughr¬ ) ÚnameÚfamilyÚsizerV rc rÝ Ústriker¬ Úshadow) Ú_get_font_namesÚ_get_decorationÚ_select_font_familyÚ_get_font_sizeÚ _get_is_boldÚ_get_is_italicr® r Ú _get_shadow)r- r Ú
|
font_namesÚ
|
decorations r. r z CSSToExcelConverter.build_fontu s¯ ð ×)Ñ)¨%Ó0
|
Ø×)Ñ)¨%Ó0
|
á%/JqM°TØ×.Ñ.¨zÓ:Ø×'Ñ'¨Ó.Ø×%Ñ% eÓ,Ø×)Ñ)¨%Ó0Ø&1°ZÑ&?(ÀTØ%¨Ð3Ò<¸Ø×(Ñ(¨¯©°7Ó);Ó<à×&Ñ& uÓ-ñ
|
ð
|
r0 c ó` |j d« }|r| j j |« S y )Nz font-weight)r ÚBOLD_MAP)r- r Úweights r. rè z CSSToExcelConverter._get_is_bold s+ Ø=Ó)Ù Ø==×$Ñ$ VÓ,Ð ,Ør0 c ó` |j d« }|r| j j |« S y )Nz
|
font-style)r Ú
|
ITALIC_MAP)r- r Ú
|
font_styles r. ré z"CSSToExcelConverter._get_is_italic s+ ØYY|Ó,
|
Ù Ø??×&Ñ& zÓ2Ð 2Ør0 c óJ |j d« }||j « S y)Nztext-decorationr: )r Úsplit)r- r rì s r. rå z#CSSToExcelConverter._get_decoration s) ØYYÐ 0Ó1
|
Ø Ð !Ø ×#Ñ#Ó%Ð %àr0 c ó d|v ryy )NrÝ rÞ r: )r- rì s r. Ú_get_underlinez"CSSToExcelConverter._get_underline s Ø *Ñ $ØØr0 c óP d|v r"t t j d|d « « S y )Nz text-shadowz ^[^#(]*[1-9])r§ ÚreÚsearchr s r. rê z CSSToExcelConverter._get_shadow s( Ø EÑ !Ü .°%¸ Ñ2FÓGÓHÐ HØr0 c ó$ t j d|j dd« « }g }|D ]b }|d d dk( r|dd j dd« }n.|d d dk( r|dd j d d« }n|j « }|sR|j |« d |S )
|
Nz(?x)
|
(
|
"(?:[^"]|\\")+"
|
|
|
'(?:[^']|\\')+'
|
|
|
[^'",]+
|
)(?=,|\s*$)
|
z font-familyÚ re ú"éÿÿÿÿz\"ú'z\')rø Úfindallr rÚ ÚstripÚappend)r- r Úfont_names_tmprë rß s r. rä z#CSSToExcelConverter._get_font_names¤ s© Üð ð IIm RÓ (ó
|
ð
|
Ø"ò (DØBQx3ØAbz×)Ñ)¨%°Ó5ØbqS ØAbz×)Ñ)¨%°Ó5àzz|ÚØ×!Ñ! $Õ'ð (ð Ðr0 c óN |j d« }||S | j |« S )Nz font-size)r rÉ )r- r rá s r. rç z"CSSToExcelConverter._get_font_size¾ s+ ØyyÓ%Ø <ØKØ× Ñ Ó&Ð&r0 c óX d }|D ]" }| j j |« }|s! |S |S r, )Ú
|
FAMILY_MAPr )r- rë rà rß s r. ræ z'CSSToExcelConverter._select_font_familyÄ s< ØØ ò DØ__×(Ñ(¨Ó.FÚØà ð ð
|
r0 c óê |y | j |« r| j |« S | j | S # t $ r3 t j
|
dt |« t t « ¬« Y y w xY w)NzUnhandled color format: r¹ ) Ú _is_hex_colorÚ_convert_hex_to_excelÚ NAMED_COLORSÚKeyErrorr½ r¾ r¿ r r ©r- r' s r. r® z"CSSToExcelConverter.color_to_excelÍ sv Ø ;Øà × Ñ cÔ "Ø×-Ñ-¨cÓ2Ð 2ð Ø×$Ñ$ SÑ)Ð )øÜò Ü MMØ*¬4°«9¨+Ð6ÜÜ+Ó-ö ð
|
ð ús §6 ¶9A2Á1A2c ó6 t |j d« « S )Nú#)r§ Ú
|
startswith)r- Ú color_strings r. r z!CSSToExcelConverter._is_hex_colorÞ s ÜL×+Ñ+¨CÓ0Ó1Ð1r0 c ó¶ |j d« }| j |« r(|d dz |d dz z |d dz z j « S |j « S )Nr r rf re )ÚlstripÚ_is_shorthand_colorÚupper©r- r Úcodes r. r z)CSSToExcelConverter._convert_hex_to_excelá s] Ø×"Ñ" 3Ó'Ø × #Ñ # LÔ 1ØGaK $ q¡'¨A¡+Ñ-°°Q±¸!± Ñ;×BÑBÓDÐ Dà::<Ð r0 c ó| |j d« }t |« dk( ryt |« dk( ryt d| « )zcCheck if color code is shorthand.
|
|
#FFF is a shorthand as opposed to full #FFFFFF.
|
r é Té FzUnexpected color )r ÚlenÚ
|
ValueErrorr s r. r z'CSSToExcelConverter._is_shorthand_colorè sC ð
|
×"Ñ" 3Ó'Ü t9>ØÜ Y!^Øä Ð 0° °Ð ?Ó@Ð @r0 r, )rv ú
|
str | Noner3 r4 )r~ z str | frozenset[tuple[str, str]]r3 údict[str, dict[str, str]])r úMapping[str, str]r3 r )r r r3 z dict[str, bool | str | None])r r r3 r )r r r3 z bool | None)r r r3 z dict[str, dict[str, str | None]])r( r rÀ r r¬ r )rÆ r r3 r )rÀ r r3 rÍ )rÏ rÙ r3 rÍ )r r )r r r3 r )r r r3 z$dict[str, bool | float | str | None])r r r3 ú Sequence[str])rì r r3 r )r r r3 z float | None)rë r r3 r2 )r' r r3 r )r rÙ r3 r§ )r rÙ r3 rÙ )*r5 r6 r7 Ú__doc__r r r¢ rî rñ r r? r¼ Ú__annotations__r/ r rx r r{ r r r r r r r» rÅ rÉ r r r rè ré rå rö rê rä rç ræ r® r r r )Ú.0r( s 00r. rP rP m s
ñð" Lð ØØØ ØØ ñ Lð ØØØØØØØØØØØØñHð" ØØñJð ØØØñ Jð
|
÷à ð uÑ óÐð( %Ó$ôAñ -Kð/Ø <ð/à "ó/ð*.Ø <ð.à "ó.ó ó0
|
óó Oð
|
|
Ø&ð
|
à )ó
|
ó 5ónó(ó
|
-óXó#ð
|
|
Ø&ð
|
à -ó
|
ó$ó ó óó
|
ó
|
ó4'ó óó"2ó ô AùóA
|
s µCrP c ó e Zd ZdZdZdZ d ddZedd« Zd Z ddZ
|
dd Z dd
|
Z dd Z dd Zdd Zedd« ZddZddZ eed ¬« d dd« Zy) Ú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.
|
i i @ Nc ó² d| _ || _ t |t « sA|| _ | j j « |j }|
|
|
t « }
|
|
|
| _ nd | _ d | _ || _ |t t |« j |j « « s t d« t t |« j |j « « t t |« « k7 r t d« |j! |¬« | _ | j j | _ || _ || _ || _ || _ || _ | | _ y )Nr z,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)Úcolumns)Ú
|
rowcounterÚna_repr r ÚstylerÚ_computeÚdatarP Ústyle_converterÚdfr r Ú intersectionr% r
|
ÚsetÚreindexÚ float_formatÚindexÚ index_labelÚheaderÚ merge_cellsÚinf_rep) r- r, r' r0 Úcolsr3 r1 r2 r4 r5 r+ s r. r/ zExcelFormatter.__init__ s ð Ø Ü"iÔ(Ø DKØ KK× Ñ Ô "ØBØ Ð&Ü"5Ó"7Ø4CDÕ à DKØ#'DÔ ØØ Ð äuT{×/Ñ/°·
|
±
|
Ó;Ô<Ü Ð MÓNÐNä5;×+Ñ+¨B¯J©JÓ7Ó8¼CÄÀDÃ »NÒJä Ð OÓPÐPàjj¨jÓ.DGàww Ø (ÔØ
|
Ø&ÔØ Ø&ÔØ r0 c ó" ddidddddddddS ) NrV Tr¸ r© rR rQ )r r )r Úbordersr r: ©r- s r. Ú header_stylezExcelFormatter.header_styleG s0 ð TNà Ø Ø Ø ñ ð )1¸eÑDñ
|
ð
|
r0 c ó| t |« r"t j |« r | j }nvt |« rkt j
|
|« r | j }nIt j |« rd| j }n$| j t | j |z « }t |dd « t d« |S )Nú-Útzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) r r Úisnar' r Úisposinf_scalarr5 Úisneginf_scalarr0 rÍ Úgetattrr r s r. Ú _format_valuez ExcelFormatter._format_valueT s£ Ü S>gll¨3Ô /Ø++CÜ c]Ü×&Ñ& sÔ+ØllÜ×(Ñ(¨Ô-Ø$,, Ð(Ø×"Ñ"Ð.ÜD× -Ñ -°Ñ 3Ó4Ü 3 $Ó 'Ð 3Ü ð@óð ð
|
|
r0 c # óÎ K | j j dkD r| j s t d« | j s | j
|
sy | j }|j | j d¬« }t |« }d}d}| j rIt | j j t « r%t | j j d « dz
|
}| j rüt |j « D ] \ }}t |||| j ¬« " t t# ||j$ |j& « « D ] \ }\ }}} |j) | « }
|
|j+ « D ]b \ } } d\ } }| dkD r
|
||| z | z }} t- ||| z dz |
|
| | j t/ | j0 dd « || | j2 | |¬ «
|
d || _ y t t# | « D ]h \ } }
|
d
|
j5 t7 t8 |
|
« « }t- ||| z dz || j t/ | j0 dd « || | j2 ¬ « j || _ y w) Nre z]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.F©ÚsparsifyÚ include_namesr r> ©NNÚ ctx_columns©
|
r% r& r' r( rC rD rE rF r) r* ú.©r% r& r' r( rC rD rE rF ) r% Únlevelsr1 ÚNotImplementedErrorÚ _has_aliasesr3 Ú _format_multir4 r r r, r r Ú enumerateÚnamesr# r: ÚzipÚlevelsÚcodesÚtakerA r< rA r( r+ ÚjoinÚmapr r& )r- r% Ú
|
level_strsÚ level_lengthsÚ coloffsetÚlnumrß ÚspansrS Ú level_codesÚvaluesÚiÚspan_valr) r* r s r. Ú_format_header_miz ExcelFormatter._format_header_mif s_ è ø Ø <<× Ñ !Ò #Ø::Ü)ðDóð ð
|
×!Ò! T§[¢[Ø à,,Ø ×*Ñ*Ø×%Ñ%°Uð +ó
|
|
ô *¨*Ó5 Ø Øà ::* T§W¡W§]¡]´JÔ?ÜDGGMM¨!Ñ ,Ó-°Ñ1Ià × Ò ä '¨¯ © Ó 6ò
|
dÜ Ø Ø!Ø Ø ×+Ñ+ô ó ð ô 7@ÜM 7§>¡>°7·=±=ÓAó7ò Ñ2Ñ2uf kð [Ó1Ø#(§;¡;£=ò KAxØ+5Ñ(J Ø !|Ø/3°YÀ±]ÀXÑ5M H
|
Ü&Ø Ø %¨M¨AÑ -Ø " 1IØ "× /Ñ /Ü#*¨4¯;©;¸ ÀtÓ#LØ $Ø !Ø&*×&:Ñ&:Ø#-Ø!)ô ó ñ ð ðF ô '¤s¨JÐ'7Ó 8ò 6ØHHS¤ ¨vÓ 6Ó7Ü"Ø Ø! A ¨Ñ)ØØ ×+Ñ+Ü & t§{¡{°MÀ4Ó HØ Ø Ø"&×"6Ñ"6ô ó ð ð ùs I#I%c # ó K | j s | j rbd}| j rOd}t | j j t
|
« r)t | j j j « }| j }| j rt t | j « | _ t | j « t | j « k7 r8t dt | j « dt | j « d« | j }t |« D ]P \ }}t | j ||z || j t! | j" dd « d|| j$ ¬« R y y w)Nr re zWriting z cols but got z aliasesrH rK )rN r3 r1 r r, r r rQ r% r r r rP r< r& r: rA r( r+ )r- rZ ÚcolnamesÚcolindexÚcolnames r. Ú_format_header_regularz%ExcelFormatter._format_header_regular« s7 è ø Ø × Ò § £ ØIàzzØ Ü dggmm¬ZÔ8Ü # D§G¡G§M¡M×$7Ñ$7Ó 8Ià||HØ× Ò Ü "¤8¨T¯[©[Ó 9 Üt{{Ó#¤s¨4¯<©<Ó'8Ò8Ü$Ø"¤3 t§|¡|Ó#4Ð"5ð 6#Ü#& t§{¡{Ó#3Ð"4°Hð>óð ð ;;ä%.¨xÓ%8ò
|
Ñ!'Ü"Ø Ø 9Ñ,Ø Ø ×+Ñ+Ü & t§{¡{°MÀ4Ó HØ Ø $Ø"&×"6Ñ"6ô ó ñ
|
ð% !,ùs E=E?c ó t j t « r j « }n j « }d} j
|
j j r j
|
j j D cg c] }||nd
|
c}dgt j « z z }t j d d |D « « r) fdt |« D « } xj dz c_ t j ||« S c c}w )Nr: rû c ó | xr |S r, r: )ÚxÚys r. ú<lambda>z/ExcelFormatter._format_header.<locals>.<lambda>Ø s
|
¨QªW°1 r0 c 3 ó& K | ] }|d k7 yw)rû Nr: )r! ri s r. ú <genexpr>z0ExcelFormatter._format_header.<locals>.<genexpr>Ø s è ø Ò6LÀ1°q¸BµwÑ6Lùs c 3 óh K | ]) \ }}t j ||j « + y wr, )r# r& r: )r! rd r' r- s r. rm z0ExcelFormatter._format_header.<locals>.<genexpr>Ù s2 øè ø ò á% #ô doo¨x¸¸d×>OÑ>O×Pñùs /2re )r r% r ra rf r, r1 rQ r ry ÚreducerP r& Ú itertoolsÚchain)r- ÚgenÚgen2ri r% s ` r. Ú_format_headerz ExcelFormatter._format_headerÊ sß ø ô dll¤JÔ /Ø×(Ñ(Ó*Cà×-Ñ-Ó/Cà$&à 77==× Ò Ø7;·w±w·}±}×7JÑ7JÖK°! 1¨2Ñ-ÒKØðOäDLLÓ!ñO"ñ "Cô × Ñ Ñ 4Ñ6LÈÔ6LÔMóä)2°3« ôð 1Ñ$Üs DÓ)Ð)ùò Ls  Dc ó t | j j t « r| j « S | j « S r, )r r, r1 r Ú_format_hierarchical_rowsÚ_format_regular_rowsr9 s r. Ú _format_bodyzExcelFormatter._format_bodyà s2 Ü dggmm¤ZÔ 0Ø×1Ñ1Ó3Ð 3à×,Ñ,Ó.Ð .r0 c # óP K | j s | j r| xj dz c_ | j rË| j rDt | j t t t j t f« r| j d }nV| j r't | j t « r | j }n#| j j j d }t | j t « r| xj dz c_ |r5| j dur't! | j dz
|
d|| j" « | j j }t | j j t$ « r$| j j j' « }t) |« D ]P \ }}t+ | j |z d|| j" t- | j. dd « |d| j0 ¬« R d}nd}| j3 |« E d { y 7 w)Nre r FÚ ctx_indexrK )rN r3 r& r1 r2 r r ÚtupleÚnpÚndarrayr rÙ r, rQ r% r r# r: r Ú to_timestamprP r< rA r( r+ Ú_generate_body)r- r2 Ú index_valuesÚidxÚidxvalrZ s r. rw z#ExcelFormatter._format_regular_rowsæ s£ è ø Ø × Ò § ¢ Ø OOqÑ Oð ::ð × Ò ¤JØ× Ñ ¤4¬´·
|
±
|
¼EÐ"Bô%ð #× .Ñ .¨qÑ 1 à×!Ò!¤j°×1AÑ1AÄ3Ô&GØ "× .Ñ . à "ggmm× 1Ñ 1°!Ñ 4 ä$,,¬
|
Ô3Ø 1Ñ$át{{°%Ñ 7Ü §¡°!Ñ 3°Q¸ ÀT×EVÑEVÓWÒWð 77==LÜ$''--¬Ô5Ø #ww}}× 9Ñ 9Ó ; ä (¨ Ó 6ò
|
VÜ"Ø ¨#Ñ-ØØ Ø ×+Ñ+Ü & t§{¡{°KÀÓ FØ Ø Ø"&×"6Ñ"6ô ó ð
|
ð IàIà×&Ñ& yÓ1×1Ò1ús H H&È H$È H&c # óT K | j s | j r| xj dz c_ d}| j rÍ| j j j
|
}| j r@t | j t t t j t f« r | j }t | j t « r!| j r| xj dz c_ t! j" | rH| j dur:t% |« D ], \ }}t' | j dz
|
||| j( « . | j r;| j j j+ dd¬« }t- |« }t/ || j j j0 | j j j2 « D ]¼ \ }}} |j5 | |j6 |j8 ¬« }
|
|j; « D ]v \ } } d\ } }| dkD r| j | z | z dz
|
} |}t= | j | z ||
|
| | j( t? | j@ dd « | || jB | |¬ «
|
x |dz }¾ nt/ | j j D ]e }t% |« D ]P \ }}t= | j |z ||| j( t? | j@ dd « ||| jB ¬
|
« R |dz }g | jE |« E d { y 7 w) Nre r FTrD )Ú
|
allow_fillÚ
|
fill_valuerG rz rI rK )#rN r3 r& r1 r, rQ r2 r r r{ r| r} r r% r r4 ÚcomÚ any_not_nonerP r# r: rO r rR rS rT rU Ú _can_hold_naÚ _na_valuerA r< rA r( r+ r )r- ÚgcolidxÚ index_labelsÚcidxrß rX rY r\ rS r] r^ r_ r` r) r* Ú indexcolvalsr Ú indexcolvals r. rv z(ExcelFormatter._format_hierarchical_rows s× è ø Ø × Ò § ¢ Ø OOqÑ Oàà ::Ø 77==×.Ñ.Là× Ò ¤JØ× Ñ ¤4¬´·
|
±
|
¼EÐ"Bô%ð $× /Ñ / ô $,,¬
|
Ô3¸×8HÒ8HØ 1Ñ$ô × Ñ Ñ.°4·;±;ÀeÑ3KÜ"+¨LÓ"9ò XJD$Ü# D§O¡O°aÑ$7¸¸tÀT×EVÑEVÓWÓWðXð × Ó à !WW]]× 8Ñ 8Ø !°ð 9ó
|
ô !2°*Ó = ä25Ø! 4§7¡7§=¡=×#7Ñ#7¸¿¹¿ ¹ ×9LÑ9Ló3ò !Ñ.E6 ;ð $[[Ø#Ø#)×#6Ñ#6Ø#)×#3Ñ#3ð )ó Fð (-§{¡{£}ò 8Ø/9Ñ,
|
HØ# a<Ø)-¯ © ¸1Ñ)<¸xÑ)GÈ!Ñ)KJØ'.HÜ *Ø $§¡°!Ñ 3Ø 'Ø & q¡ Ø"&×"3Ñ"3Ü'.¨t¯{©{¸KÈÓ'NØ$%Ø$+Ø*.×*>Ñ*>Ø'1Ø%-ô ó ð ð" qLGñ5!ô< %(¨¯©¯ © Ð$7ò !LÜ,5°lÓ,Cò
|
Ñ([Ü *Ø $§¡°#Ñ 5Ø 'Ø +Ø"&×"3Ñ"3Ü'.¨t¯{©{¸KÈÓ'NØ$'Ø$+Ø*.×*>Ñ*>ô ó ð
|
ð qLGð !ð ×&Ñ& wÓ/×/Ò/ús L L(Ì L&Ì!L(c ó, t | j « S )z1Whether the aliases for column names are present.)r r3 r9 s r. rN zExcelFormatter._has_aliasesc s ô DKKÓ(Ð(r0 c # ó: K t t | j « « D ]v }| j j d d
|f }t |« D ]I \ }}t | j |z ||z |d t | j dd « ||| j ¬« K x y w)NÚctxrK ) Úranger r% r, ÚilocrP r< r& rA r( r+ )r- rZ ÚcolidxÚseriesr_ r' s r. r z ExcelFormatter._generate_bodyh s è ø äC § ¡ Ó -Ó.ò FØWW\\¢! V )Ñ,FÜ# FÓ+ò
|
3Ü"Ø ¨!Ñ+Ø Ñ*ØØ Ü & t§{¡{°E¸4Ó @Ø Ø "Ø"&×"6Ñ"6ô ó ñ
|
ñ ùs BBc # óÂ K t j | j « | j « « D ]& }| j |j
|
« |_ | ( y wr, )rp rq rt rx rB r' )r- Úcells r. Úget_formatted_cellsz"ExcelFormatter.get_formatted_cellsx sM è ø Ü OO D×$7Ñ$7Ó$9¸4×;LÑ;LÓ;NÓOò DØ×)Ñ)¨$¯(©(Ó3DHØJñ ùs A A Ústorage_options)r c
|
óº ddl m} | j j \ }
|
} |
|
| j kD s| | j
|
kD r+t d|
|
d| d| j d| j
|
« |i }| j « } t || « rd} n | ||||¬« }d } |j | ||||¬
|
« | r|j « yy# | r|j « w w xY w) ab
|
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}
|
|
engine_kwargs: dict, optional
|
Arbitrary keyword arguments passed to excel engine.
|
r r z-This sheet is too large! Your sheet size is: z, z Max sheet size is: NF)Úenginer Ú engine_kwargsT)ÚstartrowÚstartcolÚ freeze_panes) Úpandas.io.excelr! r, ÚshapeÚmax_rowsÚmax_colsr r r Ú _write_cellsÚclose)r- ÚwriterÚ
|
sheet_namer r r r r r r! Únum_rowsÚnum_colsÚformatted_cellsÚ need_saves r. ÚwritezExcelFormatter.write} sý õD 0à !WW]]Ñ(Ø dmmÒ # x°$·-±-Ò'?Ü Ø?À¸zÈÈHÈ:ð V&Ø&*§m¡m _°B°t·}±}°oðGóð ð
|
Ð Ø Mà ×2Ñ2Ó4Ü fkÔ *Ø Iá ØØ Ø /Ø +ô Fð Ið Ø × Ñ Ø ØØ!Ø!Ø )ð ô ñ Ø ð øyØ ð ús ÂC ÃC) rû NNTTNFÚinfN)r' rÙ r0 r r6 zSequence[Hashable] | Noner3 zSequence[Hashable] | boolr1 r§ r2 zIndexLabel | Noner4 r§ r5 rÙ r+ rM r3 r4 )r3 z dict[str, dict[str, str | bool]])r3 úIterable[ExcelCell])r3 r§ )rZ r1 r3 r® )ÚSheet1r r NNNN)r¦ z)FilePath | WriteExcelBuffer | ExcelWriterr§ rÙ r r1 r r1 r ztuple[int, int] | Noner r r zStorageOptions | Noner rL r3 r4 )r5 r6 r7 r r¢ r£ r/ Úpropertyr: rB ra rf rt rx rw rv rN r r r r r¬ r: r0 r. r# r# ö s ñ ð@ HØHð
|
Ø#'Ø*.Ø,0ØØ)-Ø !Ø Ø+/ð+ ð ð+ ð !ð + ð
|
(ð + ð *ð + ð ð+ ð 'ð+ ð ð+ ð ð+ ð )ð+ ð
|
ó+ ðZ ò
|
|
ó ð
|
|
òó$C óJ ó>*ó,/ó ,2ó\M0ð^ ò)ó ð)óó ñ
|
Ð&7Ñ8Ô9ð #ØØØ/3Ø !Ø15Ø%)ðD à9ðD ð ðD ð ð D ð
|
ð D ð -ð D ð ðD ð /ðD ð #ðD ð
|
òD ó :ñD r0 r# )<r Ú
|
__future__r Úcollections.abcr r r r ry rp rø Útypingr r r
|
r r½ Únumpyr| Úpandas._libs.libr Úpandas.util._decoratorsr Úpandas.util._exceptionsr Úpandas.core.dtypesr Úpandas.core.dtypes.commonr r Úpandasr r r r Úpandas.core.commonÚcoreÚcommonr Úpandas.core.shared_docsr Ú pandas.io.formats._color_datar Úpandas.io.formats.cssr r Úpandas.io.formats.formatr Úpandas.io.formats.printingr Úpandas._typingr r r r r! r# r< rP r# r: r0 r. ú<module>rÄ s± ðñõ #÷ó ó Û Û ÷ó ó ã å )Ý 'Ý 4å &÷÷
|
ó ÷ !Ð Ý 0å 5÷õ 7Ý 3á÷ó õ #÷!ñ !ô*K9ô K÷2FAñ FA÷R L ò L r0
|
