为什么我收到导入错误：无法从"openpyxl"导入名称"饼图"

Question

当我尝试在ViusalStudio中运行此代码时，我得到此错误。

import openpyxl
from openpyxl import PieChart, Reference, Series, PieChart3D
wb = openpyxl.Workbook()
ws = wb.active
data = [
['Flavor', 'Sold'],
['Vanilla', '1500'],
['Chocolate', '1600'],
['Strawberry', '600'],
['Pumpkin Spice', '950']
]
for rows in data:
ws.append(rows)
chart = PieChart()
labels = Reference(ws, min_col=1, min_row= 2, max_row=5)
data = Reference(ws, min_col=1, min_row= 2, max_row=5)
chart.add_data(data, titles_from_data=True)
chart.set_categories(labels)
chart.title = 'Ice Cream By Flavor'
ws.add_chart(chart, 'C1')
wb.save('Pie1.xlsx')

你知道我做错了什么吗?我正在使用python 3.9.

Answer 1

试试下面的

(阅读文档)

from openpyxl.chart import (
PieChart,
Reference,
Series, 
PieChart3D
)