Source code for openpyxl.chart.reader

from __future__ import absolute_import
# Copyright (c) 2010-2019 openpyxl

"""
Read a chart
"""

from .chartspace import ChartSpace, PlotArea
from openpyxl.xml.functions import fromstring

_types = ('areaChart', 'area3DChart', 'lineChart', 'line3DChart',
         'stockChart', 'radarChart', 'scatterChart', 'pieChart', 'pie3DChart',
         'doughnutChart', 'barChart', 'bar3DChart', 'ofPieChart', 'surfaceChart',
         'surface3DChart', 'bubbleChart',)

_axes = ('valAx', 'catAx', 'dateAx', 'serAx',)


[docs]def read_chart(chartspace): cs = chartspace plot = cs.chart.plotArea chart = plot._charts[0] chart._charts = plot._charts chart.title = cs.chart.title chart.display_blanks = cs.chart.dispBlanksAs chart.visible_cells_only = cs.chart.plotVisOnly chart.layout = plot.layout chart.legend = cs.chart.legend # 3d attributes chart.floor = cs.chart.floor chart.sideWall = cs.chart.sideWall chart.backWall = cs.chart.backWall chart.pivotSource = cs.pivotSource chart.pivotFormats = cs.chart.pivotFmts chart.idx_base = min(s.idx for s in chart.series) return chart