Home » How to Communicate with Excel from Intouch SCADA?
PLC Tutorials

How to Communicate with Excel from Intouch SCADA?

You know why SCADA is being used in industries. The main purposes are,

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

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

So we are gonna implement Excel communication from InTouch SCADA.

Communicate with Excel from Intouch SCADA

I am going to pull out a slider from the wizard and a tank from the symbol factory to make it graphically inclined.

Tank Level SCADA

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

I am giving the tag name ‘LT1’.

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

Define the Tag in Intouch scada

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

IO Real

After choosing I/O real we are going to give access name.

Intouch programming

Click on ADD to add an access name.

add access name in intouch

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.

The topic name should be the name of the excel file and the format of all excel files are .xlsx. Notice that we are going to use the DDE protocol to establish communication.

Intouch configure

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. Then save the tag and exit. Now the tag is ready to act as I/o tag.

So before going to the run time you have to open the Excel and create a new file with the same topic name as given in the Add access name dialog box leaving out the format and save the file anywhere.

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

Intouch tag names

Now we are going to run time.  Before going to the run time remember that the excel file which we saved is open already.

Communicate with Excel from Intouch SCADA

Notice that the value is accurately getting printed on the excel sheet. Since it was a real tag.

Author: Abishek D

Read Next:

Share With Your Friends

Related Articles

PLC Program to Control a Water Pump

S Bharadwaj Reddy

Yokogawa DCS and SIS System Architecture

S Bharadwaj Reddy

PLC Program for Paint Spraying

S Bharadwaj Reddy

InTouch SCADA Login Password Security

S Bharadwaj Reddy

Communicating Delta PLC Software to Simulator

S Bharadwaj Reddy

PLC Logic for Automatic Bending Machine for Exhaust Pipe

S Bharadwaj Reddy

1 comment

Pradeep May 31, 2020 at 2:17 pm

very insightful information

Reply

Leave a Comment

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

How to Communicate with Excel from Intouch SCADA?

WordPress Image Lightbox
Send this to a friend