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.