anthony.buchanan

Modify a PITrend Excel Object in c#

Discussion created by anthony.buchanan on Aug 24, 2012
Latest reply on Aug 24, 2012 by RJKSolutions

Hi all,

 

I have a task of being able to modify a PITrend object within an excel sheet using C# - i.e I open the file using c# executable and looking for any Pi Trend object within it.

 

I am needing to retrieve all the trends and modify the server name value programatically within the trend object.

 

I am hoping for an answer to whether this is available through the PI SDK or some other means.

 

I have identified the Trend Object within Excel is stored as an OLEObject but am unsure what I can cast this object to and also determine if it is a Trend Object.

 

If any more information is required to help you understand what I need please let me know.

 

Thanks

Outcomes