Hi Mudassir,
As per your previous post, I am attaching the sample source code as well as the Output presentation.Please find the same in the attachment Output.ppt.
Below is the sample code snippet to replicate the issue.
string[] cellsName = new string[] {
"A1", "A2", "A3", "A4",
"B1", "B2", "B3", "B4",
"C1", "C2", "C3", "C4" };
//Array of cell data
int[] cellsValue = new int[]
{ 64,86,68,91,
41,64,89,48,
48,97,78,60
};
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
wb.Worksheets.RemoveAt(0);
//Add a chart sheet
int chartSheetIdx = wb.Worksheets.Add(Aspose.Cells.SheetType.Chart);
Aspose.Cells.Worksheet chartSheet = wb.Worksheets[chartSheetIdx];
chartSheet.Name = "ChartSheet";
//Add a new worksheet to populate cells with data
int dataSheetIdx = wb.Worksheets.Add();
Aspose.Cells.Worksheet dataSheet = wb.Worksheets[dataSheetIdx];
string sheetName = "DataSheet";
dataSheet.Name = sheetName;
for (int i = 0; i < cellsName.Length; i++)
{
string cellName = cellsName[i];
int cellValue = cellsValue[i];
dataSheet.Cells[cellName].PutValue(cellValue);
}
//Add a chart in ChartSheet with data series from DataSheet
int chartIdx = chartSheet.Charts.Add(Aspose.Cells.ChartType.Line, 0, 0, 0, 0);
Aspose.Cells.Chart chart = chartSheet.Charts[chartIdx];
chart.NSeries.Add(sheetName + "!A1:A4", true);
chart.NSeries.Add(sheetName + "!B1:B4", true);
chart.NSeries.Add(sheetName + "!C1:C4", true);
chart.NSeries[0].Name = "UNITS";
chart.NSeries[0].Area.ForegroundColor = System.Drawing.Color.FromArgb(154, 153, 255);
chart.NSeries[1].Name = "VALUE";
chart.NSeries[1].Area.ForegroundColor = System.Drawing.Color.FromArgb(153, 51, 101);
chart.NSeries[2].Name = "GVALUE";
chart.NSeries[2].Area.ForegroundColor = System.Drawing.Color.FromArgb(255, 255, 203);
//Set ChartSheet an active sheet
wb.Worksheets.ActiveSheetIndex = chartSheetIdx;
Bitmap imgChart = wb.Worksheets[chartSheetIdx].Charts[0].ToImage();
MemoryStream wbStream = wb.SaveToStream();
int picId = -1;
Aspose.Slides.License license = new Aspose.Slides.License();
license.SetLicense("Aspose.Slides.lic");
Presentation pres = new Presentation();
Slide sld = pres.GetSlideByPosition(1);
if (imgChart != null)
{
Aspose.Slides.Picture pic = new Aspose.Slides.Picture(pres, imgChart);
picId = pres.Pictures.Add(pic);
}
int slideWidth = pres.SlideSize.Width;
int slideHeight = pres.SlideSize.Height;
byte[] chartOleData = new byte[wbStream.Length];
wbStream.Position = 0;
wbStream.Read(chartOleData, 0, chartOleData.Length);
OleObjectFrame oof = sld.Shapes.AddOleObjectFrame(0, 0, slideWidth, slideHeight, "Excel.Sheet.8", chartOleData);
oof.PictureId = picId;
pres.Write(@"C:\temp\Output.ppt");
Regards,
Mahalakshmi
