#NEWLINE# def __init__( self , sheetname , ranges ) : #NEWLINE# #INDENT# '\n        Translate merged cells to human readable ranges.\n        ' #NEWLINE# self . sheetname = sheetname #NEWLINE# self . ranges = ranges #NEWLINE# self . bad_ranges = [ ] #NEWLINE# letters = string . lowercase #NEWLINE# for range in self . ranges : #NEWLINE# #INDENT# ( row1 , row2 , col1 , col2 ) = range #NEWLINE# col1 = letters [ col1 ] #NEWLINE# col2 = letters [ ( col2 - 1 ) ] #NEWLINE# row1 = ( row1 + 1 ) #NEWLINE# self . bad_ranges . append ( '{0}{1}:{2}{3}' . format ( col1 , row1 , col2 , row2 ) )