如何使用c#更新PowerPoint图表 [英] How to update PowerPoint chart using c#

问题描述

我必须更新 pptx 文件.在这个 pptx 中，我有一组图表，我必须通过 c# 代码更新数据.请告诉我们该怎么做?

I have to update pptx file. In this pptx i have some set of chart which i have to update the data through c# code. Please let us know how to do it?

注意:不是OLE图，是power point chart组件

Note: It is not OLE graph, it is power point chart component

提前致谢

推荐答案

在 VBA 语法中类似于

In VBA syntax it's something like

For i = 1 To ActiveWindow.Selection.ShapeRange.Count

    If ActiveWindow.Selection.ShapeRange(i).Type = msoChart Then

        Dim c As Chart
        Set c = ActiveWindow.Selection.ShapeRange(i).Chart

        Dim data As ChartData
        Set data = c.ChartData 
        data.Activate

        data.Workbook.Worksheets(1).Range("B3").Value = _
            data.Workbook.Worksheets(1).Range("B3").Value + 1
        ...

    End If

 Next

可以在此处找到介绍:http://blogs.office.com/b/microsoft-excel/archive/2009/08/18/chart-object-model-in-word-powerpoint.aspx

这篇关于如何使用c#更新PowerPoint图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！