python的openpyxl在表格中话柱状图

最新推荐文章于 2024-07-27 21:07:51 发布

s_daqing

最新推荐文章于 2024-07-27 21:07:51 发布

阅读量786

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/s_daqing/article/details/106160862

版权

python 专栏收录该内容

43 篇文章 3 订阅

订阅专栏

def func():
    # outwb = openpyxl.load_workbook(self.source_data)
    # ws1 = outwb.create_sheet("sheet1", 1)
    wb = Workbook(write_only=True)
    ws1 = wb.create_sheet()
    # 画柱状图
    chart1 = BarChart()
    chart1.type = "col"
    chart1.style = 10
    chart1.title = "title(%%) %s" % time.strftime("%Y.%m.%d")
    # chart1.y_axis.title = 'bug解决率(%)'
    # chart1.x_axis.title = '组名'

    max_row = len(bug_statistic_list) + 1
    data = Reference(ws1, min_col=4, min_row=1, max_row=max_row, max_col=4)  # y轴数据范围
    cats = Reference(ws1, min_col=1, min_row=2, max_row=max_row, max_col=1)  # x轴数据范围
    chart1.add_data(data, titles_from_data=True)
    chart1.set_categories(cats)
    chart1.shape = 2
    ws1.add_chart(chart1, "I2")