B
    ÔùÓ`Î  ã               @   s¼   d dl Z d dlmZ d dlmZmZmZmZmZm	Z	m
Z
 d dlmZ d dlmZ d dlmZmZ dZdZd	Ze  d
 eee¡¡Zdd„ ZG dd„ deƒZG dd„ deƒZG dd„ deƒZdS )é    N)Úwarn)ÚAliasÚBoolÚStrictÚStringÚIntegerÚMatchPatternÚTyped)ÚSerialisable)ÚElement)ÚescapeÚunescapez&"(?P<font>.+)"z&K(?P<color>[A-F0-9]{6})z&(?P<size>\d+\s?)z{0}|{1}|{2}c             C   sX   t  dt jt jB ¡}| | ¡}y| ¡ }W n( tk
rR   tdƒ ddddœ}Y nX |S )z¹
    Split the combined (decoded) string into left, center and right parts

    # See http://stackoverflow.com/questions/27711175/regex-with-multiple-optional-groups for discussion
    zN
    (&L(?P<left>.+?))?
    (&C(?P<center>.+?))?
    (&R(?P<right>.+?))?
    $z3Cannot parse header or footer so it will be ignoredÚ )ÚleftÚrightÚcenter)ÚreÚcompileÚVERBOSEÚDOTALLÚmatchÚ	groupdictÚAttributeErrorr   )ÚtextZ
ITEM_REGEXÚmÚparts© r   úD/tmp/pip-unpacked-wheel-zhp1095k/openpyxl/worksheet/header_footer.pyÚ_split_string   s    
r   c               @   sd   e Zd ZdZedd�Zedd�Zedd�ZdZ	e
de	d�Zddd„Zd	d
„ Zdd„ Zedd„ ƒZdS )Ú_HeaderFooterPartaÉ  
    Individual left/center/right header/footer part

    Do not use directly.

    Header & Footer ampersand codes:

    * &A   Inserts the worksheet name
    * &B   Toggles bold
    * &D or &[Date]   Inserts the current date
    * &E   Toggles double-underline
    * &F or &[File]   Inserts the workbook name
    * &I   Toggles italic
    * &N or &[Pages]   Inserts the total page count
    * &S   Toggles strikethrough
    * &T   Inserts the current time
    * &[Tab]   Inserts the worksheet name
    * &U   Toggles underline
    * &X   Toggles superscript
    * &Y   Toggles subscript
    * &P or &[Page]   Inserts the current page number
    * &P+n   Inserts the page number incremented by n
    * &P-n   Inserts the page number decremented by n
    * &[Path]   Inserts the workbook path
    * &&   Escapes the ampersand character
    * &"fontname"   Selects the named font
    * &nn   Selects the specified 2-digit font point size

    Colours are in RGB Hex
    T)Ú
allow_nonez^[A-Fa-f0-9]{6}$)r    ÚpatternNc             C   s   || _ || _|| _|| _d S )N)r   ÚfontÚsizeÚcolor)Úselfr   r"   r#   r$   r   r   r   Ú__init__]   s    z_HeaderFooterPart.__init__c             C   s^   g }| j r| d | j ¡¡ | jr4| d | j¡¡ | jrL| d | j¡¡ d || jg ¡S )zI
        Convert to Excel HeaderFooter miniformat minus position
        z&"{0}"z&{0} z&K{0}r   )r"   ÚappendÚformatr#   r$   Újoinr   )r%   Úfmtr   r   r   Ú__str__d   s    z_HeaderFooterPart.__str__c             C   s
   t | jƒS )N)Úboolr   )r%   r   r   r   Ú__bool__q   s    z_HeaderFooterPart.__bool__c                s:   d‰ t ‡ fdd„t |¡D ƒƒ}t d|¡|d< | f |ŽS )z3
        Convert from miniformat to object
        )r"   r$   r#   c             3   s.   | ]&}t ˆ |ƒD ]\}}|r||fV  qqd S )N)Úzip)Ú.0r   ÚkÚv)Úkeysr   r   ú	<genexpr>|   s    z-_HeaderFooterPart.from_str.<locals>.<genexpr>r   r   )ÚdictÚFORMAT_REGEXÚfindallÚsub)Úclsr   Úkwr   )r2   r   Úfrom_strv   s    z_HeaderFooterPart.from_str)NNNN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   r   r"   r   r#   ZRGBr   r$   r&   r+   r-   Úclassmethodr:   r   r   r   r   r   5   s   



r   c               @   sh   e Zd ZdZeed�Zeed�ZedƒZ	eed�Z
dZddd„Zdd	„ Zd
d„ Zdd„ Zedd„ ƒZdS )ÚHeaderFooterItemz 
    Header or footer item

    )Úexpected_typer   )ÚLÚCÚRNc             C   s@   |d krt ƒ }|| _|d kr"t ƒ }|| _|d kr6t ƒ }|| _d S )N)r   r   r   r   )r%   r   r   r   r   r   r   r&   ’   s    zHeaderFooterItem.__init__c          	      s¤   ddddddddd	œ‰ t  d
 dd„ ˆ D ƒ¡¡}‡ fdd„}g }xDt| j| j| j| jgƒD ](\}}|jdk	rZ| 	d 
|t|ƒ¡¡ qZW d |¡}| ||¡}t|ƒS )z1
        Pack parts into a single string
        z&Az&Nz&Dz&Zz&Pz&Tz&Fz&G)z&[Tab]z&[Pages]z&[Date]z&[Path]z&[Page]z&[Time]z&[File]z
&[Picture]ú|c             S   s   g | ]}d   t |¡¡‘qS )z({0}))r(   r   r   )r/   r0   r   r   r   ú
<listcomp>§   s   z,HeaderFooterItem.__str__.<locals>.<listcomp>c                s   |   d¡}ˆ | S )zn
            Callback for re.sub
            Replace expanded control with mini-format equivalent
            r   )Úgroup)r   r7   )Ú	TRANSFORMr   r   Úreplaceª   s    
z)HeaderFooterItem.__str__.<locals>.replaceNz&{0}{1}r   )r   r   r)   r.   Ú_HeaderFooterItem__keysr   r   r   r   r'   r(   Ústrr7   r   )r%   Z
SUBS_REGEXrI   ÚtxtÚkeyÚpartr   )rH   r   r+   ž   s    

zHeaderFooterItem.__str__c             C   s   t | j| j| jgƒS )N)Úanyr   r   r   )r%   r   r   r   r-   ¼   s    zHeaderFooterItem.__bool__c             C   s   t |ƒ}t| ƒ|_|S )z$
        Return as XML node
        )r   rK   r   )r%   ÚtagnameÚelr   r   r   Úto_treeÁ   s    
zHeaderFooterItem.to_treec             C   sV   |j rRt|j ƒ}t|ƒ}x*| ¡ D ]\}}|d k	r"t |¡||< q"W | f |Ž}|S d S )N)r   r   r   Úitemsr   r:   )r8   Únoder   r   r0   r1   r%   r   r   r   Ú	from_treeÊ   s    

zHeaderFooterItem.from_tree)NNN)r;   r<   r=   r>   r	   r   r   r   r   Zcentrer   rJ   r&   r+   r-   rR   r?   rU   r   r   r   r   r@   „   s   



	r@   c            
   @   s–   e Zd ZdZedd�Zedd�Zedd�Zedd�Ze	e
dd�Ze	e
dd�Ze	e
dd�Ze	e
dd�Ze	e
dd�Ze	e
dd�ZdZddd„Zd	d
„ ZdS )ÚHeaderFooterZheaderFooterT)r    )rA   r    )Ú	oddHeaderÚ	oddFooterÚ
evenHeaderÚ
evenFooterÚfirstHeaderÚfirstFooterNc             C   s”   || _ || _|| _|| _|d kr&tƒ }|| _|d kr:tƒ }|| _|d krNtƒ }|| _|d krbtƒ }|| _|	d krvtƒ }	|	| _	|
d krŠtƒ }
|
| _
d S )N)ÚdifferentOddEvenÚdifferentFirstÚscaleWithDocÚalignWithMarginsr@   rW   rX   rY   rZ   r[   r\   )r%   r]   r^   r_   r`   rW   rX   rY   rZ   r[   r\   r   r   r   r&   ç   s,    zHeaderFooter.__init__c                s"   ‡ fdd„ˆ j ˆ j D ƒ}t|ƒS )Nc                s   g | ]}t ˆ |ƒ‘qS r   )Úgetattr)r/   Úattr)r%   r   r   rF     s    z)HeaderFooter.__bool__.<locals>.<listcomp>)Ú	__attrs__Ú__elements__rO   )r%   r   r   )r%   r   r-     s    zHeaderFooter.__bool__)
NNNNNNNNNN)r;   r<   r=   rP   r   r]   r^   r_   r`   r	   r@   rW   rX   rY   rZ   r[   r\   rd   r&   r-   r   r   r   r   rV   Ö   s.   



         
rV   )r   Úwarningsr   Zopenpyxl.descriptorsr   r   r   r   r   r   r	   Z!openpyxl.descriptors.serialisabler
   Zopenpyxl.xml.functionsr   Zopenpyxl.utils.escaper   r   ZFONT_PATTERNZCOLOR_PATTERNZ
SIZE_REGEXr   r(   r5   r   r   r@   rV   r   r   r   r   Ú<module>   s   $	OR