python合并同类型excel表格的方法

#!/usr/bin/env python# -*- coding: UTF-8 -*-import os, csvclass CSVTopoIreator:  def __init__(self, filename):    self.infile = open(filename, 'rb')    self.reader = csv.reader(self.infile)  def __iter__(self):    return self  def next(self):    try:      row = self.reader.next()    except StopIteration:      self.infile.close()      raise StopIteration    return rowdef main():csvfile = file('csv_test.csv', 'wb')writer = csv.writer(csvfile,delimiter=',',dialect='excel')writer.writerow(['Items', 'Measure', 'Result'])for (dirpath, dirnames, filenames) in os.walk('.'):for name in filenames:if name != "new1.py" or name != "niniubi.csv":filename = dirpath + '/' + nameprint "csv filename:", filenameireator = CSVTopoIreator(filename)#writer.writerow(ireator)for a in ireator:print awriter.writerow(a)csvfile.close()if __name__ == '__main__':  main()