3
Êb_Ðc  ã               @   sö   d Z ddlmZ ddlZddlZddlmZmZmZm	Z	m
Z
mZ ddlZddlZddlmZ ddlmZmZ ddlmZmZ ddlmZ ddljjZdd	lmZ dd
lm Z m!Z! ddl"m#Z# ddl$m%Z% G dd„ dƒZ&G dd„ dƒZ'G dd„ dƒZ(dS )zAUtilities for conversion to writer-agnostic Excel representation
é    )ÚreduceN)ÚCallableÚDictÚListÚOptionalÚSequenceÚUnion)Úmissing)Úis_floatÚ	is_scalar)ÚABCMultiIndexÚABCPeriodIndex)ÚIndex)Ústringify_path)ÚCSSResolverÚ
CSSWarning)Úget_level_lengths)Úpprint_thingc               @   s&   e Zd ZdZeZdeedœd	d
„ZdS )Ú	ExcelCellÚrowÚcolÚvalÚstyleÚ
mergestartÚmergeendN)r   r   c             C   s(   || _ || _|| _|| _|| _|| _d S )N)r   r   r   r   r   r   )Úselfr   r   r   r   r   r   © r   ú9/tmp/pip-build-jkwsxyiy/pandas/pandas/io/formats/excel.pyÚ__init__   s    zExcelCell.__init__)r   r   r   r   r   r   )NNN)Ú__name__Ú
__module__Ú__qualname__Z
__fields__Ú	__slots__Úintr   r   r   r   r   r      s   r   c               @   sš  e Zd ZdZd:ee dœdd„Zeƒ Zee	ee	eef f dœdd„Z
e	eef e	ee	eef f d	œd
d„ZdddddddœZe	eeeeef  f dœdd„Ze	e	ee	eef f d	œdd„Zee dœdd„Ze	eef dœdd„ZddddddddddddddœZddddœZe	eeeeeef  f dœdd „Zd!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d1d2d3d4œZee d5œd6d7„Ze	e	eee f d	œd8d9„ZdS );ÚCSSToExcelConverteraF  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__`.
    N)Ú	inheritedc             C   s   |d k	r| j |ƒ}|| _d S )N)Úcompute_cssr%   )r   r%   r   r   r   r   >   s    
zCSSToExcelConverter.__init__)Údeclarations_strÚreturnc             C   s   | j || jƒ}| j|ƒS )ax  
        Convert CSS declarations to ExcelWriter style.

        Parameters
        ----------
        declarations_str : str
            List of CSS declarations.
            e.g. "font-weight: bold; background: blue"

        Returns
        -------
        xlstyle : dict
            A style as interpreted by ExcelWriter when found in
            ExcelCell.style.
        )r&   r%   Úbuild_xlstyle)r   r'   Z
propertiesr   r   r   Ú__call__F   s    zCSSToExcelConverter.__call__)Úpropsr(   c                sV   | j |ƒ| j|ƒ| j|ƒ| j|ƒ| j|ƒdœ}tttf d dœ‡ fdd„‰ ˆ |ƒ |S )N)Ú	alignmentZborderÚfillÚfontZnumber_format)Údr(   c                sJ   xDt | jƒ ƒD ]4\}}|dkr&| |= qt|tƒrˆ |ƒ |s| |= qW dS )z4Remove key where value is None, through nested dictsN)ÚlistÚitemsÚ
isinstanceÚdict)r/   ÚkÚv)Úremove_noner   r   r6   e   s    
z6CSSToExcelConverter.build_xlstyle.<locals>.remove_none)Úbuild_alignmentÚbuild_borderÚ
build_fillÚ
build_fontÚbuild_number_formatr   Ústr)r   r+   Úoutr   )r6   r   r)   Z   s    
z!CSSToExcelConverter.build_xlstyleÚtopÚcenterÚbottom)r>   ztext-topZmiddleZbaseliner@   ztext-bottom)r(   c             C   s:   |j dƒ| jj |j dƒƒ|j dƒd kr*d n
|d dkdœS )	Nz
text-alignzvertical-alignzwhite-spaceÚnowrapÚpreúpre-line)Ú
horizontalÚverticalÚ	wrap_text)rA   rB   rC   )ÚgetÚVERTICAL_MAP)r   r+   r   r   r   r7   |   s    z#CSSToExcelConverter.build_alignmentc                s   ‡ ‡fdd„dD ƒS )Nc                sP   i | ]H}ˆj ˆ jd |› d�ƒˆ jd |› d�ƒƒˆjˆ jd |› d�ƒƒdœ|“qS )zborder-z-stylez-widthz-color)r   Úcolor)Ú_border_stylerG   Úcolor_to_excel)Ú.0Zside)r+   r   r   r   ú
<dictcomp>‰   s   z4CSSToExcelConverter.build_border.<locals>.<dictcomp>r>   Úrightr@   Úleft)r>   rN   r@   rO   r   )r   r+   r   )r+   r   r   r8   ˆ   s    z CSSToExcelConverter.build_border)r   c             C   sÈ   |d kr|d krd S |dks$|dkr(d S |d kr4d}t |d d… ƒ}|dk rPd S |dk r^d}n|dk rld	}nd
}|dkr|d}|dkrˆdS |dkr”|S |dkr¬|dkr¨dS dS |dkrÄ|dkrÀdS dS d S )NÚnoneÚhiddenZ2pté   gñhãˆµøä>gÍÌÌÌÌÌô?Úthingffffff@ZmediumZthickÚgrooveÚridgeÚinsetÚoutsetÚsolidÚdoubleZdottedÚhairZmediumDashDotDotZdashedZmediumDashedéþÿÿÿ)NrT   rU   rV   rW   )rZ   rS   )rZ   rS   )Úfloat)r   r   ÚwidthZ
width_namer   r   r   rJ   ”   s8    z!CSSToExcelConverter._border_style)r+   c             C   s&   |j dƒ}|dkr"| j|ƒddœS d S )Nzbackground-colorÚtransparentrP   rX   )ZfgColorZpatternType)Nr^   rP   )rG   rK   )r   r+   Z
fill_colorr   r   r   r9   Å   s    
zCSSToExcelConverter.build_fillTF)ÚboldZbolderZ600Z700Z800Z900ÚnormalZlighterZ100Z200Z300Z400Ú500)r`   ÚitalicZobliquec             C   s®  |j dƒ}|d k	r0|jdƒs t‚t|d d… ƒ}tjd|j ddƒƒ}g }xn|D ]f}|d d… dkrx|dd… jd	dƒ}n.|d d… d
krž|dd… jdd
ƒ}n|jƒ }|rN|j|ƒ qNW d }xJ|D ]B}|dkrÖd}P qÂ|dkræd}P qÂ|dkröd}P qÂ|dkrÂd}P qÂW |j dƒ}|d k	�r&|j	ƒ }nf }|�r8|d nd ||| j
j |j dƒƒ| jj |j dƒƒd|k�rldnd d|k�pzd | j|j dƒƒd|k�r¦ttjd|d ƒƒnd dœ	S ) Nz	font-sizeÚptrR   z›(?x)
            (
            "(?:[^"]|\\")+"
            |
            '(?:[^']|\\')+'
            |
            [^'",]+
            )(?=,|\s*$)
        zfont-familyÚ é   ú"z\"ú'z\'Zserifz
