S!h7dZddlmZddlmZmZddlmZmZddl Z ddl m Z e jdZ d Zd Zd Ze jd ezd ze j"ZdZe jdj)eee j"ZdZdZdZdgeezZeddZeedDcic]\}}|| c}}ZdZeddZdZ dZ!dZ"dZ#dZ$dZ%ycc}}w)zT Collection of utilities used within the package and also available for client code ) lru_cache)chainproduct)ascii_uppercasedigitsN)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 Q/var/www/skyplay_api_hub/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_REmatchr groupsint) 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 ranger max_colmax_rowz%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}) ABSOLUTE_REr ValueError groupdictitemsformat)rmdkvfmts rabsolute_coordinater2:s,'A L>)IJKK BA 1 qc7AaD |q|5" 3::??r"r$)maxsizecd|cxkrdksntdj|g}|dkr 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 rifGzInvalid column index {0}rZr$)r)r,__decimal_to_alphadivmodinsertjoin)col_idxresult remainders rrrNs  5 3::7CDD F|!'** #GR0 a+I67 qLG MM!S !  776?r")rr5icBd|d}t|dkDr t|d}t|j}t |t D]\}} t |}|||zz }d|cxkrdkst|t||S#t$r t|wxYw)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 ZZZrigG)lenr)reversedupperzip__powers__alpha_to_decimalKeyError)col error_msgidxletterpowerposs rrrrsC5TUI 3x!|## C 399; CS(+  ($V,C sU{  s?U?## ## J  (Y' ' (s  B  Bcdj|}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)rallanyrr) range_stringrr-min_colmin_rowsepr%r&colsrowss rrange_boundariesrWs 3 9 9, GC,'A o./hhj+GWc7G  t  Ic$i Ic$iS/ !*73g,*73g, GWg --r"c#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,).0rHr s r z"rows_from_range..>#HOOC->N)rWrrtuple) rQrRrSr%r&rVrHrUr s @rrows_from_rangerbsv *:,)G&GWgw 'A+ &D.3GWq[.I Js c " JD J?>>>>? Ks1A+A&%A+c#Kt|\}}}}t||dz}dt||dzD}|D]tfd|Dyw)rYrc32K|]}t|yw)N)r)r]rHs rr^z"cols_from_range..s Hs c " Hsc3BK|]}dj|ywr[r\)r]r rHs rr^z"cols_from_range..r_r`N)rWrra)rQrRrSr%r&rVrUrHs @rcols_from_rangerfsa *:,)G&GWgw '!) $D HeGWQY.G HD?>>>>?sAAc|t|D]\}}|tvsn|d}||d}t|t|fS)zB Convert an Excel style coordinate to (row, column) tuple N) enumeraterrr) coordinaterJcrHr s rcoordinate_to_tuplerksUJ'Q ;  Tc C ST C s8-c2 22r"ctj|}| 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)grouprW)rQr- sheetnamero boundariess rrange_to_tuplertsd L)AyDEE!9QWW[%9I GGG E!%(J j  r"cTd|vr|jdd}dj|}|S)z> Add quotes around sheetnames if they contain spaces. r?z''z'{0}')replacer,)rrs rquote_sheetnamerws2 i%%c40  *I r")&__doc__ functoolsr itertoolsrrstringrrre exceptionsr compiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr( SHEET_TITLEr,rprr!r2listr7rrhrFrErrWrbrfrkrtrw)rMrKs00rrs2 $* 0 2::7 8 (   bjjz)3. ; :  8?? jj*  A $TD11 4@5>oq4QR[S&fSjR  40(.V ? ? 3 !sSs= C2