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
mZmZmZ d dlmZ d dlmZ d dlmZmZ eddd	d
dddgƒZd e¡Ze  d e¡¡ZdZe  e¡ZdZe  e¡Ze  d eee¡e j ¡Z!dd„ Z"dd„ Z#G dd„ deƒZ$G dd„ deƒZ%dS )é    N)ÚSerialisable)
ÚAliasÚTypedÚStringÚFloatÚIntegerÚBoolÚNoneSetÚSetÚSequenceÚ
Descriptor)Úsafe_string)Ú	Tokenizer)ÚSHEETRANGE_REÚSHEET_TITLEZ
Print_AreaZPrint_TitlesZCriteriaZ_FilterDatabaseZExtractZConsolidate_AreaZSheet_Titleú|z^_xlnm\.(?P<name>{0})z-(?P<cols>[$]?[a-zA-Z]{1,3}:[$]?[a-zA-Z]{1,3})z(?P<rows>[$]?\d+:[$]?\d+)z{0}{1}?,?{2}?c             C   s2   t  | j¡}tdd„ |D ƒƒ}| d¡| d¡fS )zg
    Extract rows and or columns from print titles so that they can be
    assigned to a worksheet
    c             s   s0   | ](}|  ¡  ¡ D ]\}}|r||fV  qqd S )N)Ú	groupdictÚitems)Ú.0ÚmatchÚkÚv© r   úB/tmp/pip-unpacked-wheel-zhp1095k/openpyxl/workbook/defined_name.pyú	<genexpr>/   s    z'_unpack_print_titles.<locals>.<genexpr>ZrowsÚcols)ÚTITLES_REGEXÚfinditerÚvalueÚdictÚget)ÚdefnÚscannerÚkwr   r   r   Ú_unpack_print_titles)   s    r$   c             C   s6   g }x,t  | j¡D ]}| d¡}|r| |¡ qW |S )z
    Extract print area
    Úcells)r   r   r   ÚgroupÚappend)r!   ÚnewÚmZcoordr   r   r   Ú_unpack_print_area5   s    
r*   c               @   sò   e Zd ZdZeƒ Zedd�Zedd�Zedd�Zedd�Z	edd�Z
edd�Zedd�Zedd�Zedd�Zedd�Zedd�Zedd�Zedd�Zedd�Zeƒ ZedƒZddd„Zedd	„ ƒZed
d„ ƒZedd„ ƒZedd„ ƒZdd„ Z dS )ÚDefinedNameÚdefinedNameT)Ú
allow_noneÚ	attr_textNc             C   sd   || _ || _|| _|| _|| _|| _|| _|| _|	| _|
| _	|| _
|| _|| _|| _|| _|| _d S )N)ÚnameÚcommentÚ
customMenuÚdescriptionÚhelpÚ	statusBarÚlocalSheetIdÚhiddenÚfunctionÚvbProcedureÚxlmÚfunctionGroupIdÚshortcutKeyÚpublishToServerÚworkbookParameterr.   )Úselfr/   r0   r1   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   r<   r=   r.   r   r   r   Ú__init__X   s     zDefinedName.__init__c             C   s.   t d| j ƒ}|jd }|jdkr(|jS |jS )Nú=r   ZOPERAND)r   r   r   ÚtypeÚsubtype)r>   ÚtokÚparsedr   r   r   rA   |   s
    

zDefinedName.typec             c   sf   | j dkrbtd| j ƒ}xH|jD ]>}|jdkr t |j¡}| d¡pL| d¡}|| d¡fV  q W d S )NÚRANGEr@   Z	notquotedÚquotedr%   )rA   r   r   r   rB   r   r   r&   )r>   rC   Úpartr)   Z	sheetnamer   r   r   Údestinations…   s    

zDefinedName.destinationsc             C   s   t  | j¡}|r| d¡S d S )Nr/   )ÚRESERVED_REGEXr   r/   r&   )r>   r)   r   r   r   Úis_reserved�   s    zDefinedName.is_reservedc             C   s   t  d¡ | j¡d k	S )Nz
^\[\d+\].*)ÚreÚcompiler   r   )r>   r   r   r   Úis_external—   s    zDefinedName.is_externalc             c   sN   xH| j D ]>}|dkrqt| |ƒ}|d k	r|tkr8d| }|t|ƒfV  qW d S )Nr.   z_xlnm.)Ú	__attrs__ÚgetattrÚRESERVEDr   )r>   Úkeyr   r   r   r   Ú__iter__œ   s    
zDefinedName.__iter__)NNNNNNNNNNNNNNNN)!Ú__name__Ú
__module__Ú__qualname__Útagnamer   r/   r0   r1   r2   r3   r4   r   r5   r   r6   r7   r8   r9   r:   r;   r<   r=   r   r.   r   r   r?   ÚpropertyrA   rH   rJ   rM   rR   r   r   r   r   r+   A   sN   













               
	r+   c               @   sx   e Zd ZdZeed�Zddd„Zdd„ Zdd	„ Z	d
