使用 openpyxl 生成 Excel 面积图

'''
2D 面积图
@author Deniro Li
'''
from openpyxl import Workbook
from openpyxl.chart import AreaChart, Reference
from random import randint

wb = Workbook()
ws = wb.active

# 随机生成销售额数据
rows = [
    ['1 月', '北京', '上海'],
]
for i in range(2, 14):
    rows.append([str(i) + ' 月', randint(10, 90), randint(5, 50)])
for row in rows:
    ws.append(row)

# 初始化 AreaChart 对象
chart = AreaChart()
chart.title = "区域销售额"
chart.style = 10
chart.x_axis.title = '2019 年'
chart.y_axis.title = '单位（百万）'

# 计算类别与数据的最大行数
max_row = len(rows)
# 计算数据的最大列数
max_col = len(rows[1])

# 类别对象
cats = Reference(ws, min_col=1, min_row=1, max_row=max_row)
chart.set_categories(cats)

# 数据对象
data = Reference(ws, min_col=2, min_row=1, max_col=max_col, max_row=max_row)
chart.add_data(data, titles_from_data=True)

# 放入 Workbook 对象并指定初始位置
ws.add_chart(chart, 'E5')

wb.save('area_2d.xlsx')

...
from openpyxl.chart import AreaChart3D
...
# 初始化 AreaChart3D 对象
chart=AreaChart3D()
chart.style=10
chart.x_axis.title = '2019 年'
chart.y_axis.title = '单位（百万）'
chart.legend=None
chart.height=10
chart.width=30

# 类别对象
cats = Reference(ws, min_col=1, min_row=1, max_row=max_row)
chart.set_categories(cats)

# 数据对象
data = Reference(ws, min_col=2, min_row=1, max_col=max_col, max_row=max_row)
chart.add_data(data, titles_from_data=True)

# 放入 Workbook 对象并指定初始位置
ws.add_chart(chart, 'E5')
...