2idZddlZddlmZddlmZej dZdZdZ d Z ej d e zd zejZ d Z ej d je e ejZdZdZdZdZiZiZeddD]ZeeZeee<eee<dZdZdZdZdZdZdZdZ y)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|tr t|}t|tr t|}t||dzDcgc] }t |c}Scc}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) isinstancestrcolumn_index_from_stringrangeget_column_letter)startendxs J/var/www/html/acx/venv/lib/python3.12/site-packages/openpyxl/utils/cell.pyget_column_intervalrsQ%(/#s&s+*/sQw*? @Q a @@ @sActj|}|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_REmatchrgroupsint) coord_stringrmsgcolumnrows rcoordinate_from_stringr*sj NN< (E *<.:&s++,,.KFC c(C #L>3&s++ 3;ctj|}|st|d|jd}|j D]\}}|s d|||<|ds|drd}nd}|j di|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}) ABSOLUTE_REr ValueError groupdictitemsformat)rmdkvfmts rabsolute_coordinater.8s,'A L>)IJKK BA 1 qc7AaD |q|5" 3::??rcd|cxkrdksntdj|g}|dkDr>t|d\}}|dk(rd}|dz}|jt |dz|dkDr>dj t |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  5 3::7CDDG A+#GR0 >I qLGs9R<() A+ 778G$ %%rigGcd t|S#t$rtdj|wxYw)z?Convert a column index into a column letter (3 -> 'C') r0)_STRING_COL_CACHEKeyErrorr%r()idxs rr r is;A %% A3::3?@@As $/c t|jS#t$rtdj |wxYw)z@Convert a column name into a numerical index ('A' -> 1) z{0} is not a valid column name)_COL_STRING_CACHEupperr>r%r()str_cols rr r ssA K 11 K9@@IJJKs$=cdj|}tj|}|s t||j \}}}}}|rM||f}||f} t || zs7t |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$rr%rallanyr r) range_stringrr)min_colmin_rowsepr!r"colsrowss rrange_boundariesrM~s 3 9 9, GC,'A o./hhj+GWc7G  t  Ic$i Ic$iS/ !*73g,*73g, GWg --rc#Kt|\}}}}t||dz}t||dzDcgc] }t|}}|D]tfd|Dycc}ww)[ Get individual addresses for every cell in a range. Yields one row at a time. rc3BK|]}dj|ywz{0}{1}Nr().0colrs r z"rows_from_range..>#HOOC->N)rMr r tuple) rGrHrIr!r"rLrTrKrs @rrows_from_rangerYsv *:,)G&GWgw 'A+ &D.3GWq[.I Js c " JD J?>>>>? Ks1A+A&%A+c#Kt|\}}}}t||dz}dt||dzD}|D]tfd|Dyw)rOrc32K|]}t|yw)N)r )rSrTs rrUz"cols_from_range..s Hs c " Hsc3BK|]}dj|ywrQrR)rSrrTs rrUz"cols_from_range..rVrWN)rMr rX)rGrHrIr!r"rLrKrTs @rcols_from_ranger]sa *:,)G&GWgw '!) $D HeGWQY.G HD?>>>>?sAAct|D]\}}|tvsn|dj}||d}t|t|fS)zB Convert an Excel style coordinate to (row, column) tuple N) enumeraterrBrrA) coordinater?crTrs rcoordinate_to_tuplerbs^J'Q ;  Tc  "C ST C s8&s+ ++rctj|}| td|jdxs|jd}|jd}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:E4quoted notquotedcells) SHEETRANGE_RErr%grouprM)rGr) sheetnamerf boundariess rrange_to_tuplerksd L)AyDEE!9QWW[%9I GGG E!%(J j  rcTd|vr|jdd}dj|}|S)z> Add quotes around sheetnames if they contain spaces. 'z''z'{0}')replacer()ris rquote_sheetnameros2 i%%c40  *I r)!__doc__restringr exceptionsrcompiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr$ SHEET_TITLEr(rgrrr.r;rAr=r irTr r rMrYr]rbrkror#rrr{s 0 2::7 8 (   bjjz)3. ; :  8?? jj*  A $&. q%A Q Cac AK(.V ? ? , !r