Class ChartWorkbook

src/pptx/parts/chart.py:57–95

Provides access to external chart data in a linked or embedded Excel workbook.

class ChartWorkbook(object):
    """Provides access to external chart data in a linked or embedded Excel workbook."""

    def __init__(self, chartSpace, chart_part):
        super(ChartWorkbook, self).__init__()
        self._chartSpace = chartSpace
        self._chart_part = chart_part

    def update_from_xlsx_blob(self, xlsx_blob):
        """
        Replace the Excel spreadsheet in the related |EmbeddedXlsxPart| with
        the Excel binary in *xlsx_blob*, adding a new |EmbeddedXlsxPart| if
        there isn't one.
        """
        xlsx_part = self.xlsx_part
        if xlsx_part is None:
            self.xlsx_part = EmbeddedXlsxPart.new(xlsx_blob, self._chart_part.package)
            return
        xlsx_part.blob = xlsx_blob

    @property
    def xlsx_part(self):
        """Optional |EmbeddedXlsxPart| object containing data for this chart.

        This related part has its rId at `c:chartSpace/c:externalData/@rId`. This value
        is |None| if there is no `<c:externalData>` element.
        """
        xlsx_part_rId = self._chartSpace.xlsx_part_rId
        return None if xlsx_part_rId is None else self._chart_part.related_part(xlsx_part_rId)

    @xlsx_part.setter
    def xlsx_part(self, xlsx_part):
        """
        Set the related |EmbeddedXlsxPart| to *xlsx_part*. Assume one does
        not already exist.
        """
        rId = self._chart_part.relate_to(xlsx_part, RT.PACKAGE)
        externalData = self._chartSpace.get_or_add_externalData()
        externalData.rId = rId