def rowcol_to_cell(row, col, row_abs=False, col_abs=False):
 assert (0 <= row < MAX_ROW)
 assert (0 <= col < MAX_COL)
 d = (col // 26)
 m = (col % 26)
 chr1 = ''
 if row_abs:
  row_abs = '$'
 else:
  row_abs = ''
 if col_abs:
  col_abs = '$'
 else:
  col_abs = ''
 if (d > 0):
  chr1 = chr(((ord('A') + d) - 1))
 chr2 = chr((ord('A') + m))
 return ((((col_abs + chr1) + chr2) + row_abs) + str((row + 1)))

def rowcol_to_cell ( row , col , row_abs = False , col_abs = False ) : assert ( 0 <= row < MAX_ROW ) assert ( 0 <= col < MAX_COL ) d = ( col // 26 ) m = ( col % 26 ) chr1 = '' if row_abs : row_abs = '$' else : row_abs = '' if col_abs : col_abs = '$' else : col_abs = '' if ( d > 0 ) : chr1 = chr ( ( ( ord ( 'A' ) + d ) - 1 ) ) chr2 = chr ( ( ord ( 'A' ) + m ) ) return ( ( ( ( col_abs + chr1 ) + chr2 ) + row_abs ) + str ( ( row + 1 ) ) )
convert numeric row/col notation to an excel cell reference string in a1 notation .