xlsxwriter模块实现向Excel表写数据

导入第三方库

import xlsxwriter as xw

写数据

# 创建工作簿
workbook = xw.Workbook(filename) 

 # 创建子表
worksheet1 = workbook.add_worksheet("sheet1")

# 激活表
worksheet1.activate() 

# 设置表头
title = ['序号','项目','数据'] 

# 从A1单元格开始写入表头
worksheet1.write_row('A1',title) 

# 从第二行开始写入数据
i = 2 
for j in range(len(data)):
    insertData = [data[0][j],data[1][j],data[2][j]]
    row = 'A' + str(i)
    worksheet1.write_row(row, insertData)
    i += 1
    
# 关闭表    
workbook.close()