python操作excel读入文件

在使用excel时，常常面临将text文件读入的问题，所以用python设计了一个可以将text文件读入excel的程序的初级版本，text文件必须是逗号分隔的格式

下面是程序

import csv
from Tkinter import Tk
from tkMessageBox import showwarning
import win32com.client as win32

COLS = ('ID','NAME','NUMBER')
def excel():
    app = 'Excel'
    x1 = win32.gencache.EnsureDispatch('%s.Application' % app)
    ss = x1.Workbooks.Add()
    sh = ss.ActiveSheet
    x1.Visible = True

    for i in range(3):
        sh.Cells(1,i+1).Value = COLS[i]
    sh.Range(sh.Cells(1,1),sh.Cells(1,3)).Font.Bold = True

    row = 2
    f = open('bookdata.csv','r')

    while True:

        for lines in f.readlines():
            j = 1
            line = lines.replace("\n","").split(',')
            print line
            for i in line:

                sh.Cells(row,j).Value = i
                j+=1


            row += 1;
    f.close()
    ss.close(False)
    x1.Application.Quit()

if __name__=='__main__':
    excel()