def numbers(wb):
ws = wb.create_sheet(1, "Numbers")
for i in range(10):
ws.append([i])
chart = BarChart()
values = Reference(ws, (1, 1), (10, 1))
series = Series(values)
chart.append(series)
ws.add_chart(chart)
def numbers(wb):
ws = wb.create_sheet(1, "Numbers")
for i in range(10):
ws.append([i])
chart = BarChart()
values = Reference(ws, (0, 0), (9, 0))
series = Series(values)
chart.append(series)
ws.add_chart(chart)
def negative(wb):
ws = wb.create_sheet(1, "Negative")
for i in range(-5, 5):
ws.append([i])
chart = BarChart()
values = Reference(ws, (1, 1), (10, 1))
series = Series(values)
chart.append(series)
ws.add_chart(chart)
def negative(wb):
ws = wb.create_sheet(1, "Negative")
for i in range(-5, 5):
ws.append([i])
chart = BarChart()
values = Reference(ws, (0, 0), (9, 0))
series = Series(values)
chart.append(series)
ws.add_chart(chart)
def dates(wb):
ws = wb.create_sheet(3, "Dates")
for i in range(1, 10):
ws.append([date(2013, i, 1), i])
chart = BarChart()
values = Reference(ws, (1, 2), (9, 2))
labels = Reference(ws, (1, 1), (9, 1))
labels.number_format = 'd-mmm'
series = Series(values, labels=labels)
chart.append(series)
ws.add_chart(chart)
def dates(wb):
ws = wb.create_sheet(3, "Dates")
for i in range(1, 10):
ws.append([date(2013, i, 1), i])
chart = BarChart()
values = Reference(ws, (0, 1), (8, 1))
labels = Reference(ws, (0, 0), (8, 0))
labels.number_format = 'd-mmm'
series = Series(values, labels=labels)
chart.append(series)
ws.add_chart(chart)
def create_chart():
wb = Workbook()
ws = wb.active
for i in range(10):
ws.append([i])
from openpyxl.charts import BarChart, Reference, Series
values = Reference(ws, (1, 1), (10, 1))
series = Series(values, title="First series of values")
chart = BarChart()
chart.append(series)
ws.add_chart(chart)
wb.save("SampleChart.xlsx")
def letters(wb):
ws = wb.create_sheet(2, "Letters")
for idx, l in enumerate("ABCDEFGHIJ"):
ws.append([l, idx, idx])
chart = BarChart()
labels = Reference(ws, (1, 1), (10, 1))
values = Reference(ws, (1, 2), (10, 2))
series = Series(values, labels=labels)
chart.append(series)
# add second series
values = Reference(ws, (1, 3), (10, 3))
series = Series(values, labels=labels)
chart.append(series)
ws.add_chart(chart)
def letters(wb):
ws = wb.create_sheet(2, "Letters")
for idx, l in enumerate("ABCDEFGHIJ"):
ws.append([l, idx, idx])
chart = BarChart()
labels = Reference(ws, (0, 0), (9, 0))
values = Reference(ws, (0, 1), (9, 1))
series = Series(values, labels=labels)
chart.append(series)
# add second series
values = Reference(ws, (0, 2), (9, 2))
series = Series(values, labels=labels)
chart.append(series)
ws.add_chart(chart)
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
for i in range(10):
ws.append([i])
from openpyxl.charts import BarChart, Reference, Series
values = Reference(ws, (1, 1), (10, 1))
series = Series(values, title="First series of values")
chart = BarChart()
chart.append(series)
ws.add_chart(chart)
wb.save("SampleChart.xlsx")