AnsweredAssumed Answered

Upload and Retrieve PI Data Using Excel

Question asked by donices on Oct 11, 2019
Latest reply on Oct 11, 2019 by mfoerster

Hello,

I want to manually add data to PI using excel. For example, record down times in an excel sheet and upload this data on PI server so that i can retrieve such data in future. I am currently using windows 10 and excel 2016. Please can anyone help me how to write a code/macros to do this task?

 

See template of what i want to do below;

      Upload to PIRetrieve from PI
Date HrsDowntime 1Downtime 2
10/10/20190.21Low Feed
10/10/20190.50Hang up

Outcomes