1
Vote

Update PowerPoint Chart from C#

description

Hi experts,

I have biweekly reports in Excel format. These are very large and contain very sparse data across multiple areas of a Workbook. I need to use parts of this worksheet to update charts in a predefined PowerPoint presentation.

I looked up the existing examples and these all refer to adding new charts to an existing/blank presentation. I need to find an existing chart, tap into its data sheet and pour there data from predefined areas in an Excel sheet.

I also need this in C#. The goal is to develop a small Windows application that grabs data from Excel and dumps it on PowerPoint. This app should run standalone, not from within any of these applications (Excel or PowerPoint). However, an app running from within the PowerPoint presentation would be considered.

Attempts have been made to find data in the Excel sheet and this is not a big deal. What poses the biggest difficulty here is finding the charts in PowerPoint and dumping the new data on their data series. The difficulty is related to finding and grabbing hold of the existing charts.

These are native PowerPoint 2013 charts, not OLE objects. They don't seem to have a name or any other property that distinguishes them.

Currently, I have a very valuable human resource doing this, wasting away one out of every two weeks in this huge, repetitive and highly error prone task.

comments