d„ Z
dd„ Zdd„ Zdd„ Zddd„Zdd„ Zddd„Zdd„ ZdS )ÚDefinedNameListZdefinedNames)Zexpected_typer   c             C   s
   || _ d S )N)r,   )r>   r,   r   r   r   r?   ®   s    zDefinedNameList.__init__c             C   sL   g }x<| j D ]2}|jdkr(|jdkr(qn|jdkr4q| |¡ qW || _ dS )zJ
        Strip invalid definitions and remove special hidden ones
        )z_xlnm.Print_Titlesz_xlnm.Print_AreaNz_xlnm._FilterDatabase)r,   r/   r5   r'   )r>   Zvalid_namesÚnr   r   r   Ú_cleanup²   s    
zDefinedNameList._cleanupc             C   s0   x*| j D ] }|j|jkr|j|jkrdS qW dS )zc
        Check for whether DefinedName with the same name and scope already
        exists
        TN)r,   r/   r5   )r>   r!   Údr   r   r   Ú
_duplicateÀ   s    zDefinedNameList._duplicatec             C   sF   t |tƒstdƒ‚|  |¡r$tdƒ‚| jd d … }| |¡ || _d S )Nz You can only append DefinedNamesz7DefinedName with the same name and scope already exists)Ú
isinstancer+   Ú	TypeErrorr\   Ú
ValueErrorr,   r'   )r>   r!   Únamesr   r   r   r'   Ê   s    


zDefinedNameList.appendc             C   s
   t | jƒS )N)Úlenr,   )r>   r   r   r   Ú__len__Ô   s    zDefinedNameList.__len__c             C   s,   x&| j D ]}|j|kr|jdkrdS qW dS )z6
        See if a globaly defined name exists
        NT)r,   r/   r5   )r>   r/   r!   r   r   r   Ú__contains__Ø   s    zDefinedNameList.__contains__c             C   s    |   |¡}|std |¡ƒ‚|S )z+
        Get globally defined name
        zNo definition called {0})r    ÚKeyErrorÚformat)r>   r/   r!   r   r   r   Ú__getitem__á   s    
zDefinedNameList.__getitem__Nc             C   s,   x&| j D ]}|j|kr|j|kr|S qW dS )zE
        Get the name assigned to a specicic sheet or global
        N)r,   r/   r5   )r>   r/   Úscoper!   r   r   r   r    ë   s    zDefinedNameList.getc             C   s   |   |¡std |¡ƒ‚dS )z0
        Delete a globally defined name
        zNo globally defined name {0}N)Údeleterd   re   )r>   r/   r   r   r   Ú__delitem__ô   s    
zDefinedNameList.__delitem__c             C   s<   x6t | jƒD ](\}}|j|kr|j|kr| j|= dS qW dS )z@
        Delete a name assigned to a specific or global
        TN)Ú	enumerater,   r/   r5   )r>   r/   rg   Úidxr!   r   r   r   rh   ü   s    zDefinedNameList.deletec                s   ‡ fdd„| j D ƒS )zH
        Provide a list of all names for a particular worksheet
        c                s   g | ]}|j ˆ kr|j‘qS r   )r5   r/   )r   r!   )rg   r   r   ú
<listcomp>
  s    z.DefinedNameList.localnames.<locals>.<listcomp>)r,   )r>   rg   r   )rg   r   Ú
localnames  s    zDefinedNameList.localnames)r   )N)N)rS   rT   rU   rV   r   r+   r,   r?   rZ   r\   r'   rb   rc   rf   r    ri   rh   rm   r   r   r   r   rX   §   s   



	

	

rX   )&rK   Z!openpyxl.descriptors.serialisabler   Zopenpyxl.descriptorsr   r   r   r   r   r   r	   r
   r   r   Zopenpyxl.compatr   Zopenpyxl.formular   Zopenpyxl.utils.cellr   r   Ú	frozensetrP   ÚjoinZ_namesrL   re   rI   Z	COL_RANGEZCOL_RANGE_REZ	ROW_RANGEZROW_RANGE_REÚVERBOSEr   r$   r*   r+   rX   r   r   r   r   Ú<module>   s(   0


f