Hi,
We are trying to create a PowerPoint (.pptx) export using a workbook by using the following code. But in the PowerPoint slide the chart shows redundant categories up to which the data source template of the chart selected previously. We had hidden the redundant columns from the code. But still the redundant categories/columns upto which the data source of chart are selected, are shown.
The code has given below-
var pptx = new PresentationEx("..\\..\\Template\\Template.pptx");
ShapeEx shape = pptx.GetShape("ChartHolder");
ChartEx chart = (ChartEx)shape;
int prevSeries = chart.ChartData.Series.Count;
int prevCat = chart.ChartData.Categories.Count;
Workbook wb = new Workbook(chart.ChartData.ReadWorkbookStream());
wb.Worksheets[0].Cells[0, 0].PutValue("");
wb.Worksheets[0].Cells[0, 1].PutValue("Series1");
wb.Worksheets[0].Cells[0, 2].PutValue("Series2");
wb.Worksheets[0].Cells[0, 3].PutValue("Series3");
wb.Worksheets[0].Cells[1, 0].PutValue("Category1");
wb.Worksheets[0].Cells[1, 1].PutValue(2);
wb.Worksheets[0].Cells[1, 2].PutValue(6);
wb.Worksheets[0].Cells[1, 3].PutValue(0);
wb.Worksheets[0].Cells[2, 0].PutValue("Category2");
wb.Worksheets[0].Cells[2, 1].PutValue(6);
wb.Worksheets[0].Cells[2, 2].PutValue(2);
wb.Worksheets[0].Cells[2, 3].PutValue(6);
wb.Worksheets[0].Cells[3, 0].PutValue("Category3");
wb.Worksheets[0].Cells[3, 1].PutValue(6);
wb.Worksheets[0].Cells[3, 2].PutValue(8);
wb.Worksheets[0].Cells[3, 3].PutValue(3);
wb.Worksheets[0].Cells[4, 0].PutValue("Category4");
wb.Worksheets[0].Cells[4, 1].PutValue(7);
wb.Worksheets[0].Cells[4, 2].PutValue(-8);
wb.Worksheets[0].Cells[4, 3].PutValue(-5);
wb.Worksheets[0].Cells[5, 0].PutValue("Category5");
wb.Worksheets[0].Cells[5, 1].PutValue(3);
wb.Worksheets[0].Cells[5, 2].PutValue(4);
wb.Worksheets[0].Cells[5, 3].PutValue(15);
if (prevCat >= 3)
{
for (int i = prevCat; i >= 3; i--)
wb.Worksheets[0].Cells.HideColumn(i); // Hide the extra columns
}
MemoryStream ms2 = new MemoryStream();
wb.Save(ms2, SaveFormat.Xlsx);
wb.Save("D:\\ExportedNew.xlsx", SaveFormat.Xlsx);
ms2.Position = 0;
chart.ChartData.WriteWorkbookStream(ms2);
if (prevSeries >= 5)
{
for (int i = prevSeries; i >= 5; i--)
chart.ChartData.Series.RemoveAt(4); //Delete the extra row
}
chart.PlotVisibleCellsOnly = true;
pptx.Save("D:\\ExportedNew.pptx", Aspose.Slides.Export.SaveFormat.Pptx);
If we select the chart object and right click and select "edit data" then it shows in the correct format i.e. with exact category number shows in the chart.
The template(Template.pptx) we used, real output file(OutputWithError.pptx) and the output should be like file(OutputShdBe) are attached with this post.
Need help and feedback urgently regarding this...Thanks!