h7SrSSKJr SSKJrJr SSKJrJr SSK r SSK J r \ R"S5r S rS rS r\ R"S \-S -\ R"5rSr\ R"SR)\\5\ R"5rSrSrSrS/\"\5-r\"SS9S5r\"\S5VVs0sHupX_M snnrSr\"SS9S5rSr Sr!Sr"Sr#Sr$Sr%gs snnf)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})(?=,?)c[U[5(a [U5n[U[5(a [U5n[XS-5Vs/sHn[ U5PM sn$s snf)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 E/var/www/html/env/lib/python3.13/site-packages/openpyxl/utils/cell.pyget_column_intervalrs[%(/#s&s+*/Qw*? @*?Q a *? @@ @sA)c[RU5nU(dSUS3n[U5eUR5up4[ U5nU(dSUS3n[U5eX44$)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!,sf NN< (E *<.:&s++,,.KF c(C #L>3&s++ ;c [RU5nU(d[US35eURS5nUR 5Hup4U(dMSU3X#'M US(d US(aSnOSnUR "S0UD6$) 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  1qc7AD |q|5" ::??r"r$)maxsizecBSUs=::aS::dO [SRU55e/nUS:a [U$U(aN[US5upUR S[U5 U(dUS-nUR SS5 U(aMNSR U5$)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")rr5ic6SUS3n[U5S:a [U5eSn[UR55n[ U[ 5Hup4[ UnX%U-- nM SUs=:aS:d O [U5eU$![a [U5ef=f)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 U{ , s?U?## J  (Y' ' (s  BBcSRU5n[RU5nU(d [U5eUR 5up4pVnU(acX64nXG4n [ X-5(dK[ U5(a[ U 5(a+[ U 5(a[ U5(a [U5eUb [U5nUb [U5nUb [U5nOUnUb [U5nOUnX4Xg4$)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+GcG     IIc$ii IIc$iiS/ !*73g,*73g, W --r"c#^# [U5upp4[X$S-5n[XS-5Vs/sHn[U5PM nnUHm[U4SjU55v M gs snf7f)O Get individual addresses for every cell in a range. Yields one row at a time. rc3H># UHnSRUT5v M g7fz{0}{1}Nr,).0rHr s r "rows_from_range..>#HOOC--"N)rWrrtuple) rQrRrSr%r&rVrHrUr s @rrows_from_rangercsk *:,)G&Gg A+ &D.3Gq[.I J.Is c ".ID J>>>> Ks-A-A((A-c#^# [U5upp4[X$S-5nS[XS-55nUHm[U4SjU55v M g7f)rYrc38# UHn[U5v M g7f)N)r)r]rHs rr^"cols_from_range..s H.Gs c " ".Gsc3H># UHnSRTU5v M g7fr[r\)r]r rHs rr^rfr`raN)rWrrb)rQrRrSr%r&rVrUrHs @rcols_from_rangerhsS *:,)G&Gg !) $D HeGQY.G HD>>>>sAAc[U5HupU[;dM O USWnXSn[U5[U54$)z: Convert an Excel style coordinate to (row, column) tuple N) enumeraterrr) coordinaterJcrHr s rcoordinate_to_tuplermsLJ' ; ( Tc C T C s8-c2 22r"c[RU5nUc [S5eURS5=(d URS5nURS5n[ U5nX$4$)zW 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- sheetnamerq boundariess rrange_to_tuplervsb L)AyDEE!9QWW[%9I GGG E!%(J   r"cXSU;aURSS5nSRU5nU$)z6 Add quotes around sheetnames if they contain spaces. r?z''z'{0}')replacer,)rts rquote_sheetnamerys2 i%%c40  *I r")&__doc__ functoolsr itertoolsrrstringrrre exceptionsr compiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr( SHEET_TITLEr,rrrr!r2listr7rrjrFrErrWrcrhrmrvry)rMrKs00rrs. $* 0 ::7 8 (   jjz)3. ; :  8?? jj*  A $TD11 4@5>oq4QR4Q[Sfj4QR  40(.V ? ? 3 !sSs:C-