+ i7 Rt^RIHt^RIHtHt^RIHtHt^RI t ^RI H t ] P!R4t RtRtR t] P!R ],R ,] P"4tR t] P!R P)]]4] P"4tRtRtRtR.]!]4,t]!RR7R4t]!]^4UUu/uFwrWbK upptRt]!RR7R4tRt Rt!Rt"Rt#Rt$Rt%R#uuppi)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\V\4'd \V4p\V\4'd \V4p\W^,4Uu.uFp\ V4NK up#uupi)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. ) isinstancestrcolumn_index_from_stringrangeget_column_letter)startendxs&& Z/Users/agent/.openclaw/workspace/.venv/lib/python3.14/site-packages/openpyxl/utils/cell.pyget_column_intervalrs[%(/#s&s+*/Qw*? @*?Q a *? @@ @sA.c\PV4pV'gRV R2p\V4hVP4wr4\ V4pV'gRV R2p\V4hW43#)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,sf NN< (E *<.:&s++,,.KF c(C #L>3&s++ ;c8\PV4pV'g\V R24hVPR4pVP 4Fwr4V'gKRV 2W#&K VR,'gVR,'dRpMRpVP !R/VB#) 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_coordinater0:s,'A L>)IJKK BA  1qc7AD ||q||5" ::??r r")maxsizecZ^Tu;8:dR8:gM\RPV44h.pV^8d\V,#V'dS\V^4wrVP ^\V,4V'dK=V^,pVP ^R4KZRP V4#)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 ifGzInvalid column index {0}Zr")r'r*__decimal_to_alphadivmodinsertjoin)col_idxresult remainders& rrrNs  5 3::7CDD F|!'** #GR0 a+I67y qLG MM!S ! 776?r cVRV R2p\V4^8d \V4h^p\VP44p\ V\ 4F"wr4\ V,pY%T,, pK$ ^Tu;8dR8gM\V4hV# \d \T4hi;i)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 ZZZigG)lenr'reversedupperzip__powers__alpha_to_decimalKeyError)col error_msgidxletterpowerposs& rr r rsC5TUI 3x!|## C 399; CS(+  ($V,C U{ , s?U?## J  (Y' ' (s  BB(cRPV4p\PV4pV'g \V4hVP 4wr4rVpV'dmW63pWG3p \ W,4'gP\ V4'd\ V 4'd.\ V 4'd\ V4'd \V4hVe \V4pVe \V4pVe \V4pMTpVe \V4pMTpW4Wg3#)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_boundariesrSs 3 9 9, GC,'A o./hhj+GcG     IIc$ii IIc$iiS/ !*73g,*73g, W --r c#(a"\V4wrr4\W$^,4p\W^,4Uu.uFp\V4NK ppVF7o\;QJd.V3RlV4FNK 5M!V3RlV44xK9 R#uupi5i)O Get individual addresses for every cell in a range. Yields one row at a time. c3H<"TFpRPVS4xK R#5iz{0}{1}Nr*).0rDrs& r "rows_from_range..>#HOOC--"N)rSrrtuple) rMrNrOr#r$rRrDrQrs & @rrows_from_ranger_sy *:,)G&Gg A+ &D.3Gq[.I J.Is c ".ID Je>>ee>>>> Ks5BB  ABc#a"\V4wrr4\W$^,4pR\W^,44pVF7o\;QJd.V3RlV4FNK 5M!V3RlV44xK9 R#5i)rUc38"TFp\V4xK R#5i)N)r)rYrDs& rrZ"cols_from_range..s H.Gs c " ".Gsc3H<"TFpRPSV4xK R#5irWrX)rYrrDs& rrZrbr\r]N)rSrr^)rMrNrOr#r$rRrQrDs& @rcols_from_rangerdsa *:,)G&Gg !) $D HeGQY.G HDe>>ee>>>>sA9A<c\V4FwrV\9gKM VRXpWRp\V4\V43#)z: Convert an Excel style coordinate to (row, column) tuple N) enumeraterrr ) coordinaterFcrDrs& rcoordinate_to_tuplerisLJ' ; ( Tc C T C s8-c2 22r c\PV4pVf \R4hVPR4;'gVPR4pVPR4p\ V4pW$3#)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'grouprS)rMr+ sheetnamerm boundariess& rrange_to_tuplerrse L)AyDEE!99QWW[%9I GGG E!%(J   r cZRV9dVPRR4pRPV4pV#)z6 Add quotes around sheetnames if they contain spaces. r<z''z'{0}')replacer*)rps&rquote_sheetnamerus2 i%%c40  *I r )i)&__doc__ functoolsr itertoolsrrstringrrre exceptionsrcompiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr& SHEET_TITLEr*rnrrr0listr4rrfrBrAr rSr_rdrirrru)rIrGs00rrs. $* 0 ::7 8 (   jjz)3. ; :  8?? jj*  A $TD11 4@5>oq4QR4Q[Sfj4QR  40(.V ? ? 3 !sSs C?