需要引入包:xlwt
命令行安装:pip install xlwt
#fluence:要保存的数据,为一个二元数组,每一个元素为excel一行 fluence=[['a','b'],['c','d']]
#sheetName:excel中sheet的名称
def saveExcel(fluence,sheetName):
import xlwt
book = xlwt.Workbook(encoding='utf-8', style_compression=0)
sheet = book.add_sheet(sheetName, cell_overwrite_ok=True)
col = ('词名', '频次')
#添加表头行
for i in range(0,2):
sheet.write(0,i,col[i])
#添加数据行
for i in range(0, len(fluence)):
data = fluence[i]
for j in range(0, 2):
sheet.write(i + 1, j, data[j])
savepath = sheetName+'.xls'
book.save(savepath)