CSV文件也可以在Excel中打开。在
请检查以下代码:import csv
speed = [10,20]
dist = [100,200]
f = open("out.csv", 'wb')
try:
writer = csv.writer(f)
writer.writerow( ('Speed','Distance') )
for i in range(2):
writer.writerow( (speed[i],dist[i]) )
finally:
f.close()
内容输出.csv文件:
^{pr2}$
此外,如果您想要精确的excel格式,您可以将方言设置为如下所示:writer = csv.writer(f,dialect='excel')
请查看共享链接中的方言部分了解更多信息。在
最后可以用作:import csv
f = open("out.csv", 'wb')
writer = csv.writer(f,dialect='excel')
writer.writerow( ('Speed','Distance') )
for model in simmodels:
result = simulate(model)
speed = result["speed"]
distance = result["distance"]
writer.writerow( (speed,distance) )
f.close()