5 Replies Latest reply on May 31, 2018 7:55 AM by Eugene Lee

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


      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.



      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