U .Ri7@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|trt|}t|tr$t|}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. cSsg|] }t|qSget_column_letter).0xr r 7/tmp/pip-unpacked-wheel-r0v169r1/openpyxl/utils/cell.py )sz'get_column_interval..r) isinstancestrcolumn_index_from_stringrange)startendr r rget_column_intervals   rcCsVt|}|s"d|d}t||\}}t|}|sNd|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"cCspt|}|st|d|d}|D]\}}|r.d|||<q.|dsZ|dr`d}nd}|jf|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}) ABSOLUTE_REr ValueError groupdictitemsformat)rmdkvfmtr r rabsolute_coordinate:s  r0r#)maxsizecCs~d|krdks$ntd|g}|dkr8t|S|rtt|d\}}|dt||s8|d8}|ddq8d|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)Zcol_idxresult remainderr r rr Nsr cCsi|]\}}||qSr r )rposletterr r r osr<)rr2ic Csd|d}t|dkr t|d}t|}t|tD]>\}}z t|}Wntk rjt|YnX|||7}q:d|krdksnt||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|}|s t||\}}}}}|rz||f}||f} t|| szt|rbt| rzt| rrt|rzt||dk rt|}|dk rt|}|dk rt|}n|}|dk rt|}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%colsrowsr r rrange_boundariess<     rRc#s\t|\}}}}t||d}ddt||dD}|D]tfdd|DVq:dS)[ Get individual addresses for every cell in a range. Yields one row at a time. rcSsg|] }t|qSr r rrFr r rrsz#rows_from_range..c3s|]}d|VqdSz{0}{1}Nr*rTr!r r sz"rows_from_range..NrRrtuplerLrMrNr$r%rQrPr rWrrows_from_ranges r\c#s\t|\}}}}t||d}ddt||dD}|D]tfdd|DVq:dS)rSrcss|]}t|VqdS)Nr rTr r rrXsz"cols_from_range..c3s|]}d|VqdSrUrV)rr!rFr rrXsNrYr[r r]rcols_from_ranges r^cCsFt|D]\}}|tkrqq|d|}||d}t|t|fS)zB Convert an Excel style coordinate to (row, column) tuple N) enumeraterrr)Z coordinaterHcrFr!r r rcoordinate_to_tuples   racCsHt|}|dkrtd|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'grouprR)rLr+ sheetnamercZ boundariesr r rrange_to_tuples  rgcCs"d|kr|dd}d|}|S)z> Add quotes around sheetnames if they contain spaces. r=z''z'{0}')replacer*)rfr r rquote_sheetnames  ri)&__doc__ functoolsr itertoolsrrstringrrre exceptionsrcompilerZ COL_RANGEZ ROW_RANGEZ RANGE_EXPRVERBOSEr&Z SHEET_TITLEr*rdrr"r0listr4r r_rDrCrrRr\r^rargrir r r rsB     +