コード例 #1
0
ファイル: charts.py プロジェクト: BespokeInsights/openpyxl
def line(wb):
    ws = wb.create_sheet(5, "Line")
    for i in range(1, 5):
        ws.append([i])
    chart = LineChart()
    values = Reference(ws, (1, 1), (4, 1))
    series = Series(values)
    chart.append(series)
    ws.add_chart(chart)
コード例 #2
0
def line(wb):
    ws = wb.create_sheet(5, "Line")
    for i in range(1, 5):
        ws.append([i])
    chart = LineChart()
    values = Reference(ws, (0, 0), (3,0))
    series = Series(values)
    chart.append(series)
    ws.add_chart(chart)
コード例 #3
0
ファイル: plot.py プロジェクト: petres/eurostat
def addExcelGraph(sheet, c):
    global dataCol
    dataCol = c + 1
    #print dataCol
    dataParam = {}
    dataParam['sheet'] = sheet

    init(sheet = sheet)

    labels = Reference(sheet, (startRow,  dataCol), (startRow, dataCol + len(timeLabels)))
    chart = LineChart()

    for i in range(startRow + 1, endRow):
        #xvalues = Reference(sheet, (startRow + 1,  dataCol), (startRow + 1, dataCol + len(timeLabels)))
        title = []
        for ii in range(1, dataCol):
            title.append(sheet.cell('%s%s'%(get_column_letter(ii), i)).value)
        values = Reference(sheet, (i,  dataCol), (i, dataCol + len(timeLabels)))
        #print "Reference", (dataCol, startRow + 1), (dataCol + len(timeLabels), startRow + 1)
        series = Series(values, title=" - ".join(title), labels = labels)
        chart.append(series)

    sheet.add_chart(chart)
コード例 #4
0
ファイル: chart.py プロジェクト: petres/eurostat
import os, sys

sys.path.insert(1, os.path.join(os.path.dirname(__file__), "..", "lib"))


from openpyxl import Workbook
from openpyxl.charts import BarChart, LineChart, Reference, Series
from openpyxl.cell import get_column_letter

wb = Workbook()
ws = wb.active
for i in range(10):
    ws.cell("%s%s" % (get_column_letter(i + 2), 1)).value = i


values = Reference(ws, (1, 2), (1, 11))
title = Reference(ws, (1, 1), (1, 1))
series = Series(values, title=title)
chart = LineChart()
chart.append(series)
ws.add_chart(chart)
wb.save("SampleChart.xlsx")