使用python实现Excel中的图表标题、边框样式和颜色

pip install openpyxl

from openpyxl import Workbook
from openpyxl.chart import BarChart, Reference

# 创建一个新的Excel文件
wb = Workbook()
ws = wb.active

# 添加数据
data = [
    ['Category', 'Value'],
    ['A', 10],
    ['B', 15],
    ['C', 7],
    ['D', 12]
]

for row in data:
    ws.append(row)

# 创建一个柱状图
chart = BarChart()
values = Reference(ws, min_col=2, min_row=1, max_row=5, max_col=2)
categories = Reference(ws, min_col=1, min_row=2, max_row=5)
chart.add_data(values, titles_from_data=True)
chart.set_categories(categories)

# 设置图表标题
chart.title = "Chart Title"

# 设置边框样式和颜色
chart.border = openpyxl.styles.Border(
    left=openpyxl.styles.Side(style='thin', color='000000'),
    right=openpyxl.styles.Side(style='thin', color='000000'),
    top=openpyxl.styles.Side(style='thin', color='000000'),
    bottom=openpyxl.styles.Side(style='thin', color='000000')
)

# 设置标题字体颜色
chart.title.font.color = "FF0000"

# 将图表添加到Excel文件中
ws.add_chart(chart, "E1")

# 保存Excel文件
wb.save("chart.xlsx")