We have a daily process that generates an Excel file by pulling data from database and updating an Excel template with the data, then outputting the Excel file. We also have a Powerpoint file that contains Excel charts from the Excel that was generated by the daily process. Currently, a human has to open the Powerpoint presentation everyday to update the charts in it from the generated Excel. Is it possible to use Aspose to write a program that does this automatically? We do not want to create a brand new Powerpoint presentation from the Excel charts, because we would still like to keep the current format and other contents in the Powerpoint template, and only “refresh” the charts in it from those in the Excel file. We would also like to keep the chart size and format in the Powerpoint as defined in the template file, but only refresh the chart content.
An alternative we have is to use a VBA macro in the Powerpoint and make the charts in the powerpoint as “linked” OLE objects to the external Excel file. But the drawback of this approach is that the charts in the Powerpoint are not self-contained (i.e., the Excel file has to be kept with the Powerpoint in emails). That is why we are exploring Aspose to see if a java program can be written to handle this “chart refreshing” in Powerpoint.