Question

如何用python生成excel文件

Answer 1

使用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()

运行结果：