def to_csv(self, fileobj): """generate CSV in fileobj""" csvwriter = csv.writer(fileobj, dialect='excel', delimiter='\t') fixer = lambda row: [unicode(x).encode('utf-8') for x in row] self.create_header(csvwriter, fixer) for row in query_iterator(self.query): self.create_row(csvwriter, row, fixer)
def to_xls(self, fileobj): """generate XLS in fileobj""" import huTools.structured_xls xlswriter = huTools.structured_xls.XLSwriter() self.create_header(xlswriter) for row in query_iterator(self.query): self.create_row(xlswriter, row) xlswriter.save(fileobj)