sans-serifZcursiveé   Zfantasyé   ztext-decorationr   zfont-weightz
font-styleÚ	underlineZsinglezline-throughrI   ztext-shadowz^[^#(]*[1-9])	ÚnameÚfamilyÚsizer_   rb   rj   ÚstrikerI   Zshadowr[   éÿÿÿÿro   )rG   ÚendswithÚAssertionErrorr\   ÚreÚfindallÚreplaceÚstripÚappendÚsplitÚBOLD_MAPÚ
ITALIC_MAPrK   ÚboolÚsearch)r   r+   rm   Zfont_names_tmpZ
font_namesrk   rl   Z
decorationr   r   r   r:   Ý   sX    
	




zCSSToExcelConverter.build_fontZ800000ZA52A2AZFF0000ZFFC0CBZFFA500ZFFFF00Z808000Z008000Z800080ZFF00FFZ00FF00Z008080Z00FFFFZ0000FFZ000080Z000000Z808080ZC0C0C0ZFFFFFF)ZmaroonZbrownZredZpinkZorangeZyellowZoliveZgreenZpurpleZfuchsiaZlimeZtealZaquaZblueZnavyZblackZgrayZgreyZsilverZwhite)r   c             C   sª   |d krd S |j dƒr2t|ƒdkr2|dd … jƒ S |j dƒrpt|ƒdkrp|d d |d d  |d d  jƒ S y
| j| S  tk
r¤   tjdt|ƒ› �tƒ Y nX d S )Nú#é   re   rh   rR   é   zUnhandled color format: )	Ú
startswithÚlenÚupperÚNAMED_COLORSÚKeyErrorÚwarningsÚwarnÚreprr   )r   r   r   r   r   rK   =  s    (
z"CSSToExcelConverter.color_to_excelc             C   s   d|j dƒiS )NZformat_codeznumber-format)rG   )r   r+   r   r   r   r;   I  s    z'CSSToExcelConverter.build_number_format)N)r   r    r!   Ú__doc__r   r<   r   r   r&   r   r*   r)   rH   r   rz   r7   r8   rJ   r9   rx   ry   r#   r:   r‚   rK   r;   r   r   r   r   r$   (   sh    (" 1$Jr$   c               @   s¾   e Zd ZdZd&Zd'Zd(eee ee e	e
ee f e
e	eedf e
eee d
œ	dd„Zedd„ ƒZdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zedœdd„Zd d!„ Zd)d$d%„ZdS )*ÚExcelFormattera^  
    Class for formatting a DataFrame to a list of ExcelCells,

    Parameters
    ----------
    df : DataFrame or Styler
    na_rep: na representation
    float_format : string, default None
            Format string for floating point numbers
    cols : sequence, optional
        Columns to write
    header : boolean or list of string, default True
        Write out column names. If a list of string is given it is
        assumed to be aliases for the column names
    index : boolean, default True
        output row names (index)
    index_label : string 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 : boolean, default False
            Format MultiIndex and Hierarchical Rows as merged cells.
    inf_rep : string, 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.
    rR   é   é   rd   NTFÚinf)	Úna_repÚfloat_formatÚcolsÚheaderÚindexÚindex_labelÚmerge_cellsÚinf_repÚstyle_converterc             C   sÈ   d| _ || _t|dƒr8|| _|j}|
