使用xlsxwriter库就可以了。给个例子参考下：创建一个新的excel文件，demo.xlsx workbook = xlsxwriter.Workbook('demo.xlsx')worksheet = workbook.add_worksheet()设置A列的宽度 worksheet.set_column('A:A', 20)bold = workbook.add_format({'bold': True})worksheet.write('A1', 'Hello')work...
如何用python生成excel文件
使用xlsxwriter库就可以了。给个例子参考下：
# 创建一个新的excel文件，demo.xlsx
workbook = xlsxwriter.Workbook('demo.xlsx')
worksheet = workbook.add_worksheet()
# 设置A列的宽度
worksheet.set_column('A:A', 20)
bold = workbook.add_format({'bold': True})
worksheet.write('A1', 'Hello')
worksheet.write('A2', 'World', bold)
worksheet.write(2, 0, 123)
worksheet.write(3, 0, 123.456)
worksheet.insert_image('B5', 'logo.png')
workbook.close()
运行结果：
2017-11-09
