Re: How do I update a chart in a specific slide with an excel chart

Hi

I have an excel file which contains some data and a chart on Sheet1.

I also have a Powerpoint presentation which contains 3 slides. I would like to update the chart on Slide #2 with the chart from the excel file. Please note that there are no chart title on the excel and the powerpoint slide

The following console application code (C#) that I copy has the following problems

1) After executing the application when I try to open the Powerpoint (.pptx) file I get a error "Powerpoint found a problem with content in <filename>

2) I also think that the correct Chart is not getting replaced.

Any help will be greatly appreciated

Ps. I have copied my script below because when I clicked on Insert script button and clicked on the insert link nothing happend.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using OpenXmlPkg = DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Presentation;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

namespace ExportChart
{
    class Program
    {
        static void Main(string[] args)
        {
            string SourceFile = "Projected Sales.xlsx";
            string TargetFile = "Projected Sales.pptx";
            string targetppt = "Generatedppt.pptx";

            ChartPart chartPart;
            ChartPart newChartPart;
            SlidePart slidepartbkMark = null;
            string chartPartIdBookMark = null;

            File.Copy(TargetFile, targetppt, true);

            //Powerpoint document
            using (OpenXmlPkg.PresentationDocument pptPackage = OpenXmlPkg.PresentationDocument.Open(targetppt, true))
            {

                OpenXmlPkg.PresentationPart presentationPart = pptPackage.PresentationPart;

                var secondSlidePart = pptPackage.PresentationPart.SlideParts.Skip(1).Take(1);
                foreach (var slidepart in pptPackage.PresentationPart.SlideParts)
                {
               
                slidepartbkMark = slidepart;

                    if (slidepart.GetPartsCountOfType<ChartPart>() != 0)
                    {
                        chartPart = slidepart.ChartParts.First();
                        chartPartIdBookMark = slidepart.GetIdOfPart(chartPart);
                        slidepart.DeletePart(chartPart);
                        slidepart.Slide.Save();
                    }

                    //return;
                }

                newChartPart = slidepartbkMark.AddNewPart<ChartPart>(chartPartIdBookMark);

                ChartPart saveXlsChart = null;
                using (SpreadsheetDocument xlsDocument = SpreadsheetDocument.Open(SourceFile.ToString(), true))
                {
                    WorkbookPart xlsbookpart = xlsDocument.WorkbookPart;

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

                    newChartPart.FeedData(saveXlsChart.GetStream());
                    slidepartbkMark.Slide.Save();
                    xlsDocument.Close();
                    pptPackage.Close();
                }
            }
        }
    }    
}
       
 

Hi Matt,

Below is your modified code.

It works fine.

------------------------------

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using OpenXmlPkg = DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Presentation;

using DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Spreadsheet;

namespace ExportChart

{

   class Program

   {

       static void Main(string[] args)

       {

           string SourceFile = "generated.xlsx";

           string TargetFile = "template.pptx";

           string targetppt = "Generatedppt.pptx";

           ChartPart chartPart;

           ChartPart newChartPart;

           SlidePart slidepartbkMark = null;

           string chartPartIdBookMark = null;

           File.Copy(TargetFile, targetppt, true);

           //Powerpoint document

           using (OpenXmlPkg.PresentationDocument pptPackage = OpenXmlPkg.PresentationDocument.Open(targetppt, true))

           {

               OpenXmlPkg.PresentationPart presentationPart = pptPackage.PresentationPart;

               var secondSlidePart = pptPackage.PresentationPart.SlideParts.Skip(0).First();  // this will retrieve your second slide

                       chartPart = secondSlidePart.ChartParts.First();

                       chartPartIdBookMark = secondSlidePart.GetIdOfPart(chartPart);

                       secondSlidePart.DeletePart(chartPart);

                       secondSlidePart.Slide.Save();

                       newChartPart = secondSlidePart.AddNewPart<ChartPart>(chartPartIdBookMark);

               ChartPart saveXlsChart = null;

               using (SpreadsheetDocument xlsDocument = SpreadsheetDocument.Open(SourceFile.ToString(), true))

               {

                   WorkbookPart xlsbookpart = xlsDocument.WorkbookPart;

                   foreach (var worksheetPart in xlsDocument.WorkbookPart.WorksheetParts)

                   {

                       if (worksheetPart.DrawingsPart != null)

                           if (worksheetPart.DrawingsPart.ChartParts.Any())

                           {

                               saveXlsChart = worksheetPart.DrawingsPart.ChartParts.First();

                           }

                   }

                   newChartPart.FeedData(saveXlsChart.GetStream());

                   secondSlidePart.Slide.Save();

                   xlsDocument.Close();

                   pptPackage.Close();

               }

           }

       }

   }

}

------------------------------