def cell_to_rowcol2(cell):
 m = _re_cell_ex.match(cell)
 if (not m):
  raise Exception('Error in cell format')
 (col_abs, col, row_abs, row) = m.groups()
 row = (int(row) - 1)
 col = col_by_name(col.upper())
 return (row, col)

def cell_to_rowcol2 ( cell ) : m = _re_cell_ex . match ( cell ) if ( not m ) : raise Exception ( 'Error in cell format' ) ( col_abs , col , row_abs , row ) = m . groups ( ) row = ( int ( row ) - 1 ) col = col_by_name ( col . upper ( ) ) return ( row , col )
convert an excel cell reference string in a1 notation to numeric row/col notation .