The main purpose of SCADA in industries is,

  1. For Data Acquisition
  2. Graphical Control.
  3. Easy to interpret with data while controlling field instruments from the SCADA.

There may be times when we have to store the data in the spreadsheet for later use or visualize them instantly.

So now we are going to implement how we can communicate Excel from InTouch SCADA.

Data Communicate with Excel from AVEVA InTouch HMI 2023

First of all, I am going to pull out a slider & tank from the industrial graphics Library to make it graphically inclined.

Now we are going to assign an analog tag to the slider by double-clicking it.

I am giving the tag name ‘Tank_Level’.

Now it’s going to ask to define the tag.

I will choose the tag as I/O real. This means this tag can act as input to this project or output from the project to another software.

After choosing I/O real we are going to give an access name, click on ADD to add an access name. We have given “Communication”, which will be used for specifically this project,

You can give any name to the Access text box. Notice that the node name has to be empty. The application name is Excel since we are going to communicate with it.

Select “DDE” in which protocol to use,

After adding the access name there will be a text box called “item”, we have specified in there which column and row the value has to be stored in the Excel sheet. We put “R1C1” Then save the tag and exit. Now our created tag is ready to act as an I/O tag.

So before going to the run time you have to open Excel and create a new file with the same topic name with proper extensions as given in the Add access name (we created as “Tank_Level.xlsx”) dialog box leaving out the format and save the file anywhere on the same system.

Now we are going to give a Break cell to the tank and access the percent fill of the tank. I am going to give the same tag name here so whenever there is movement on the slider it’ll reflect on the fill percent of the tank.

Now we are going to runtime (upper right corner), before going to the runtime remember that the Excel file which we saved is open already.

Notice that the value is accurately getting printed in the Excel sheet since it was a real tag.

Another side, you can check, if we enter 50 in the R1C1 cell and hit enter, changes will be done on the slider & tank level as well,

If we enter 75 then it works the same and shows the result accordingly.

If you are looking for any AVEVA InTouch HMI solutions reach us at contact@asteamtechno.com for
Support | Solution | Inquiry | Upgradation | Modification