How to done excel macro for kepware logs
My best compliments,
In my system for energy SCADA using IEC61850 via Kepware OPC IEC Client. I connected with PLC connect and energy values comes to the 800xA control structure and logging succesfully. However I need report of these values. When I try ABBGetOPCDA ABB OPC logs reported succesfully. How to report Kepware OPC logs within excel macros. Any sample screenshot for this aim.
Voted best answer
It does not matter from where the logged data is collected; DataDirect's ABBGetOPCHDA() function work the same.
Use the third button of the DataDirect Add-In to launch an "ABBGetOPCHDA() function Wizard" and browse to the object and log, enter parameters for read (start/stop time, number of values, aggregate, etc.) then tick "Output=Formula" before clicking OK.
With formula output (marked with yellow) its easy to find out how you can use the ABBGetOPCHDA() function without going through the "Wizard".
Normally you do all the data gathering & computations on an Excel tab that you later make "Hidden", then goto the visible "Report Output" tab and make formula references to the hidden tab.