Python 读写Excel文件

读取：

import csv

with open(r'D:\egg.csv', 'rb') as f:
    reader = csv.reader(f)
    for row in reader:
        print type(row)
        print row

写入csv文件，一列：

import csv

with open(r'D:\egg2.csv', 'wb') as csvfile:
    spamwriter = csv.writer (csvfile, delimiter=' ', quotechar='|', quoting = csv.QUOTE_MINIMAL)
    spamwriter.writerow(['a','1','1','2','2'])
    spamwriter.writerow(['b','3','3','6','4'])
    spamwriter.writerow(['c','7','7','10','4'])

写入csv文件，多列：

import csv

with open(r'D:\egg3.csv', 'wb') as csvfile:
    spamwriter = csv.writer (csvfile, dialect='excel')
    spamwriter.writerow(['a','1','1','2','2'])
    spamwriter.writerow(['b','3','3','6','4'])
    spamwriter.writerow(['c','7','7','10','4'])