Ë
|
dñúh7 ã óð d Z ddlmZ ddlmZmZ ddlmZmZ ddl Z ddl
|
m Z e j d« Z d Zd
|
Zd Z e j d ez d z e j" « ZdZ e j dj) ee« e j" « Zd Zd Zd Zdg ee« z Z ed¬« d « Z e ed« D ci c] \ } }||
|
c}} Z dZ ed¬« d « Z d Z d Z!d Z"d Z#d Z$d Z%yc c}} w ) zT
|
Collection of utilities used within the package and also available for client code
|
é )Ú lru_cache)ÚchainÚproduct)Úascii_uppercaseÚdigitsNé )ÚCellCoordinatesExceptionz ^[$]?([A-Za-z]{1,3})[$]?(\d+)$z[A-Z]{1,3}:[A-Z]{1,3}:z\d+:\d+:zq
|
[$]?(?P<min_col>[A-Za-z]{1,3})?
|
[$]?(?P<min_row>\d+)?
|
(:[$]?(?P<max_col>[A-Za-z]{1,3})?
|
[$]?(?P<max_row>\d+)?)?
|
ú^ú$z7
|
(('(?P<quoted>([^']|'')*)')|(?P<notquoted>[^'^ ^!]*))!z{0}(?P<cells>{1})(?=,?)c óÄ t | t « r t | « } t |t « r t |« }t | |dz « D cg c] }t |« c}S c c}w )z¤
|
Given the start and end columns, return all the columns in the series.
|
|
The start and end columns can be either column letters or 1-based
|
indexes.
|
r )Ú
|
isinstanceÚstrÚcolumn_index_from_stringÚrangeÚget_column_letter)ÚstartÚendÚxs úFH:\Change_password\venv_build\Lib\site-packages\openpyxl/utils/cell.pyÚget_column_intervalr sQ ô %Ô Ü(¨Ó/Ü#sÔÜ& sÓ+Ü*/°°s¸Q±wÓ*?Ö @ QÔ aÕ Ò @Ð@ùÒ @s ÁA c ó¼ t j | « }|sd| d}t |« |j « \ }}t |« }|sd| d}t |« ||fS )z;Convert a coordinate string like 'B12' to a tuple ('B', 12)zInvalid cell coordinates (ú)zThere is no row 0 ()ÚCOORD_REÚmatchr ÚgroupsÚint)Ú coord_stringr ÚmsgÚcolumnÚrows r Úcoordinate_from_stringr! , sj ä NN<Ó (EÙ Ø*¨<¨.¸Ð:Ü& sÓ+Ð+Ø,,.KFCÜ
|
c(CÙ Ø# L >°Ð3Ü& sÓ+Ð+Ø 3;Ðó c óö t j | « }|st | d« |j d« }|j « D ] \ }}|s d| ||< |d s|d rd}nd} |j
|
di |¤S ) zDConvert a coordinate to an absolute coordinate string (B12 -> $B$12)z is not a valid coordinate rangeÚ r Úmax_colÚmax_rowz%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}© )Ú ABSOLUTE_REr Ú
|
ValueErrorÚ groupdictÚitemsÚformat)r ÚmÚdÚkÚvÚfmts r Úabsolute_coordinater2 : s ä×Ñ,Ó'AÙ ÜL>Ð)IÐJÓKÐKà BAØ ò 1Ú Øqc7AaDðð |q|Ø5à"Ø 3::??Ðr" r$ )Úmaxsizec ó d| cxk rdk s n t dj | « « g }| dk r t | S | rDt | d« \ } }|j dt | « |s| dz } |j dd« | rDdj |« S )aÎ
|
Convert decimal column position to its ASCII (base 26) form.
|
|
Because column indices are 1-based, strides are actually pow(26, n) + 26
|
Hence, a correction is applied between pow(26, n) and pow(26, 2) + 26 to
|
prevent and additional column letter being prepended
|
|
"A" == 1 == pow(26, 0)
|
"Z" == 26 == pow(26, 0) + 26 // decimal equivalent 10
|
"AA" == 27 == pow(26, 1) + 1
|
"ZZ" == 702 == pow(26, 2) + 26 // decimal equivalent 100
|
r ifG zInvalid column index {0}é r ÚZr$ )r) r, Ú__decimal_to_alphaÚdivmodÚinsertÚjoin)Úcol_idxÚresultÚ remainders r r r N s ð Ô 5Ô ÜÐ3×:Ñ:¸7ÓCÓDÐDà Fà|Ü! 'Ñ*Ð*á
|
Ü # G¨RÓ 0ÑØ aÔ+¨IÑ6Ô7ÙØ qLGØ MM!SÔ !ò ð 776?Ðr" )r r5 i¤ c óB d| d}t | « dkD r t |« d}t | j « « } t | t
|
« D ] \ }} t | }|||z z } d|cxk rdk st |« t |« |S # t $ r t |« w xY w)zÊ
|
Convert ASCII column name (base 26) to decimal with 1-based index
|
|
Characters represent descending multiples of powers of 26
|
|
"AFZ" == 26 * pow(26, 0) + 6 * pow(26, 1) + 1 * pow(26, 2)
|
ú'z<' is not a valid column name. Column names are from A to ZZZé r igG )Úlenr) ÚreversedÚupperÚzipÚ__powersÚ__alpha_to_decimalÚKeyError)ÚcolÚ error_msgÚidxÚletterÚpowerÚposs r r r r sÀ ð C5ÐTÐUIÜ
|
3x!|ÜÓ#Ð#Ø
|
CÜ
|
399;Ó
|
CÜ S¤(Ó+ò ð (Ü$ VÑ,Cð sU{Ñð ð s?U?ÜÓ#Ð#ð ÜÓ#Ð#Ø Jøô ò (Ü YÓ'Ð 'ð (ús Á B Â B c ó² dj | « }t j | « }|s t |« |j « \ }}}}}|rM||f}||f} t || z « s7t |« r t | « r!t | « r t |« r t |« | t |« }| t |« }| t |« }n|}| t |« }n|}||||fS )z³
|
Convert a range string into a tuple of boundaries:
|
(min_col, min_row, max_col, max_row)
|
Cell coordinates will be converted into a range with the cell at both end
|
z&{0} is not a valid coordinate or range) r, r( r r) r ÚallÚanyr r )
|
Ú range_stringr r- Úmin_colÚmin_rowÚsepr% r& ÚcolsÚrowss
|
r Úrange_boundariesrW sç ð 3×
|
9Ñ
|
9¸,Ó
|
GCÜ×Ñ,Ó'AÙ ÜoÐ à./¯h©h«jÑ+GWc7 Gá
|
ØÐ ØÐ ô t Ô Ü Ic $iÜ Ic $iä S/Ð !àÐÜ*¨7Ó3àÐÜg,àÐÜ*¨7Ó3ààÐÜg,àà GW gÐ -Ð-r" c # óÚ K t | « \ }}}}t ||dz « }t ||dz « D cg c] }t |« }}|D ] t fd|D « « yc c}w w)ú[
|
Get individual addresses for every cell in a range.
|
Yields one row at a time.
|
r c 3 óB K | ] }d j |« yw©z{0}{1}N©r, )Ú.0rH r s r ú <genexpr>z"rows_from_range.<locals>.<genexpr>¿ ó øè ø Ò>°#HOO C¨×-Ñ>ùó N)rW r r Útuple) rQ rR rS r% r& rV rH rU r s @r Úrows_from_rangerb ¶ sv øè ø ô
|
*:¸,Ó)GÑ&GWgwÜ ' A+Ó &DÜ.3°G¸WÀq¹[Ó.IÖ J sÔ cÕ "Ð JDÐ JØò ?ÜÓ>¸Ô>Ó>Ó>ñ?ùò Kùs 1A+´A&Á%A+c # ó² K t | « \ }}}}t ||dz « }d t ||dz « D « }|D ] t fd|D « « yw)rY r c 3 ó2 K | ] }t |« y w)N)r )r] rH s r r^ z"cols_from_range.<locals>.<genexpr>É s è ø Ò H sÔ c× "Ñ Hùs c 3 óB K | ] }d j |« ywr[ r\ )r] r rH s r r^ z"cols_from_range.<locals>.<genexpr>Ë r_ r` N)rW r ra )rQ rR rS r% r& rV rU rH s @r Úcols_from_rangerf  sa øè ø ô
|
*:¸,Ó)GÑ&GWgwÜ ' !)Ó $DÙ H¬e°G¸WÀQ¹YÓ.GÔ HDØò ?ÜÓ>¸Ô>Ó>Ó>ñ?ùs AAc ó| t | « D ] \ }}|t v s n | d }| |d }t |« t |« fS )zB
|
Convert an Excel style coordinate to (row, column) tuple
|
N)Ú enumerater r r )Ú
|
coordinaterJ ÚcrH r s r Úcoordinate_to_tuplerk Î sU ô JÓ'ò QØ ;Ù ðð TcÐ
|
CØ
|
STÐ
|
CÜ s8Ô-¨cÓ2Ð 2Ð2r" c óÎ t j | « }| t d« |j d« xs |j d« }|j d« }t |« }||fS )zc
|
Convert a worksheet range to the sheetname and maximum and minimum
|
coordinate indices
|
z)Value must be of the form sheetname!A1:E4ÚquotedÚ notquotedÚcells)Ú SHEETRANGE_REr r) ÚgrouprW )rQ r- Ú sheetnamero Ú
|
boundariess r Úrange_to_tuplert Ú sd ô
|
×ÑLÓ)AØyÜÐDÓEÐEØÓ!Ò9 Q§W¡W¨[Ó%9IØ GGGÓ EÜ! %Ó(JØ jÐ Ð r" c óT d| v r| j dd« } dj | « } | S )z>
|
Add quotes around sheetnames if they contain spaces.
|
r? z''z'{0}')Úreplacer, )rr s r Úquote_sheetnamerw è s2 ð iÑØ ×%Ñ% c¨4Ó0 à Ó*IØ Ðr" )&Ú__doc__Ú functoolsr Ú itertoolsr r Ústringr r ÚreÚ
|
exceptionsr Úcompiler Ú COL_RANGEÚ ROW_RANGEÚ
|
RANGE_EXPRÚVERBOSEr( Ú SHEET_TITLEr, rp r r! r2 Úlistr7 r rh rF rE r rW rb rf rk rt rw )rM rK s 00r ú<module>r
s2 ðñõ ß $ß *Û å 0ð 2::Ð7Ó 8Ø ( Ø ð
|
ð bjjzÑ)¨3Ñ.°·
|
±
|
Ó; ð: à
|
|
Ð8×?Ñ?Øó Ø jjó* ò Aò ò ð$ TD Ó 1Ñ1Ð á
|
4Ôñ ó ð ñ@ 5>¸oÈqÓ4Q×R¡[ S¨&fSjÓRÐ Ø á
|
4Ôñó ðò0(.òV ?ò ?ò 3ò !ó ùós Ss Â= C2
|
