读取csv文件: def readCsv(): rows=[] with file(r'E:\py\py01\Data\system.csv','rb') as f: reads=csv.reader(f) for i in reads: rows.append(i) print rows return rows写入csv文件: def writer(): with file(r'E:\py\py01\Data\system.csv','wb') as f: writer=csv.writer(
只能新创建xls # coding=utf-8import xlwt writebook = xlwt.Workbook() #打开excel test= writebook.add_sheet('test') #添加一个名字叫test的sheet test.write(0,1,'this is a test') #第0行第1列写入字符串'this is a test' writebook.save('testdata.xls'