o g7@s dZddlmZddlmZmZddlmZmZddl Z ddl m Z e dZ d Zd Zd Ze d ed e jZdZe deee jZddZddZddZdgeeZeddddZddeedDZdZeddddZdd Z d!d"Z!d#d$Z"d%d&Z#d'd(Z$d)d*Z%dS)+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})(?=,?)cCs<t|tr t|}t|trt|}ddt||dDS)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. cSg|]}t|qSget_column_letter).0xr r M/var/www/html/api-tag/env/lib/python3.10/site-packages/openpyxl/utils/cell.py )z'get_column_interval..r) isinstancestrcolumn_index_from_stringrange)startendr r rget_column_intervals  rcCsVt|}|sd|d}t||\}}t|}|s'd|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_stringrmsgcolumnrowr r rcoordinate_from_string,s    r$cCstt|}|st|d|d}|D] \}}|r$d|||<q|ds-|dr0d}nd}|jd i|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}Nr ) ABSOLUTE_REr ValueError groupdictitemsformat)r mdkvfmtr r rabsolute_coordinate:s  r2r%)maxsizecCsd|kr dksntd|g}|dkrt|S|r;t|d\}}|dt||s9|d8}|dd|sd|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 remainderr r rrNs  rcCsi|]\}}||qSr r )rposletterr r r osr?)rr4ic Csd|d}t|dkrt|d}t|}t|tD]\}}zt|}Wn ty2t|w|||7}qd|krGdksLt|t||S)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_msgidxr>powerr=r r rrrs"    rc Csd|}t|}|st||\}}}}}|r=||f}||f} t|| s=t|r1t| r=t| r9t|r=t||durEt|}|durMt|}|durVt|}n|}|durat|}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 rangeN) r,r(rr)rallanyrr) range_stringr!r-min_colmin_rowsepr&r'colsrowsr r rrange_boundariess<      rUc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)[ Get individual addresses for every cell in a range. Yields one row at a time. rcSr r r rrIr r rrrz#rows_from_range..c3s|] }d|VqdSz{0}{1}Nr,rWr#r r z"rows_from_range..NrUrtuplerOrPrQr&r'rTrSr rZrrows_from_ranger`c#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)rVrcss|]}t|VqdS)Nr rWr r rr[sz"cols_from_range..c3s|] }d|VqdSrXrY)rr#rIr rr[r\Nr]r_r rbrcols_from_rangerarccCsFt|D] \}}|tvrnq|d|}||d}t|t|fS)zB Convert an Excel style coordinate to (row, column) tuple N) enumeraterrr) coordinaterKcrIr#r r rcoordinate_to_tuples  rgcCsHt|}|dur 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)grouprU)rOr- sheetnamerj boundariesr r rrange_to_tuples  rocCs"d|vr |dd}d|}|S)z> Add quotes around sheetnames if they contain spaces. r@z''z'{0}')replacer,)rmr r rquote_sheetnames  rq)&__doc__ functoolsr itertoolsrrstringrrre exceptionsrcompiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr( SHEET_TITLEr,rkrr$r2listr6rrdrGrFrrUr`rcrgrorqr r r rsB      +