Need help | splitting list into list

[Vinci141]

Hello,

My need is to read an excel, split data from a specific column , turn it into array of characters so that i print them into excel into 9 cells and color few characters.

Below is my approach so far. If incorrect, please rectify.

1 Read data from excel file [Done]
2 Put column data into a list as below [Done]

for row in range( 1, sheet.nrows ):
    data.append( sheet.cell_value( row, 2 ) ) # Append data from excel to list

2 Read this list and split each element into an array itself.Below doesn't work for me

for i in data:
    for j in range( len( i ) ):
        split_data.append(list( data[j]  ))

3 Once splitting , print them into excel
<No idea how to achieve this.I tried a lot from google about various python module but in vain. Lastly, i am seeking help here>

4 Future need : color the character 0 and O in excel sheet
<didn't reached there so far but any help on this would be thankful>

Thanks
V