如何用python生成excel文件

2024-08-25 11:12:08
推荐回答(1个)
回答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()

运行结果: