o b<@sdZddlZddlmZedZdZdZdZed ed ej Z d Z ed e eej Z d dZddZddZddZiZiZeddD]ZeeZeee<eee<qHddZddZddZddZddZd d!Zd"d#Zd$d%ZdS)&zT Collection of utilities used within the package and also available for client code N)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).0xrrR/var/www/secure340b-portal/env/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    rcCstt|}|std||d}|D] \}}|r$d|||<q|ds-|dr0d}nd}|jd i|S) zDConvert a coordinate to an absolute coordinate string (B12 -> $B$12)z#{0} is not a valid coordinate rangez${0}max_colmax_rowz%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}Nr) ABSOLUTE_REr ValueErrorformat groupdictitems)rmdkvfmtrrr absolute_coordinate7s  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)Zcol_idxletters remainderrrr _get_column_letterJs r8igGcCs(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%)Zstr_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<      rFc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)[ Get individual addresses for every cell in a range. Yields one row at a time. rcSrrrr colrrr r rz#rows_from_range..c3s|] }d|VqdSz{0}{1}Nr%rHrrr z"rows_from_range..NrFrtupler@rArBr!r"rErDrrLr rows_from_rangerRc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)rGrcss|]}t|VqdS)NrrHrrr rMsz"cols_from_range..c3s|] }d|VqdSrJrK)r rrIrr rMrNNrOrQrrTr cols_from_rangerSrUcCs*t|}|dd\}}t|t|fS)zA Convert an Excel style coordinate to (row, colum) tuple r)rsplitrr<)Z coordinaterrIrrrr coordinate_to_tuples rXcCsHt|}|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:E4quotedZ notquotedcells) SHEETRANGE_RErr$grouprF)r@r( sheetnamerZZ boundariesrrr range_to_tuples  r^cCs"d|vr |dd}d|}|S)z> Add quotes around sheetnames if they contain spaces. 'z''z'{0}')replacer%)r]rrr quote_sheetnames  ra)__doc__re exceptionsrcompilerZ COL_RANGEZ ROW_RANGEZ RANGE_EXPRVERBOSEr#Z SHEET_TITLEr%r[rrr-r8r<r9rirIr rrFrRrUrXr^rarrrr s@     +