ref:https://www.jb51.net/article/159025.htm
关键词:Python 导出成 txt csv excel 文件格式
写入txt文件
1 2 3 4 5 6 7 8 | def text_save(filename, data):
file = open (filename, 'a' )
for i in range ( len (data)):
s = str (data[i]).replace( '[' ,' ').replace(' ] ',' ')
s = s.replace( "'" ,' ').replace(' , ',' ') +' \n'
file .write(s)
file .close()
print ( "保存文件成功" )
|
写入csv文件
1 2 3 4 5 6 | def data_write_csv(file_name, datas):
file_csv = codecs. open (file_name, 'w+' , 'utf-8' )
writer = csv.writer(file_csv, delimiter = ',' , quotechar = ' ' , quoting = csv.QUOTE_MINIMAL)
for data in datas:
writer.writerow(data)
print ( "保存文件成功,处理结束" )
|
举例:
data_write_csv('F:/00 pythonproject/TestData/test.csv',contentArr[0:51])
写入excel文件
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | def data_write(file_path, datas):
f = xlwt.Workbook()
sheet1 = f.add_sheet(u 'sheet1' ,cell_overwrite_ok = True )
i = 0
for data in datas:
for j in range ( len (data)):
sheet1.write(i,j,data[j])
i = i + 1
f.save(file_path)
|