AnsweredAssumed Answered

Displaying or Modifying Excel data in PI Process book

Question asked by indrabayu on Nov 29, 2019



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.