Aspose.Words - Access the chart data worksheet with C# .NET

[docarr]

Hello,

We have a chart “Bar of Pie” in a word document which we can edit its data by using Microsoft Word option “Right Click > Edit Data > Edit Data in Excel”.

We are trying to accomplish the same idea Using Aspose.Words .NET, which is edit the chart data worksheet programmatically. The below doesn’t exist, but that’s what we are trying to accomplish:

Document myDoc = new Document("File.docx");
Node[] shapes = doc.GetChildNodes(NodeType.Shape, true).ToArray();

foreach (Shape shape in shapes)
{
         var workbook = shape.Chart.ChartDataWorkbook;
         var worksheet = workbook.Worksheets[0];

         worksheet.Cells["F3"].Value = "m";
         worksheet.Cells["F6"].Value = 5;
         worksheet.Cells["F9"].Value = 0.25;
}

myDoc.Save("File_Updaded.docx"), Aspose.Words.SaveFormat.Docx);

Are you able to help?

Thanks a mil.

Similar topics:
https://forum.aspose.com/t/how-can-i-modify-ms-graph-chart-values/16685/6
https://docs.aspose.com/slides/java/updating-existing-chart-using-aspose-slides/

[alexey.noskov]

@docarr Unfortunately, such feature is not available yet. The appropriate feature request is logged as WORDSNET-18468. I have linked your request to it. We will keep you informed and let you know once this feature is implemented.

[docarr]

@alexey.noskov

WORDSNET-18468

Hi Alexey,

Thanks for coming back to me on this. I see in another thread that this is already in development, any idea when is this expected to be released?

Thanks a mil,

https://forum.aspose.com/t/linq-reporting-engine-chart-generation-data-not-editable/247674

[alexey.noskov]

@docarr Unfortunately, currently we cannot provide you a reliable estimate. If everything goes smoothly the feature will be added in 2-3 months. But this is a rough estimate and you cannot 100% rely on it. We will be sure to inform you once it is implemented.

[docarr]

Hi @alexey.noskov,

Is there any update on the WORDSNET-18468? Do you know when updated expected date to launch?

Thanks a mil

[alexey.noskov]

@docarr Unfortunately, there is no estimate yet. The issue is currently in development. We will keep you updated and let you know once it is ready. Please accept our apologies for your inconvenience.