o ?Z@sddlmZ ddlZddlmZddlmZedZdZ dZ d Z ed e d ej Z d Zed ee ej ZddZddZddZddZiZiZeddD]ZeeZeee<eee<qSddZddZddZddZdd Zd!d"Zd#d$Z d%d&Z!dS)')absolute_importN) basestring)CellCoordinatesExceptionz^[$]?([A-Z]+)[$]?(\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 colums, 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 E/var/www/html/env/lib/python3.10/site-packages/openpyxl/utils/cell.py (z'get_column_interval..r) isinstancercolumn_index_from_stringrange)startendr r rget_column_intervals  rcCsRt|}|sd|}t||\}}t|}|s%d|}t|||fS)z;Convert a coordinate string like 'B12' to a tuple ('B', 12)zInvalid cell coordinates (%s)zThere is no row 0 (%s))COORD_REmatchupperrgroupsint) coord_stringrmsgcolumnrowr r rcoordinate_from_string+s r cCsrt|}|s td|d}|D] \}}|r#d|||<q|ds,|dr/d}nd}|jd i|S) zDConvert a coordinate to an absolute coordinate string (B12 -> $B$12)z%Value 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_RErr ValueError groupdictitemsformat)rmdkvfmtr r rabsolute_coordinate9s 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 remainderr r r_get_column_letterKs r:igGcCs(zt|WStytd|w)z?Convert a column index into a column letter (3 -> 'C') r/)_STRING_COL_CACHEKeyErrorr%r()idxr r rr js   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_CACHErr<r%r()str_colr r rrts  rcCst|}|s td|\}}}}}|durt|}|dur$t|}|dur-t|}n|}|dur8t|}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$rr%rrr) range_stringr)min_colmin_rowsepr"r#r r rrange_boundariess    rDc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)[ Get individual addresses for every cell in a range. Yields one row at a time. rcSrr r r colr r rrrz#rows_from_range..c3s|] }d|VqdSz{0}{1}Nr(rFrr r z"rows_from_range..NrDrtupler@rArBr"r#rowscolsr rJrrows_from_rangerRc#s^t|\}}}}t||d}ddt||dD}|D]tfdd|DVqdS)rErcss|]}t|VqdS)Nr rFr r rrKsz"cols_from_range..c3s|] }d|VqdSrHrI)r rrGr rrKrLNrMrOr rTrcols_from_rangerSrUcCst|\}}|t|fS)zA Convert an Excel style coordinate to (row, colum) tuple )r r>) coordinaterGrr r rcoordinate_to_tuples  rWcCsHt|}|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%grouprD)r@r) sheetnamerZ boundariesr r rrange_to_tuples  r_cCsBd|vr |dd}d|vsd|vsd|vsd|vrd|}|S)z> Add quotes around sheetnames if they contain spaces. 'z'' -,z'{0}')replacer()r]r r rquote_sheetnames  re)" __future__rreopenpyxl.compatr exceptionsrcompiler COL_RANGE ROW_RANGE RANGE_EXPRVERBOSEr$ SHEET_TITLEr(r[rr r.r:r>r;rirGr rrDrRrUrWr_rer r r rsD