^b~dZddlZddlmZddlmZejdZdZdZ d Z ejd e zd zej Z d Z ejd e e ej ZdZdZdZdZiZiZeddD]ZeeZeee<eee<dZdZdZdZdZdZdZdZ dS)zT Collection of utilities used within the package and also available for client code N)digits)CellCoordinatesExceptionz^[$]?([A-Za-z]{1,3})[$]?(\d+)$z[A-Z]{1,3}:[A-Z]{1,3}:z\d+:\d+:zq [$]?(?P[A-Za-z]{1,3})? [$]?(?P\d+)? (:[$]?(?P[A-Za-z]{1,3})? [$]?(?P\d+)?)? ^$z7 (('(?P([^']|'')*)')|(?P[^'^ ^!]*))!z{0}(?P{1})(?=,?)ct|trt|}t|trt|}dt||dzDS)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. c,g|]}t|Sget_column_letter).0xs 3lib/python3.11/site-packages/openpyxl/utils/cell.py z'get_column_interval..'s! @ @ @Q a @ @ @r) isinstancestrcolumn_index_from_stringrange)startends rget_column_intervalrsd%0(//#s,&s++ @ @%sQw*?*? @ @ @@rct|}|sd|d}t||\}}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_REmatchrgroupsint) coord_stringrmsgcolumnrows rcoordinate_from_stringr#*s NN< ( (E ,:<:::&s+++,,..KFC c((C ,3L333&s+++ 3;rct|}|st|d|d}|D]\}}|rd|||<|ds|drd}nd}|jdi|S) zDConvert a coordinate to an absolute coordinate string (B12 -> $B$12)z is not a valid coordinate rangermax_colmax_rowz%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}r ) ABSOLUTE_REr ValueError groupdictitemsformat)rmdkvfmts rabsolute_coordinater28s,''A LLJJJKKK BA 1  q77AaD|#q|#5" 3:????rcNd|cxkrdks$ntd|g}|dkrKt|d\}}|dkrd}|dz}|t |dz|dkKdt |S)zConvert a column number into a column letter (3 -> 'C') Right shift the column col_idx by 26 to find column letters in reverse order. These numbers are 1-based, and can be converted to ASCII ordinals by adding 64. rifGInvalid column index {0}r@r%)r)r,divmodappendchrjoinreversed)col_idxletters remainders r_get_column_letterr?Js EEEE5EEEE3::7CCDDDG A+*#GR00 > I qLGs9R<(())) A+* 778G$$ % %%rigGc~ t|S#t$r#td|wxYw)z?Convert a column index into a column letter (3 -> 'C') r4)_STRING_COL_CACHEKeyErrorr)r,)idxs rr r isOA %% AAA3::3??@@@As -<c t|S#t$r#td|wxYw)z@Convert a column name into a numerical index ('A' -> 1) z{0} is not a valid column name)_COL_STRING_CACHEupperrBr)r,)str_cols rrrssW K 11 KKK9@@IIJJJKs !-Ac$d|}t|}|st||\}}}}}|re||f}||f} t || zsKt |rt | r-t | rt |rt||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(rr)rallanyrr) range_stringr r-min_colmin_rowsepr&r'colsrowss rrange_boundariesrQ~s? 3 9 9, G GC,''A oo./hhjj+GWc7G " t   " II "!$ii " II ""$ii " S// !4*733g,,*733g,, GWg --rc#Kt|\}}}}t||dz}dt||dzD}|D]tfd|DV dS)[ Get individual addresses for every cell in a range. Yields one row at a time. rc,g|]}t|Sr r r cols rrz#rows_from_range..s! J J Js c " " J J Jrc3DK|]}d|VdSz{0}{1}Nr,)r rVr"s r z"rows_from_range..1>>#HOOC-->>>>>>rNrQrtuple)rKrLrMr&r'rPrOr"s @rrows_from_ranger^s *:,)G)G&GWgw 'A+ & &D J JeGWq[.I.I J J JD??>>>>>>>>>>>>>??rc#Kt|\}}}}t||dz}dt||dzD}|D]tfd|DV dS)rSrc34K|]}t|VdS)Nr rUs rrZz"cols_from_range..s+ H Hs c " " H H H H H Hrc3DK|]}d|VdSrXrY)r r"rVs rrZz"cols_from_range..r[rNr\)rKrLrMr&r'rPrOrVs @rcols_from_rangerbs *:,)G)G&GWgw '!) $ $D H HeGWQY.G.G H H HD??>>>>>>>>>>>>>??rct|D]\}}|tvrn|d|}||d}t|t|fS)zA Convert an Excel style coordinate to (row, colum) tuple N) enumeraterrFrrE) coordinaterCcrVr"s rcoordinate_to_tuplergstJ''Q ;  E  TcT  " "C STT C s88&s+ ++rct|}|td|dp|d}|d}t |}||fS)zc Convert a worksheet range to the sheetname and maximum and minimum coordinate indices Nz)Value must be of the form sheetname!A1:E4quoted notquotedcells) SHEETRANGE_RErr)grouprQ)rKr- sheetnamerk boundariess rrange_to_tuplerpsz L))AFDEEE!!9QWW[%9%9I GGG  E!%((J j  rcdd|vr|dd}d|}|S)z> Add quotes around sheetnames if they contain spaces. 'z''z'{0}')replacer,)rns rquote_sheetnamerts= i1%%c400  **I r)!__doc__restringr exceptionsrcompiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr( SHEET_TITLEr,rlrr#r2r?rErArirVr rrQr^rbrgrprtr rrrs 000000 2:7 8 8 (   bjz)3. ;; :  8?? j**  A A A   $&&&. q%A  Q  CacAAAKKK(.(.(.V ? ? ? ? ? ? , , , ! ! !r