1、 安装模块
pip install xlsxwriter
2、代码示例
import xlsxwriter
import time
today = time.strftime("%Y%m%d", time.localtime())
file_name = 'filename' + today + '.xlsx'
workbook = xlsxwriter.Workbook(file_name)
worksheet = workbook.add_worksheet(today)
worksheet.set_row(0, 30)
worksheet.set_column("E:G", 20)
title_cell_format = workbook.add_format({
'bold': True,
'border': 1,
'align': 'center',
'valign': 'vcenter',
'fg_color': '#F4B084',
'font_name': '宋体',
'font_size': 14,
})
cell_format = workbook.add_format({
'border': 1,
'align': 'left',
'valign': 'vcenter',
'text_wrap': True,
'font_name': '宋体',
'font_size': 12,
})
title_data = ['id', 'name', 'sex', 'age', 'addr', 'grade', 'phone', 'gold']
[worksheet.write(0, col, value, title_cell_format) for col, value in enumerate(title_data)]
text_data = [
[314, '矿泉水', '男', 18, '北京市昌平区\n顺义\n商户\ndjsdji', '摩羯座', '18317155663', 14405],
[315, '矿泉水', '女', 27, '上海', '摩羯座', '18317155664', 100],
[5985, '矿泉水', '男', 18, '北京市昌平区', '班级', '18513867663', 100]
]
for row, row_data in enumerate(text_data, start=1):
for col, value in enumerate(row_data):
worksheet.write(row, col, value, cell_format)
workbook.close()
3、效果
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/447194a9243e9cdfaf57972b776c60f6.png)