Hi, i’m trying to access OleObjectFrame (Excel worksheet) in a template and update ObjectData to populate new set of information from database. This does not seem to be working as i still see placeholder data in the created pptx file. However, when i click edit on the shape, its getting replaced with the data that was populated programatically from the database. How do i make sure that i see correct shape without having to click edit after pptx file is created?
if (ole != null)
{
//test data
double[] wbRows = { 0, 65, 35, 75, 23 };
double[] wbColumns = { 10, 30, 23, 15, 26, 27, 53, 30 };
int wbRowCount = wbRows.Count();
int wbColCount = wbColumns.Count();
//Reading object data in Workbook
Aspose.Cells.Workbook Wb;
using (System.IO.MemoryStream msout = new System.IO.MemoryStream())
{
Wb = new Aspose.Cells.Workbook();
for (int r = 0; r < wbRowCount; r++)
{
for (int c = 0; c < wbColCount; c++)
{
Wb.Worksheets[0].Cells[r,c].PutValue(wbRows[r]);
}
}
ole.ObjectProgId = “Excel.Sheet.12”;
ole.ObjectName = “Worksheet”;
Aspose.Cells.OoxmlSaveOptions so1 = new Aspose.Cells.OoxmlSaveOptions(Aspose.Cells.SaveFormat.Xlsx);
Wb.Save(msout, so1);
//Changing Ole frame object data
msout.Position = 0;
ole.ObjectData = null;
ole.ObjectData = msout.ToArray();
ole.UpdateAutomatic = true;
}
}