AnsweredAssumed Answered

Can not write data to the PI Server from an Excel Spreadsheet using PIPutValx() function

Question asked by BinhVo on May 31, 2018
Latest reply on May 31, 2018 by Eugene Lee

Hi everybody,

I'm a newbie here. Currently, I want to write old data into PI Sever. My excel document has below format:

Time stampValue
1/1/2017 12:00:00 PM0
1/2/2017 12:00:00 PM2013.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.

A1.png

 

But, when I close excel document, all data are disappeard except the latest one.

A2.png

Am I doing it wrong? Please help me.

P/s: I'm using Microsoft excel 2013, run as administrator privilege

Outcomes