openpyxl-插入柱状图

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

wb = load_workbook('e:\\a\\sample.xlsx')

ws1=wb.active

wb = Workbook()
ws = wb.active
for i in range(10):#加了0-9的一列
    ws.append([i])


values = Reference(ws, min_col=1, min_row=1, max_col=1, max_row=10)
chart = BarChart()    #柱状图
chart.title = "Bar Chart"
chart.y_axis.title = 'SN'
chart.x_axis.title = 'Sample value'
chart.add_data(values)
ws.add_chart(chart, "E15")     #柱状图的位置

# Save the file
wb.save("e:\\a\\sample.xlsx")