python 写入数据到excel中

最新推荐文章于 2024-08-25 17:28:20 发布

小飞飞要变强

最新推荐文章于 2024-08-25 17:28:20 发布

阅读量1k

点赞数

分类专栏： python基础知识

本文链接：https://blog.csdn.net/qq_42708830/article/details/97302696

版权

python基础知识专栏收录该内容

38 篇文章 1 订阅

订阅专栏

这篇博客介绍了如何利用Python的库将数据高效地写入Excel文件，为数据分析和报告生成提供便利。

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

python excel 写入数据到excel中

from openpyxl import Workbook
import os

from openpyxl.styles import Alignment
from openpyxl.styles import Border
from openpyxl.styles import Font
from openpyxl.styles import PatternFill
from openpyxl.styles import Side

file_name = '2.xlsx'
file_path = os.path.abspath(os.path.join(__file__, '../', file_name))
print(file_path)
wb = Workbook()
sheet = wb.active
sheet.title = '王飞'
index = 1

column_range = ['A', 'B', 'C']
column_widths = [10, 20, 30]
# 设置表格的宽度
for column_index, width in zip(column_range, column_widths):
    sheet.column_dimensions[column_index].width = width

# 绘制表格的颜色
# font = Font(name='微软雅黑', size=11, bold=True)
font = Font(name='微软雅黑', size=10)
fill = PatternFill(fill_type='solid', fgColor='FFFFFF')
alignment = Alignment(horizontal='general', vertical='center', wrap_text=True)
border = Border(left=Side(style='thin', color='000000'), right=Side(style='thin', color='000000'),
                    top=Side(style='thin', color='000000'), bottom=Side(style='thin', color='000000'))
# 填充内容
for i in range(1, 3):
    for j in range(1, 4):
        cell = sheet.cell(row=i, column=j)
        cell.value = i + j
        cell.alignment = alignment
        cell.font = font
        cell.border = border

# sheet.merge_cells(start_row=1, end_row=1, start_column=1, end_column=3) --------这个可以合并单元格
wb.save(file_path)