d kr0tƒ }
|
| _nd | _|| _|d k	r–tt	|ƒ|j
@ ƒsftdƒ‚tt	|ƒ|j
@ ƒt|ƒkrˆtdƒ‚|j|d�| _| jj
| _
|| _|| _|| _|| _|| _|	| _d S )Nr   Úrenderz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)Úcolumns)Ú
rowcounterrŒ   ÚhasattrÚstylerÚdatar$   r”   Údfr€   r   r–   rƒ   Zreindexr�   r�   r‘   r�   r’   r“   )r   r›   rŒ   r�   rŽ   r�   r�   r‘   r’   r“   r”   r   r   r   r   q  s.    

zExcelFormatter.__init__c             C   s    ddidddddœdddœdœS )	Nr_   TrS   )r>   rN   r@   rO   r?   r>   )rD   rE   )r.   Zbordersr,   r   )r   r   r   r   Úheader_style�  s    zExcelFormatter.header_stylec             C   s€   t |ƒrtj|ƒr| j}nJt|ƒrdtj|ƒr4| j}n0tj|ƒrLd| j› �}n| jd k	rdt	| j| ƒ}t
|dd ƒ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	   ZisnarŒ   r
   Zisposinf_scalarr“   Zisneginf_scalarr�   r\   ÚgetattrÚ
ValueError)r   r   r   r   r   Ú_format_valueª  s    


