python操作excel,使用xlrd模块,获取某一列数据的...
文件存储是按照每zhidao个子列表为一行内的,所以在写文件时只需要将[10,'haha',0.1]换成[[10],['haha'],[0.1]]。所以只要将mywrite.writerow(i)改为容mywrite.writerow([i])。
import csv
def storFile(data,fileName):
with open(fileName,'w',newline ='') as f:
mywrite = csv.writer(f)
for i in data:
mywrite.writerow([i])
data = [10,'haha',0.1]
storFile(data,"haha.csv")
Python 根据原EXCEL表数据新增一列,如何实现?
文件存储是按照每zhidao个子列表为一行内的,所以在写文件时只需要将[10,'haha',0.1]换成[[10],['haha'],[0.1]]。所以只要将mywrite.writerow(i)改为容mywrite.writerow([i])。
import csv
def storFile(data,fileName):
with open(fileName,'w',newline ='') as f:
mywrite = csv.writer(f)
for i in data:
mywrite.writerow([i])
data = [10