python导出excel文件
一、list导出
import xlwt
def test():
data = ... # data调用返回一个List的函数
count = 0
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Sheet1')
for row in data:
str1 = str(row) # xlwt只能操作string
sheet.write(count, 0, str1) # count是行数,0是列数, str1是写入值
count = count+1
workbook.save('test.xls')
test()
二、DataFrame导出
def test():
data = ... # data调用返回一个DataFrame的函数
df = data.to_excel('eknet_data_set_def.xlsx')
test()