I'm a newbie here. Currently, I want to write old data into PI Sever. My excel document has below format:
|1/1/2017 12:00:00 PM||0|
|1/2/2017 12:00:00 PM||2013.12|
|1/3/2017 12:00:00 PM...||6151.8...|
I use PIPutValx function (PIPutValx("Bunge.SB.IS1", value, time stamp, "My PI Server", outcell)to write data to PI, the result cells displayed "Value written". I had checked in PI SMT > Data > Archive Editor, everthing was okay.
But, when I close excel document, all data are disappeard except the latest one.
Am I doing it wrong? Please help me.
P/s: I'm using Microsoft excel 2013, run as administrator privilege