在使用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()