I need something to be done for my project, hope anyone has a solution.
I need to integrate excel's data from existing file(s) into PI Process book. Before that, I tried using Ole object but it doesn't work perfectly. it doesn't receive automatic update unless I open the excel file(s) and not to mention every time I tried to modify the Ole Object through process book it need to open a ghost excel application on the background.
Watched a youtube video about this, which showed how it can be done trough some macros and read some thread they said it is no longer possible for newer version of PI.
I am trying to create a dashboard that connects PI server data and Excel data.