提取某Excel数据制作饼图和柱状图 饼图 import openpyxl wb = openpyxl.open('files/工作数据.xlsx') sheet =wb.active #获取活跃表 #提取数据 m_r = sheet.max_row m_c = sheet.max_column dict1={ } for r in range(1,m_r+1): value = sheet.cell(r,6).value if value not in dict1: dict1[value