xlsxwriter操作例子

最新推荐文章于 2024-03-16 09:00:54 发布

「已注销」

最新推荐文章于 2024-03-16 09:00:54 发布

阅读量806

点赞数

分类专栏：随行笔记

本文链接：https://blog.csdn.net/ericatardicaca/article/details/99689695

版权

本文档将介绍如何使用Python的XlsxWriter库来创建和操作Excel文件。通过示例代码，你将学会如何添加工作表、写入数据、设置格式等基本操作。

摘要由CSDN通过智能技术生成


import os
import xlsxwriter


workbook = xlsxwriter.Workbook('仿真报告.xlsx')
worksheet = workbook.add_worksheet('Sheet1')

worksheet.set_column(0, 12, 12)

cell_format_for_number = workbook.add_format()
cell_format_for_number.set_align('left')
cell_format_for_number.set_align('vcenter')

cell_format_for_title = workbook.add_format()
cell_format_for_title.set_align('center')
cell_format_for_title.set_align('vcenter')
cell_format_for_title.set_bold()



h = ('流量/m3/s', '静压/Pa', '轴功率/kW', '静压效率/%','噪声/dB')

#仿真结果
for i in range(len(h)):
    worksheet.write(21, i, h[i], cell_format_for_title)

data = [(0.68572438, 1064.0703412779367, 7.224125465968586, 10.100308729222371, 55.709774), (1.5183681, 851.5590946541776, 6.499360460732984, 19.89395991189515, 52.754478), (2.179522, 844.684791293196, 6.9617263664921465, 26.444720587554077, 54.084946), (3.1022265, 779.334398886041