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)
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)
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)
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")