Inst ToolsInst ToolsInst Tools
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Search
  • Books
  • Software
  • Projects
  • Process
  • Tools
  • Basics
  • Formula
  • Power Plant
  • Root Cause Analysis
  • Electrical Basics
  • Animation
  • Standards
  • 4-20 mA Course
  • Siemens PLC Course
Reading: How to Communicate with Excel from Intouch SCADA?
Share
Notification Show More
Font ResizerAa
Inst ToolsInst Tools
Font ResizerAa
  • Courses
  • Design
  • PLC
  • Interview
  • Control System
Search
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Inst Tools > Blog > PLC Tutorials > How to Communicate with Excel from Intouch SCADA?

How to Communicate with Excel from Intouch SCADA?

Last updated: March 4, 2021 12:06 pm
Editorial Staff
PLC Tutorials
2 Comments
Share
4 Min Read
SHARE

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

If you liked this article, then please subscribe to our YouTube Channel for PLC and SCADA video tutorials.

You can also follow us on Facebook and Twitter to receive daily updates.

Read Next:

  • Create Project in Wonderware
  • Namur Digital Input Card
  • Allen Bradley Powerflex VFD
  • Create an Application in Tia Portal
  • Scada Program using Script
Don't Miss Our Updates
Be the first to get exclusive content straight to your email.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
You've successfully subscribed !

Continue Reading

Learn PLC in Hindi
Function of Racks in PLC – Types of SIEMENS S7-400 PLC Racks
Siemens S7 300 CPU Status and LED Errors Explanation
Software Redundancy in Siemens PLC – Hardware versus Software
PLC Multiple Choice Questions
PLC Sinking and Sourcing Explanation
Share This Article
Facebook Whatsapp Whatsapp LinkedIn Copy Link
Share
2 Comments
  • Pradeep says:
    May 31, 2020 at 2:17 pm

    very insightful information

    Reply
  • Mohammed Amine En-naghimi says:
    February 21, 2021 at 1:45 am

    I have already installed Wonderware Intouch and followed all yours course until this lesson of DDE. And I follow the instructions in the video and the excel file didn’t get updated I don’t understand why?

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Stay Connected

128.3kFollowersLike
69.1kFollowersFollow
210kSubscribersSubscribe
38kFollowersFollow

Categories

Explore More

Free Mitsubishi PLC Online Training Course and Tutorials
Various Communication Protocols in PLC
Automated Test Bench – Complex PLC Programming Examples
How-to do Security of SCADA Systems?
Timers in Codesys – Timer ON, Timer OFF, Pulse Timer
How to Create New Project in Studio 5000?
Rockwell Automation Allen Bradley PLC for Smaller and Medium Projects
One Shot Rising PLC Example Program

Keep Learning

Retentive ON delay timer using PLC Logic

Retentive ON Delay Timer using PLC

Reading Clock data in PLC

Real-Time Clock in Omron PLC? – CX Programmer

PLC Automatic Pedal Switch for Speed Control

PLC Automatic Pedal Switch for Speed Control

PLC Load Memory

What is Resources Tab in the Siemens PLC?

In this article, we will learn the difference between Machine Expert Basic and Machine Expert software in Schneider PLC.

Difference between Machine Expert Basic and Machine Expert – Schneider PLC

PLC Programming Example for a Batch Process

PLC Programming Example for a Batch Process

PLC program pushbutton switches

PLC Permissive for Motor Control

Industrial Oven Control Application with PLC Controller

Industrial Oven Control Application with PLC Controller

Learn More

Difference between Power Cables and Signal Cables

Difference between Power Cables and Signal Cables

Pulse Timer Instruction in PLC Programming

Pulse Timer Instruction in PLC Programming

Series Parallel Circuit Analysis

Series – Parallel Circuit Analysis

Commissioning Checklist for Industrial Automation System

Commissioning Checklists for Industrial Automation Systems

HVDC transmission compared to HVAC transmission

Comparison of HVDC transmission and HVAC transmission

Advantages of Industrial Automation

Advantages and Disadvantages of Industrial Automation

6.6kV HV Induction motor Protection

Density-Measurement-using-DP-Transmitter-for-Closed-Tank-Dry-Leg

Closed tank Density Measurement using DP Transmitter with dry leg & constant level application

Menu

  • About
  • Privacy Policy
  • Copyright

Quick Links

  • Learn PLC
  • Helping Hand
  • Part Time Job

YouTube Subscribe

Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?