def test_chartsheet(ExcelWriter, archive): wb = Workbook() cs = wb.create_chartsheet() writer = ExcelWriter(wb, archive) writer._write_chartsheets() assert cs.path in writer.manifest.filenames assert cs.path[1:] in writer._archive.namelist()
from openpyxl2 import Workbook from openpyxl2.chart import PieChart, Reference, Series wb = Workbook() ws = wb.active cs = wb.create_chartsheet() rows = [ ["Bob", 3], ["Harry", 2], ["James", 4], ] for row in rows: ws.append(row) chart = PieChart() labels = Reference(ws, min_col=1, min_row=1, max_row=3) data = Reference(ws, min_col=2, min_row=1, max_row=3) chart.series = (Series(data), ) chart.title = "PieChart" cs.add_chart(chart) wb.save("demo.xlsx")