B
    ÔùÓ`á  ã               @   s€   d dl Z e  e jd¡Zeedœdd„Ze  ed ge ¡Ze  ed ge ¡Zdd„ Ze	dœd	d
„Z
e	dœdd„Ze	dœdd„ZdS )é    NifG  )Úcol_string_cacheÚstring_col_cachec             C   s  ddl m} d } } }}|d  } } }	}
xÐtdtd ƒD ]¾}|| }|dkrb|	|
 | }n(|dkrt|
| }n|dkr†|| }n|}|||< || |< |d7 }|dkr@d}|d7 }|dkrîd}|d7 }|dkræd}|d7 }|| }	|| }|| }|| }
q@W d S )Nr   )Úascii_uppercaseé   i¨D  i¤  é   )Ústringr   ÚrangeÚMAX_COL_INDEX)r   r   ÚlettersZletter0Zletter1Zletter2Zletter3Zch1Zch2Zch3ÚprefixÚiZch0Úcol© r   ú9/tmp/pip-unpacked-wheel-zhp1095k/openpyxl/utils/_accel.pyÚcache_column_letters	   s8    

r   c             C   s@   t  t j| ¡}d|  kr"tkr.n nt| S td| › �ƒ‚dS )z?Convert a column index into a column letter
    (3 -> 'C')
    r   zInvalid column index N)ÚcythonÚcastÚintr	   Ú_STRING_COL_CACHEÚ
ValueError)ÚidxZint_idxr   r   r   Úget_column_letter2   s    r   )Ústr_colc             C   s¨   d}t d }x|| D ]t}d|  kr*dkr@n nt|ƒtdƒ }n0d|  krTdkrjn nt|ƒtdƒ }n|}P |d | }||krP qW ||kr t| › d�ƒ‚t| S )	z@Convert a column name into a numerical index
    ('A' -> 1)
    r   r   ÚAÚZÚaÚzr   z is not a valid column name)r	   Úordr   Ú_COL_STRING_CACHE)r   r   ÚinvalidÚchÚdigitr   r   r   Úcolumn_index_from_string<   s    
r"   )Ú
coordinatec             C   sx  t | ƒ}d|  krdks,n td| › �ƒ‚| d dkr<dnd}|}d}x~||k rÆ| | }d|  krndkr„n nt|ƒtdƒ }n,d	|  kr˜d
kr®n nt|ƒtd	ƒ }nP |d | }|d7 }qJW ||ksÜ||d krêtd| › �ƒ‚| | dkrþ|d7 }d}xT||k �rVd| |   k�r*dk�rVn n(|d t| | ƒtdƒ  }|d7 }�qW ||k �rptd| › �ƒ‚||fS )zA
    Convert an Excel style coordinate to (row, colum) tuple
    é   é   zinvalid coordinate: r   ú$r   r   r   r   r   r   é   Ú0Ú9é
   )Úlenr   r   )r#   ÚlengthÚstartr   r   r    r!   Úrowr   r   r   Úcoordinate_to_tupleS   s4    
,
r/   )Úvaluec             C   sŽ   d}dt  t j¡d d  }|d }xT| D ]L}|dkr>t| ƒS |dkrr||d krX|}qv|d t|ƒtdƒ  }q*|}q*W ||k r†|S t| ƒS )z6
    Convert numbers as string to an int or float
    r   r$   é   r*   z.eEÚ
0123456789r(   )r   ÚsizeofÚlongÚfloatr   r   )r0   ZintvalZsafe_max_longZ	too_larger    r   r   r   Úcast_number{   s    
r6   )r   Zdeclarer   r	   Úlistr   r   r   r   Ústrr"   r/   r6   r   r   r   r   Ú<module>   s   $
(