o e@sdZddlZddlmZddlmZedZdZdZ d Z ed e d ej Z d Z ed e e ej ZddZddZddZddZiZiZeddD]ZeeZeee<eee<qNddZddZddZddZdd Zd!d"Zd#d$Zd%d&Z dS)'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})(?=,?)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).0xrrF/var/www/html/venv/lib/python3.10/site-packages/openpyxl/utils/cell.py 'z'get_column_interval..r) isinstancestrcolumn_index_from_stringrange)startendrrr get_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_stringrmsgcolumnrowrrr coordinate_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 rangermax_colmax_rowz%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}Nr) ABSOLUTE_REr ValueError groupdictitemsformat)rmdkvfmtrrr absolute_coordinate8s  r.cCszd|kr dksntd|g}|dkr6t|d\}}|dkr)d}|d8}|t|d|dksdt|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 remainderrrr _get_column_letterJs r:igGcCs(zt|WStytd|w)z?Convert a column index into a column letter (3 -> 'C') r/)_STRING_COL_CACHEKeyErrorr%r()idxrrr r is   r cCs,zt|WStytd|w)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_colrrr rss  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_stringrr)min_colmin_rowsepr"r#colsrowsrrr range_boundaries~s<      rIc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)[ Get individual addresses for every cell in a range. Yields one row at a time. rcSrrr r colrrr rrz#rows_from_range..c3s|] }d|VqdSz{0}{1}Nr(rKrrr z"rows_from_range..NrIrtuplerCrDrEr"r#rHrGrrOr rows_from_rangerUc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)rJrcss|]}t|VqdS)Nr rKrrr rPsz"cols_from_range..c3s|] }d|VqdSrMrN)r rrLrr rPrQNrRrTrrWr cols_from_rangerVrXcCsJt|D] \}}|tvrnq|d|}||d}t|t|fS)zB Convert an Excel style coordinate to (row, column) tuple N) enumeraterr?rr>) coordinater=crLrrrr coordinate_to_tuples r\cCsHt|}|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%grouprI)rCr) sheetnamer_ boundariesrrr range_to_tuples  rdcCs"d|vr |dd}d|}|S)z> Add quotes around sheetnames if they contain spaces. 'z''z'{0}')replacer()rbrrr quote_sheetnames  rg)!__doc__restringr exceptionsrcompiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr$ SHEET_TITLEr(r`rr r.r:r>r;rirLr rrIrUrXr\rdrgrrrr sB      +