#NEWLINE# def test_xl_cell_to_rowcol( self ) : #NEWLINE# #INDENT# 'Test xl_cell_to_rowcol()' #NEWLINE# tests = [ ( 0 , 0 , 'A1' ) , ( 0 , 1 , 'B1' ) , ( 0 , 2 , 'C1' ) , ( 0 , 9 , 'J1' ) , ( 1 , 0 , 'A2' ) , ( 2 , 0 , 'A3' ) , ( 9 , 0 , 'A10' ) , ( 1 , 24 , 'Y2' ) , ( 7 , 25 , 'Z8' ) , ( 9 , 26 , 'AA10' ) , ( 1 , 254 , 'IU2' ) , ( 1 , 255 , 'IV2' ) , ( 1 , 256 , 'IW2' ) , ( 0 , 16383 , 'XFD1' ) , ( 1048576 , 16384 , 'XFE1048577' ) ] #NEWLINE# for ( row , col , string ) in tests : #NEWLINE# #INDENT# exp = ( row , col ) #NEWLINE# got = xl_cell_to_rowcol ( string ) #NEWLINE# self . assertEqual ( got , exp )