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]
<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
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 list2 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