import csv
inFile = open('d.csv','rb') # 打开csv文件
inReader = csv.reader(inFile) # 读取csv文件
for rowIndex,row in enumerate(inReader, start = 1):
for colIndex,col in enumerate(row, start = 1):
rs = util.execSql(col, locals()) # 执行csv里面的SQL
outFile = open('o.csv','a+')
Writer = csv.writer(outFile) # 写入csv文件
Writer.writerow(str(col))
for rowIndex2,row2 in enumerate(rs, start =1):
row3 = [rowIndex2] + list(row2) # 数组拼接
Writer.writerow(row3)
print('{}.row{}').format(rowIndex2,row2)
outFile.close()
inFile.close()