zExcelFormatter._format_valuec             c   s¸  | j jdkr| jstdƒ‚t| jtttj	t
fƒ}|p8| js>d S | j }|j| jddd�}t|ƒ}d}d}| jrŽt| jjtƒrŽt| jjd ƒd }| j�rhx0tt|ƒƒD ] }|j| }t|||| jƒV  q¤W xätt||j|jƒƒD ]„\}\}}	}
|	j|
ƒ}xj|D ]b}|| dk�r>t||| d || | j||| ||  ƒV  nt||| d || | jƒV  � qüW qÞW nFxDtt|Ž ƒD ]4\}}djtt|ƒƒ}t||| d || jƒV  �qvW || _d S )Nre   z]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.F)ÚsparsifyÚadjoinÚnamesr   Ú.)r–   Znlevelsr�   ÚNotImplementedErrorr2   r�   Útupler0   ÚnpÚndarrayr   Úformatr’   r   r›   r   r€   Úranger¤   r   rœ   Ú	enumerateÚzipÚlevelsÚcodesÚtakeÚjoinÚmapr   r—   )r   Úhas_aliasesr–   Ú
level_strsÚlevel_lengthsÚ	coloffsetÚlnumrk   Úspansr®   Úlevel_codesÚvaluesÚir5   r   r   r   Ú_format_header_mi¼  sJ    

 


( z ExcelFormatter._format_header_mic             c   sÆ   t | jtttjtfƒ}|s | jrÂd}| jrLd}t | jjt	ƒrLt
| jjd ƒ}| j}|r”t
| jƒt
| jƒkrŽtdt
| jƒ› dt
| jƒ› d�ƒ‚n| j}x,t|ƒD ] \}}t| j|| || jƒV  qžW d S )Nr   re   zWriting z cols but got z aliases)r2   r�   r§   r0   r¨   r©   r   r�   r›   r   r€   r–   r    r¬   r   r—   rœ   )r   r³   r¶   ZcolnamesÚcolindexZcolnamer   r   r   Ú_format_header_regularó  s     
"z%ExcelFormatter._format_header_regularc                s˜   t ˆ jtƒrˆ jƒ }nˆ jƒ }f }ˆ jjjrŒdd„ ˆ jjjD ƒdgtˆ jƒ  }t	dd„ t
dd„ |ƒƒrŒ‡ fdd„t|ƒD ƒ}ˆ  jd	7  _tj||ƒS )
Nc             S   s   g | ]}|d k	r|nd‘qS )Nrd   r   )rL   Úxr   r   r   ú
<listcomp>  s    z1ExcelFormatter._format_header.<locals>.<listcomp>rd   c             S   s   | o|S )Nr   )r¿   Úyr   r   r   Ú<lambda>  s    z/ExcelFormatter._format_header.<locals>.<lambda>c             S   s   | dkS )Nrd   r   )r¿   r   r   r   rÂ     s    c             3   s$   | ]\}}t ˆ j||ˆ jƒV  qd S )N)r   r—   rœ   )rL   r½   r   )r   r   r   ú	<genexpr>  s   z0ExcelFormatter._format_header.<locals>.<genexpr>re   )r2   r–   r   r¼   r¾   r›   r�   r¤   r€   r   r²   r¬   r—   Ú	itertoolsÚchain)r   ÚgenZgen2r   r   )r   r   Ú_format_header  s    


zExcelFormatter._format_headerc             C   s"   t | jjtƒr| jƒ S | jƒ S d S )N)r2   r›   r�   r   Ú_format_hierarchical_rowsÚ_format_regular_rows)r   r   r   r   Ú_format_body  s    zExcelFormatter._format_bodyc             c   s@  t | jtttjtfƒ}|s | jr.|  jd7  _| j�r| j	r^t | j	tttjtfƒr^| j	d }n(| j	rxt | j	t
ƒrx| j	}n| jjjd }t | jtƒr |  jd7  _|rÆ| jdk	rÆt| jd d|| jƒV  | jj}t | jjtƒrè| jjjƒ }x,t|ƒD ] \}}t| j| d|| jƒV  qòW d}nd}x| j|ƒD ]}|V  �q,W d S )Nre   r   F)r2   r�   r§   r0   r¨   r©   r   r—   r�   r‘   r<   r›   r¤   r–   r   r   rœ   r   Zto_timestampr¬   Ú_generate_body)r   r³   r‘   Zindex_valuesÚidxZidxvalr¶   Úcellr   r   r   rÉ   %  s.    
z#ExcelFormatter._format_regular_rowsc          
   c   s  t | jtttjtfƒ}|s | jr.|  jd7  _d}| j�rð| j	jj
}| jrft | jtttjtfƒrf| j}t | jtƒr†| jr†|  jd7  _tj|Ž rÈ| jdk	rÈx,t|ƒD ] \}}t| jd ||| jƒV  q¤W | j�r | j	jjdddd�}t|ƒ}x°t|| j	jj| j	jjƒD ]”\}}	}
|	j|
|	jdd�}xl|D ]d}|| dk�rnt| j| ||| | j| j| ||  d |ƒV  nt| j| ||| | jƒV  �q(W |d7 }�qW nPxNt| j	jŽ D ]>}x.t|ƒD ]"\}}t| j| ||| jƒV  �q¼W |d7 }�q®W x| j|ƒD ]}|V  �qüW d S )Nre   r   FT)r¢   r£   r¤   )Z
allow_fillZ
fill_value)r2   r�   r§   r0   r¨   r©   r   r—   r�   r›   r¤   r‘   r–   r   r’   ÚcomZany_not_noner¬   r   rœ   rª   r   r­   r®   r¯   r°   Z_can_hold_narË   )r   r³   ZgcolidxZindex_labelsZcidxrk   r´   rµ   r¸   r®   r¹   rº   r»   ZindexcolvalsrÌ   ZindexcolvalrÍ   r   r   r   rÈ   M  s^    

 

