Sample code for inserting charts into spreadsheet is not working

[Rohan-git-hub]

It edits the file and when I open the file it shows

The sample code(for C#) was provided here :- https://docs.microsoft.com/en-us/office/open-xml/how-to-insert-a-chart-into-a-spreadsheet

[tomjebo]

@Rohan-git-hub, can you provide the version of the Open XML SDK that you're targeting?

[tomjebo]

Just FYI, I tested the sample code with the latest SDK from github and with V2.5 and they both had that same behavior. We will have to create a new sample to demonstrate how to add the chart as it looks like this hasn't worked for a long time.

[Rohan-git-hub]

@tomjebo I am using Open XML SDK version 2.9.1

[Rohan-git-hub]

Hi @tomjebo any update on this and can you please share an alternate resource for the same.

[rank-p]

I'm running into the same issue. Is there any update or workaround or other resource on the internet that explains it correctly?

[archerofthemark]

I've managed to get the C# sample code working, simply by replacing the link in the C# example

graphicFrame.Append(new Graphic(new GraphicData(new ChartReference()            { Id = drawingsPart.GetIdOfPart(chartPart) }) 
        { Uri = "https://schemas.openxmlformats.org/drawingml/2006/chart" }));

with

graphicFrame.Append(new Graphic(new GraphicData(new ChartReference()            { Id = drawingsPart.GetIdOfPart(chartPart) }) 
        { Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" }));

Hopefully this helps.

[tomjebo]

@archerofthemark Thanks for letting us know!

[mikeebowen]

closed by

• Extract code snippets from markdown files #296