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.