Re: [Tutor] How to extract data from text to excel?

[tee chwee liong]

thanks Steven, i get what you mean now. final code works:
 
import xlwt
"""Reads robert.txt"""
  
# Create workbook and worksheet 
wbk = xlwt.Workbook() 
sheet = wbk.add_sheet('python')
row = 0  # row counter
f = open('robert.txt')
L = line.strip()
for c in L:
    
    sheet.write(row,0,c)    
    row += 1
  
wbk.save('reformatted.data.xls')
 
thanks
tcl
                                          
_______________________________________________
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor