U
|
¬ý°d ã @ s\ d Z ddlmZ ddlmZmZ ddlZddlZddlm Z m
|
Z
|
m Z m Z m Z mZmZ ddlZddlZddlmZ ddlmZmZ ddlmZ dd lmZ dd
|
l m Z dd l m Z m 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/m0Z0 ddl1m2Z2 ddl3m4Z4 G dd dZ5G dd de5Z6G dd dZ7G dd dZ8dS )zC
|
Utilities for conversion to writer-agnostic Excel representation.
|
é )Ú annotations)Ú lru_cacheÚreduceN)ÚAnyÚCallableÚHashableÚIterableÚMappingÚSequenceÚcast)Ú is_list_like)Ú
|
IndexLabelÚStorageOptions)Údoc)Úfind_stack_level)Úmissing)Úis_floatÚ is_scalar)Ú DataFrameÚIndexÚ
|
MultiIndexÚ PeriodIndex)Ú _shared_docs)Ú CSS4_COLORS)Ú CSSResolverÚ
|
CSSWarning)Úget_level_lengths)Ú pprint_thingc @ s, e Zd ZdZeZd ddddddddZdS )
|
Ú ExcelCell©ÚrowÚcolÚvalÚstyleÚ
|
mergestartÚmergeendNÚintú
|
int | NoneÚNone)r r! r$ r% Úreturnc C s( || _ || _|| _|| _|| _|| _d S ©Nr )Úselfr r! r" r# r$ r% © r, úNd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/io/formats/excel.pyÚ__init__= s zExcelCell.__init__)NNN)Ú__name__Ú
|
__module__Ú __qualname__Z
|
__fields__Ú __slots__r. r, r, r, r- r 9 s ùr c s0 e Zd Zddddddddd fdd Z ZS ) Ú CssExcelCellr& z dict | Nonez3dict[tuple[int, int], list[tuple[str, Any]]] | NoneúCallable | Noner( )r r! r# Ú
|
css_stylesÚcss_rowÚcss_colÚ css_converterr) c sR |r2|r2dd |||f D }
|
t |
|
¡ } || }t jf ||||d| d S )Nc S s i | ]\}}| ¡ |qS r, ©Úlower)Ú.0Úpropr" r, r, r- Ú
|
<dictcomp>] s z)CssExcelCell.__init__.<locals>.<dictcomp>©r r! r" r# )Ú frozensetÚitemsÚsuperr. ) r+ r r! r" r# r5 r6 r7 r8 ÚkwargsZdeclaration_dictZunique_declarations©Ú __class__r, r- r. O s
|
ÿ zCssExcelCell.__init__)r/ r0 r1 r. Ú __classcell__r, r, rC r- r3 N s r3 c @ s. e Zd ZU dZeZdddddddZdddddddddddddd Zdddd Zd
|
d d d dZ dd dD Z
|
de d< dgdddddZ e Zddd d d Zddd d d Zd!dd"d#d$Zd!d%d"d&d'Zd!dd"d(d)Zd!d*d"d+d,Zd!d-d"d.d/Zdddd0d1d2Zddd3d4d5Zdd6d7d8d9Zd:d6d;d<d=Zd!d>d?d@Zd!dAd"dBdCZd!dDd"dEdFZ d!d*d"dGdHZ d!d*d"dIdJZ d!dKd"dLdMZ dKddNdOdPZ d!d*d"dQdRZ!d!dKd"dSdTZ"d!dUd"dVdWZ#dXdYdZd[Z$ddd\d]d^Z%d:d_d`dadbZ&d:d:d`dcddZ'd:d_d`dedfZ(dS )hÚ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)rG ztext-topZmiddleZbaselinerI z text-bottomTF) ÚboldZbolderZ600Z700Z800Z900ÚnormalZlighterZ100Z200Z300Z400Ú500)rK ÚitalicZobliqueé é é é )Zserifz
|
sans-serifZcursiveZfantasyc C s i | ]}| ¡ |qS r, r9 )r; r# r, r, r- r= ¢ s ÿ z CSSToExcelConverter.<dictcomp>)
|
ÚdashedZ mediumDashDotZ
|
dashDotDotÚhairÚdottedÚmediumDashDotDotÚdoubleZdashDotZ slantDashDotÚ mediumDashedzdict[str, str] | NoneÚ inheritedNú
|
str | Noner( )rX r) c C s2 |d k r| |¡| _nd | _td d| j| _d S )N)Úmaxsize)Ú compute_cssrX r Ú_call_uncachedÚ _call_cached)r+ rX r, r, r- r. ¸ s z CSSToExcelConverter.__init__z str | frozenset[tuple[str, str]]zdict[str, dict[str, str]])Ú declarationsr) c C s
|
| |¡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+ r^ r, r, r- Ú__call__Ä s z CSSToExcelConverter.__call__c C s | || j¡}| |¡S r* )r[ rX Ú build_xlstyle)r+ r^ Z
|
propertiesr, r, r- r\ Ù s z"CSSToExcelConverter._call_uncachedzMapping[str, str])Úpropsr) c sN | |¡| |¡| |¡| |¡| |¡d}ddd fdd | |S )N)Ú alignmentZborderÚfillÚfontZ number_formatúdict[str, str | None]r( )Údr) c sF t | ¡ D ]4\}}|dkr$| |= q t|tr | |s | |= q dS )z4Remove key where value is None, through nested dictsN)Úlistr@ Ú
|
isinstanceÚdict)rf ÚkÚv©Ú remove_noner, r- rm ê s
|
z6CSSToExcelConverter.build_xlstyle.<locals>.remove_none)Úbuild_alignmentÚ build_borderÚ
|
build_fillÚ
|
build_fontÚbuild_number_format)r+ ra Úoutr, rl r- r` ß s û
|
|
z!CSSToExcelConverter.build_xlstylez dict[str, bool | str | None]c C s | d¡| |¡| |¡dS )Nz
|
text-align)Ú
|
horizontalÚverticalÚ wrap_text)ÚgetÚ_get_vertical_alignmentÚ_get_is_wrap_text©r+ ra r, r, r- rn ÷ s ýz#CSSToExcelConverter.build_alignmentc C s | d¡}|r| j |¡S d S )Nzvertical-align)rw Ú VERTICAL_MAP)r+ ra Zvertical_alignr, r, r- rx ÿ s
|
z+CSSToExcelConverter._get_vertical_alignmentz bool | Nonec C s" | d¡d krd S t|d dkS )Nz white-space)ZnowrapÚprezpre-line)rw Úboolrz r, r, r- ry s z%CSSToExcelConverter._get_is_wrap_textz dict[str, dict[str, str | None]]c s fdddD S )Nc sf i | ]^}| d | d¡ d | d¡ d | d¡¡¡ d | d¡¡dqS )zborder-z-stylez-widthz-color)r# Úcolor)Ú _border_stylerw Úcolor_to_excel)r; Zside©ra r+ r, r- r= s øýúz4CSSToExcelConverter.build_border.<locals>.<dictcomp>©rG ÚrightrI Úleftr, rz r, r r- ro
|
s ÷z CSSToExcelConverter.build_border)r# Úwidthr~ c C sÒ |d kr |d kr |d kr d S |d kr0|d kr0dS |dkr<dS | |¡}|d krRdS |dkr^|S |dkrjdS |dkr|dkr~dS dS |dkr|dkrdS d S || jkr®| j| S tjd
|
t| tt d dS d S ) NÚnone)r Úhidden)NZgrooveZridgeZinsetZoutsetÚsolidrV rT )rS ÚthinrU rR rW z Unhandled border style format: ©Ú
|
stacklevel)Ú_get_width_nameÚBORDER_STYLE_MAPÚwarningsÚwarnÚreprr r )r+ r# r
r~ Z
|
width_namer, r, r- r s:
|
|
|
ýz!CSSToExcelConverter._border_style)Ú width_inputr) c C s2 | |¡}|dk rd S |dk r"dS |dk r.dS dS )Ngñhãµøä>gÍÌÌÌÌÌô?r gffffff@ZmediumZthick)Ú_width_to_float)r+ r r
r, r, r- r P s
|
z#CSSToExcelConverter._get_width_nameÚfloat)r
r) c C s |d kr d}| |¡S )NZ2pt)Ú _pt_to_float)r+ r
r, r, r- r Z s z#CSSToExcelConverter._width_to_floatÚstr)Ú pt_stringr) c C s | d¡stt| d¡S )NÚpt)ÚendswithÚAssertionErrorr Úrstrip)r+ r r, r, r- r _ s z CSSToExcelConverter._pt_to_float)ra c C s& | d¡}|dkr"| |¡ddS d S )Nzbackground-color)NZ transparentr r )ZfgColorZ patternType)rw r )r+ ra Z
|
fill_colorr, r, r- rp c s
|
z CSSToExcelConverter.build_fillre c C s, | d¡}t|tr | dd¡n|}d|iS )Nz number-formatõ §ú;Z format_code)rw rh r Úreplace)r+ ra Zfcr, r, r- rr j s
|
z'CSSToExcelConverter.build_number_formatz$dict[str, bool | float | str | None]c C sv | |¡}| |¡}|r |d nd | |¡| |¡| |¡| |¡d|krNdnd d|kpZd | | d¡¡| |¡d S )Nr Ú underlineÚsinglez line-throughr~ ) ÚnameÚfamilyÚsizerJ rM r Ústriker~ Zshadow) Ú_get_font_namesÚ_get_decorationÚ_select_font_familyÚ_get_font_sizeÚ _get_is_boldÚ_get_is_italicr rw Ú _get_shadow)r+ ra Ú
|
font_namesÚ
|
decorationr, r, r- rq o s
|
|
|
öz CSSToExcelConverter.build_fontc C s | d¡}|r| j |¡S d S )Nz font-weight)rw ÚBOLD_MAP)r+ ra Zweightr, r, r- r¨ s
|
z CSSToExcelConverter._get_is_boldc C s | d¡}|r| j |¡S d S )Nz
|
font-style)rw Ú
|
ITALIC_MAP)r+ ra Z
|
font_styler, r, r- r© s
|
z"CSSToExcelConverter._get_is_italicz Sequence[str]c C s" | d¡}|d k r| ¡ S dS d S )Nztext-decorationr, )rw Úsplit)r+ ra r¬ r, r, r- r¥ s
|
z#CSSToExcelConverter._get_decoration)r¬ r) c C s d|kr dS d S )Nr r r, )r+ r¬ r, r, r- Ú_get_underline s z"CSSToExcelConverter._get_underlinec C s d|kr t t d|d ¡S d S )Nz text-shadowz ^[^#(]*[1-9])r} ÚreÚsearchrz r, r, r- rª s z CSSToExcelConverter._get_shadowc C s t d| dd¡¡}g }|D ]f}|d d
dkrF|dd
dd¡}n.|d d
dkrl|dd
d d¡}n| ¡ }|r | |¡ q |S )
|
Nz(?x)
|
(
|
"(?:[^"]|\\")+"
|
|
|
'(?:[^']|\\')+'
|
|
|
[^'",]+
|
)(?=,|\s*$)
|
z font-familyÚ rN ú"éÿÿÿÿz\"ú'z\')r± Úfindallrw r ÚstripÚappend)r+ ra Zfont_names_tmpr« r r, r, r- r¤ s
|
ö z#CSSToExcelConverter._get_font_namesz float | Nonec C s | d¡}|d kr|S | |¡S )Nz font-size)rw r )r+ ra r¢ r, r, r- r§ ¸ s
|
z"CSSToExcelConverter._get_font_sizer' ©r) c C s& d }|D ]}| j |¡}|r q"q|S r* )Ú
|
FAMILY_MAPrw )r+ r« r¡ r r, r, r- r¦ ¾ s z'CSSToExcelConverter._select_font_family)r" r) c C sb |d kr d S | |¡r | |¡S z | j| W S tk
|
r\ tjdt| tt d Y nX d S )NzUnhandled color format: r ) Ú _is_hex_colorÚ_convert_hex_to_excelÚ NAMED_COLORSÚKeyErrorr r r r r ©r+ r" r, r, r- r Ç s
|
|
ý z"CSSToExcelConverter.color_to_excelr} )Ú color_stringr) c C s t | d¡S )Nú#)r} Ú
|
startswith)r+ rÁ r, r, r- r¼ Ø s z!CSSToExcelConverter._is_hex_colorc C sH | d¡}| |¡r<|d d |d d |d d ¡ S | ¡ S d S )Nr r rO rN )ÚlstripÚ_is_shorthand_colorÚupper©r+ rÁ Úcoder, r, r- r½ Û s
|
|
(z)CSSToExcelConverter._convert_hex_to_excelc C s< | d¡}t|dkrdS t|dkr*dS td| dS )zcCheck if color code is shorthand.
|
|
#FFF is a shorthand as opposed to full #FFFFFF.
|
r é Té FzUnexpected color N)rÄ ÚlenÚ
|
ValueErrorrÇ r, r, r- rÅ â s
|
z'CSSToExcelConverter._is_shorthand_color)N))r/ r0 r1 Ú__doc__r r¾ r{ r r® r» r Ú__annotations__r. r r[ r_ r\ r` rn rx ry ro r r r r rp rr rq r¨ r© r¥ r° rª r¤ r§ r¦ r r¼ r½ rÅ r, r, r, r- rF g s
|
ú óýüþ
|
7
|
rF c @ s e Zd ZdZdZdZd8d d
|
d d d dd d ddd
|
ddZeddddZdd Z dddd Z
|
ddd d Z ddd d Z ddd!d"Z ddd#d$Zddd%d&Zed dd'd(Zd)dd*d+d,Zddd-d.Zeed/ d0d9d d)d)d3d
|
d4dd5d6d7ZdS ):Ú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 @ r³ NTFÚinfr rY zSequence[Hashable] | NonezSequence[Hashable] | boolr} zIndexLabel | Noner4 r( )
|
Úna_repÚ float_formatÚcolsÚheaderÚindexÚ index_labelÚ merge_cellsÚinf_repÚstyle_converterr) c C sà d| _ || _t|tsB|| _| j ¡ |j}|
|
d kr:t }
|
|
|
| _n d | _d | _|| _ |d k r®t
|
t | |j ¡sxtdt
|
t | |j ¡t
|
t|kr td|j|d| _ | j j | _ || _|| _|| _|| _|| _| | _d S )Nr z,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)Úcolumns)Ú
|
rowcounterrÑ rh r ÚstylerZ_computeÚdatarF rÙ ÚdfrË r Ú intersectionrÚ r¿ ÚsetZreindexrÒ rÕ rÖ rÔ r× rØ ) r+ rÞ rÑ rÒ rÓ rÔ rÕ rÖ r× rØ rÙ r, r, r- r. s2
|
|
|
zExcelFormatter.__init__z dict[str, dict[str, str | bool]]rº c C s ddidddddddddS ) NrJ Tr r rH rG )rt ru )rd Zbordersrb r, ©r+ r, r, r- Ú header_styleA s üøzExcelFormatter.header_stylec C s t |rt |¡r| j}nJt|rdt |¡r4| j}n0t |¡rLd| j }n| jd k rdt | j| }t
|
|dd d k r|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 ZisnarÑ r Zisposinf_scalarrØ Zisneginf_scalarrÒ r ÚgetattrrÌ rÀ r, r, r- Ú _format_valueN s
|
|
|
ÿz ExcelFormatter._format_valuezIterable[ExcelCell]c c sª | j jdkr| jstd| js*| js*d S | j }|j| jddd}t|}d}d}| jrzt | j
|
jt rzt | j
|
jd d }| jrHt |jD ] \}}t|||| jdV qt t||j|jD ]\}\}}} | | ¡}
|
| ¡ D ]d\} } d\} }| dkr
|
||| | } }t||| d |
|
| | jt| jdd || | j| |d
|
V qÞq¾nXt t| D ]J\} }
|
d
|
tt |
|
¡}t||| d || jt| jdd || | jd V qT|| _ d S ) NrN z]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.F©ZsparsifyZadjoinÚnamesr r> ©NNÚ ctx_columns©
|
r r! r" r# r5 r6 r7 r8 r$ r% Ú.©r r! r" r# r5 r6 r7 r8 ) rÚ ZnlevelsrÕ ÚNotImplementedErrorÚ _has_aliasesrÔ Úformatr× r rh rÞ r rË Ú enumeraterè r râ ÚzipÚlevelsÚcodesÚtaker@ r3 rå rÜ rÙ ÚjoinÚmapr rÛ )r+ rÚ Ú
|
level_strsÚ level_lengthsÚ coloffsetÚlnumr Úspansró Ú level_codesÚvaluesÚiÚspan_valr$ r% rk r, r, r- Ú_format_header_mi` sv ÿ ÿü
|
ÿ
|
|
|
ö
|
ø z ExcelFormatter._format_header_mic c sÐ | j s | jrÌd}| jr6d}t| jjtr6t| jjj}| j}| j rt t
|
| j| _t| jt| jkrt dt| j dt| j d| j}t |D ]6\}}t | j|| || jt| jdd d|| jdV qd S )Nr rN zWriting z cols but got z aliasesrê rí )rï rÔ rÕ rh rÞ r rË rè rÚ r r
|
rÌ rñ r3 rÛ râ rå rÜ rÙ )r+ rú ZcolnamesÚcolindexZcolnamer, r, r- Ú_format_header_regular¥ s2 ÿ øz%ExcelFormatter._format_header_regularc s t jtr ¡ }n ¡ }d} jjjrdd jjjD dgt j }t dd t
|
dd |r fdd t |D } j d
|
7 _ t ||¡S ) Nr, c S s g | ]}|d k r|ndqS ©Nr³ r, )r; Úxr, r, r- Ú
|
<listcomp>Ï s z1ExcelFormatter._format_header.<locals>.<listcomp>r³ c S s | o|S r* r, )r Úyr, r, r- Ú<lambda>Ò ó z/ExcelFormatter._format_header.<locals>.<lambda>c S s | dkS r r, )r r, r, r- r Ò r c 3 s$ | ] \}}t j|| jV qd S r* )r rÛ râ )r; r r" rá r, r- Ú <genexpr>Ó s ÿz0ExcelFormatter._format_header.<locals>.<genexpr>rN )rh rÚ r r r rÞ rÕ rè rË r r÷ rñ rÛ Ú itertoolsÚchain)r+ ÚgenZgen2r r, rá r- Ú_format_headerÄ s
|
|
ÿþ
|
þz ExcelFormatter._format_headerc C s" t | jjtr| ¡ S | ¡ S d S r* )rh rÞ rÕ r Ú_format_hierarchical_rowsÚ_format_regular_rowsrá r, r, r- Ú _format_bodyÚ s zExcelFormatter._format_bodyc c s2 | j s | jr| jd7 _| jr| jrJt| jtttj t
|
frJ| jd }n(| jrdt| jt rd| j}n| j jj d }t| jtr| jd7 _|r²| jdk r²t| jd d|| jV | j j}t| j jtrÔ| j j ¡ }t|D ]6\}}t| j| d|| jt| jdd |d| jdV qÜd}nd}| |¡E d H d S )NrN r FÚ ctx_indexrí )rï rÔ rÛ rÕ rÖ rh rg ÚtupleÚnpÚndarrayr r rÞ rè rÚ r r râ r Z to_timestamprñ r3 rå rÜ rÙ Ú_generate_body)r+ rÖ Z index_valuesÚidxZidxvalrú r, r, r- r à s@ ÿ ø
|
|
z#ExcelFormatter._format_regular_rowsc c sú | j s | jr| jd7 _d}| jræ| jjj}| jrRt| jtt t
|
j t frR| j}t| j trr| jrr| jd7 _tj| r°| jdk r°t|D ] \}}t| jd ||| jV q| jr| jjjdddd}t|}t|| jjj| jjjD ]\}}} |j| |j|j d}
|
| ¡ D ]h\} } d\} }| dkrB| j| | d } |}t | j| ||
|
| | jt | j dd | || j!| |d
|
V q|d7 }qìn^t| jj D ]P}t|D ]8\}}t | j| ||| jt | j dd ||| j!d
|
V q |d7 }q| "|¡E d H d S ) NrN r FTrç )Z
|
allow_fillZ
|
fill_valueré r rë rí )#rï rÔ rÛ rÕ rÞ rè rÖ rh rg r r r r rÚ r r× ÚcomZ any_not_nonerñ r râ rð r rò ró rô rõ Z _can_hold_naZ _na_valuer@ r3 rå rÜ rÙ r )r+ ZgcolidxZ index_labelsZcidxr rø rù rü ró rý rþ rÿ r r$ r% Z indexcolvalsr Z indexcolvalr, r, r- r s
|
ÿ ÿ ÿý
|
ö ø
|
z(ExcelFormatter._format_hierarchical_rowsc C s
|
t | jS )z1Whether the aliases for column names are present.)r rÔ rá r, r, r- rï ] s zExcelFormatter._has_aliasesr& )rú r) c c sn t t| jD ]Z}| jjd d
|f }t|D ]8\}}t| j| || |d t| j dd ||| j
|
dV q.qd S )NÚctxrí ) ÚrangerË rÚ rÞ Zilocrñ r3 rÛ rå rÜ rÙ )r+ rú ZcolidxZseriesrÿ r" r, r, r- r b s øz ExcelFormatter._generate_bodyc c s2 t | ¡ | ¡ ¡D ]}| |j¡|_|V qd S r* )r r r r ræ r" )r+ Úcellr, r, r- Úget_formatted_cellsr s z"ExcelFormatter.get_formatted_cellsÚstorage_options)r ÚSheet1r ztuple[int, int] | Noner )Ú
|
sheet_nameÚstartrowÚstartcolÚ freeze_panesÚenginer r) c C s¦ ddl m} | jj\} }
|
| | jks,|
|
| jkrPtd| d|
|
d| j d| j | ¡ } t||rhd} n||||d}d} z|j
|
| ||||d W 5 | r | ¡ X d
|
S ) 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)r# r T)r r! r" N) Zpandas.io.excelr$ rÞ ÚshapeÚmax_rowsÚmax_colsrÌ r rh ÚcloseZ _write_cells) r+ Úwriterr r r! r" r# r r$ Znum_rowsZnum_colsZformatted_cellsZ need_saver, r, r- Úwritew s2 ÿ
|
ÿû
|
zExcelFormatter.write) r³ NNTTNFrÐ N)r r r NNN)r/ r0 r1 rÍ r& r' r. Úpropertyrâ ræ r r r r r r rï r r r r r* r, r, r, r- rÏ ð sD õ"- E .O ørÏ )9rÍ Ú
|
__future__r Ú functoolsr r r r± Útypingr r r r r r
|
r r Únumpyr Zpandas._libs.libr Zpandas._typingr r Zpandas.util._decoratorsr Zpandas.util._exceptionsr Zpandas.core.dtypesr Zpandas.core.dtypes.commonr r Zpandasr r r r Zpandas.core.commonÚcoreÚcommonr Zpandas.core.shared_docsr Z pandas.io.formats._color_datar Zpandas.io.formats.cssr r Zpandas.io.formats.formatr Zpandas.io.formats.printingr r r3 rF rÏ r, r, r, r- Ú<module> s6 $
|
