How to change PowerPoint chart data with .NET? -


I have a PowerPoint template that has a slide and a chart on that slide. I want to be able to use data from that chart to use NAT.

So far I have the code ...

  1. Opens the Powerpoint file.
  2. Opens the embedded Excel file (PPT \ Amberds \ Microsoft_Office_Excel_Worksheet1.xlsx)
  3. It manipulates data in excel sheet successfully and pins it back.
  4. Opens and manipulates Ppt \ charts \ chart1.xml
  5. Then the pipe point is zipped up and given to the user

The result is a PowerPoint file that shows blank charts but when I click on the chart and edit the data, it updates the data and shows the correct chart.

I believe my problem is with chart1.xml which I am generating. I have compared my generated version to the version created by PowerPoint and they are almost identical. The only difference is & lt; C: crossAx / & gt; and & lt; C: axId / & gt; Values ​​of

There are also some goals difference in the data but I do not think the result will be a blank chart.

Is there any other file that I want to edit? Does anyone have the idea that I should do this work and what should I do?

This is probably a combination of renewable value and spherical issues Axis ID, possibly asking for an integer value And you can supply a single / double, so the cached data in chart1.xml does not know how to display.

Try to manipulate exactly what you are doing, but instead of opening the result in PowerPoint, replace .pptx extention. Correct the rounding problems manually for zip, unzip, and then matching the original roundness. Then back up, change the extension back to .pptx and open it in PowerPoint. If it fixes the issue of the display, then you can make sure that this is the rounding problem.

Alternatively, open your resulting PPTX in PowerPoint as you are doing with the same line, and once you've right clicked and re-hired the chart If given, save as a separate file name and compare it with your automated results.


Comments