def cell_to_rowcol(cell):
 m = _re_cell_ex.match(cell)
 if (not m):
  raise Exception(('Ill-formed single_cell reference: %s' % cell))
 (col_abs, col, row_abs, row) = m.groups()
 row_abs = bool(row_abs)
 col_abs = bool(col_abs)
 row = (int(row) - 1)
 col = col_by_name(col.upper())
 return (row, col, row_abs, col_abs)

def cell_to_rowcol ( cell ) : m = _re_cell_ex . match ( cell ) if ( not m ) : raise Exception ( ( 'Ill-formed single_cell reference: %s' % cell ) ) ( col_abs , col , row_abs , row ) = m . groups ( ) row_abs = bool ( row_abs ) col_abs = bool ( col_abs ) row = ( int ( row ) - 1 ) col = col_by_name ( col . upper ( ) ) return ( row , col , row_abs , col_abs )
convert an excel cell reference string in a1 notation to numeric row/col notation .