z(ExcelFormatter._format_hierarchical_rows)r¶   c             c   s¨   | j d krd }n| j jƒ j}|s$d }d }xztt| jƒƒD ]h}| jjd d …|f }xNt|ƒD ]B\}}|d k	r‚| j	dj
|||f ƒƒ}t| j| || ||ƒV  qZW q8W d S )Nú;)r™   Z_computeÚctxr«   r€   r–   r›   Zilocr¬   r”   r±   r   r—   )r   r¶   ZstylesZxlstyleZcolidxZseriesr»   r   r   r   r   rË   š  s    
zExcelFormatter._generate_bodyc             c   s6   x0t j| jƒ | jƒ ƒD ]}| j|jƒ|_|V  qW d S )N)rÄ   rÅ   rÇ   rÊ   r¡   r   )r   rÍ   r   r   r   Úget_formatted_cells«  s    z"ExcelFormatter.get_formatted_cellsÚSheet1r   c          	   C   s    ddl m} | jj\}}	|| jks,|	| jkrPtd|› d|	› d| j› d| j› �ƒ‚t||ƒr`d}
n|t|ƒ|d�}d}
| j	ƒ }|j
|||||d	� |
rœ|jƒ  d
S )aî  
        writer : string or ExcelWriter object
            File path or existing ExcelWriter
        sheet_name : string, 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``.
        r   )ÚExcelWriterz-This sheet is too large! Your sheet size is: z, z Max sheet size is: F)ÚengineT)ÚstartrowÚstartcolÚfreeze_panesN)Zpandas.io.excelrÓ   r›   ÚshapeÚmax_rowsÚmax_colsr    r2   r   rÑ   Zwrite_cellsÚsave)r   ÚwriterZ
sheet_namerÕ   rÖ   r×   rÔ   rÓ   Znum_rowsZnum_colsZ	need_saveZformatted_cellsr   r   r   Úwrite°  s$    "
zExcelFormatter.writei   i @  )	rd   NNTTNFr‹   N)rÒ   r   r   NN)r   r    r!   r‡   rÙ   rÚ   r<   r   r   r   rz   r   r   r   Úpropertyrœ   r¡   r¼   r¾   rÇ   rÊ   rÉ   rÈ   r#   rË   rÑ   rÝ   r   r   r   r   rˆ   M  s6           B!7(M    rˆ   ))r‡   Ú	functoolsr   rÄ   rr   Útypingr   r   r   r   r   r   r„   Znumpyr¨   Zpandas.core.dtypesr	   Zpandas.core.dtypes.commonr
   r   Zpandas.core.dtypes.genericr   r   Zpandasr   Zpandas.core.commonÚcoreÚcommonrÎ   Zpandas.io.commonr   Zpandas.io.formats.cssr   r   Zpandas.io.formats.formatr   Zpandas.io.formats.printingr   r   r$   rˆ   r   r   r   r   Ú<module>   s(      '