0

I have one Excel file that has a Chart (Bar Chart). I also have a Powerpoint presentation with 3 slides. Please note that there is no chart "Title" either on the Excel sheet ot on the Powerpoint slides. I need to update the chart in slide #2 with the the chart in the excel file.

Please note that I have searched this forum and what I found was ways to create a new slide as well as updating a chart using the tittle.

Any help will be greatly appreciated. Thanks for your time

EDIT: Your solution is good but does not help me with how to replace a chart in a particular slide. In my question I have stated that there are 3 slides. I want to specifically update the chart in Slide 2. There is no chart title so I will need to find the Chart to replace based on the Slide number. How is this done ? Thanks again.

Matthew Balraj
  • 101
  • 2
  • 7

1 Answers1

1

This can be done by following these steps: (Note: the powerpoint is the target, and the excel is the source)

  1. Open the target and locate the ChartPart you want to replace. Keep a reference to the parent SlidePart where the ChartPart is and copy the ChartPart's RelationshipId to the SlidePart and then delete the ChartPart from the target.

  2. Save the source and leave the file open.

            foreach (var slidePart in targetPPT.PresentationPart.SlideParts)
        {
            if (slidePart.ChartParts.Any())
            {
                slidePartBookMark = slidePart;

                var chartPart = slidePart.ChartParts.First();
                chartPartIdBookMark = slidePart.GetIdOfPart(chartPart);
                slidePart.DeletePart(chartPart);
                slidePart.Slide.Save();
                return;
            }
        }

  3. Open the source and locate the ChartPart that you want to copy to the target. It will be in a DrawingsPart of a WorksheetPart somewhere in your source. Keep a reference to the ChartPart and leave the file open.

            foreach (var worksheetPart in sourceXls.WorkbookPart.WorksheetParts)
        {
            if (worksheetPart.DrawingsPart != null)
                if (worksheetPart.DrawingsPart.ChartParts.Any())
                {
                    saveXlsChart = worksheetPart.DrawingsPart.ChartParts.First();
                    return;
                }

        }

  4. In the SlidePart reference from step 1, create a new ChartPart with the AddNewPart call using the RelationshipId

        var newChartPart = slidePartBookMark.AddNewPart<ChartPart>(chartPartIdBookMark);

  5. Copy the contents of the source chart to the new chartpart you created in step 4 with a FeedData/GetStream idea found here. Save the Slide, and close your files.

        newChartPart.FeedData(saveXlsChart.GetStream());
    slidePartBookMark.Slide.Save();
    sourceXls.Close();
    targetPPT.Close();

I was able to get it to work with a simple source/target that only contained one chart each. If your files are more complex, your locate logic will be more than a First().

Hope this helps.

Taterhead
  • 5,763
  • 4
  • 31
  • 40
  • Thanks for taking the time. I will try this solution and get back to you – Matthew Balraj Apr 23 '12 at 03:45
  • I looked at your solution. What I exactly need is to be able to go to a particular slide. In my question I have stated that I want to replace the Chart in Slide 2. It will be helpful to know how this is done – Matthew Balraj Apr 23 '12 at 04:41
  • If you have only one chart in the presentation, the above will work. If you only need the second slide, in the first line of code below step 2, try var secondSlidePart = targetPPT.PresentationPart.SlideParts.Skip(1).Take(1). Also remove the if statement below it. – Taterhead Apr 23 '12 at 07:11
  • Thanks again. I tried your code. I get a error on line chartPartIdBookMark = slidePart.GetIdOfPart(chartPart); I get a "cannot implicitly convert type string to documentformat.OpenXML.Packaging.Chartpart". What could be wrong ? – Matthew Balraj Apr 23 '12 at 10:58
  • explicitly declare chartPartIdBookMark a string. From your error it seems you have it defined as Chartpart – Taterhead Apr 23 '12 at 11:17
  • I have a few more questions Should I define slidePartBookMark = slidePart; as a slidepart or as a string ? Another question is on line var newChartPart = slidePartBookMark.AddNewPart(chartPartIdBookMark); I get a error that I Get an error. I get an Type or namespace missing at . I would appreciate your help. Thanks a lot – Matthew Balraj Apr 23 '12 at 12:37