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 RsLinx?
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 RsLinx?

How to Communicate with Excel from RsLinx?

I am using RsLogix 500 here to communicate with Rslinx to write the data from PLC to excel. You can also use RsLogix 5000.

Last updated: March 4, 2021 11:21 am
Editorial Staff
PLC Tutorials
No Comments
Share
3 Min Read
SHARE

There are times in which we want to acquire all our PLC’s data into a spreadsheet to get a clear view or something.

Now let’s see How we can communicate with Microsoft Excel from RsLinx to write the data to excel?

I am using RsLogix 500 here to communicate with Rslinx. You can also use RsLogix 5000 also.

Now I will create a sample program in Rslogix 500 to communicate with Excel.

TON Timer in Rslogix 500

I have created a Reset timer for 20 seconds. Basically, the timer runs for 20 seconds and resets itself and runs again endlessly.

The communication protocol we are gonna use here is the Dynamic Data Exchange or DDE protocol.

Training: Allen Bradley PLC

Communicate with Excel

Now let’s got to Rslinx, First of all, create a communication driver Emu-500 for running the program in an emulator.

Now go to DDE/OPC then click on the topic configuration.

A dialog box opens up as shown below.

RSlogix 500 to communicate with Excel

The driver we created will be shown on the right side of the box Click on the Plc icon that is shown. The Model of the processor changes automatically to the program that we created on Rslogix 500.

After clicking on the PLC icon click new to create a topic. So when we now create a topic it will be associated with the processor we clicked that is Micrologic 1200 here.

ControlLogix PLC to Excel Read Values

We have created a topic Excel and press yes to update it.

Now we will go and download the program in Rslogix 500 and change the processor to run mode.

Now create a workbook in Excel and now we have to activate the DDE command through Excel.

DDE command in Excel

Just Click randomly on any cell and write the formula, The syntax is as follows,

= Application Name|Topic Name!’TagName,L1,C1.

So for the application, I created here the function for activating DDE protocol Goes like this,

=RSLINX|Excel!’T4:0.ACC,L1,C1’

After Pressing enter since the program is in run mode the value of the accumulator in timer will instantly be updated here. The value changes as the timer run.

Export Live Analog values from PLC to Excel

The above is our final Output. We can use this for many creative projects, Like where we have to visualize the data in real-time like that.

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:

  • InTouch SCADA to Excel
  • FIFO Instruction in PLC
  • Advantages of RTO Timer
  • Scaling for Analog Input
  • Configuration of Alarms
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

Difference between Compact PLC and Modular PLC
PLC Automatic Door Control System – Programming Example
PLC Valve Control Ladder Logic Programming
Programmable Logic Controller Practice Tests
Factory Acceptance Test (FAT) of a PLC Panel
What is NOR Flash Memory in PLC?
Share This Article
Facebook Whatsapp Whatsapp LinkedIn Copy Link
Share
Leave a Comment

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

How to use Sub Routines with Allen Bradley PLC
PLC Controlled Conveyor and Weighing with Labeling Automation
What is a Data Block? Global Data Blocks in PLC
Industrial Networking and Wireless Interview Questions
What is Relay Logic ?
Simulation of Studio 5000 and FactoryTalk View Studio
Types of Interlocks
How to Backup and Restore from Simatic Prosave HMI?

Keep Learning

Downloading Free PLC software

Step by Step Guidelines for Downloading Free PLC software

PLC Technique for IO Mapping

PLC Techniques for I/O Mapping

Software Troubleshooting Errors and Faults in Siemens PLC

Software Troubleshooting Errors and Faults in Siemens PLC

Using Clock Memory Bits in TIA Portal - Siemens PLC

Using Clock Memory Bits in TIA Portal – Siemens PLC

Basics of Motion Controllers

Basics of Motion Controllers

PLC attendance system design

Attendance System PLC Program using CX-Programmer

Job Skills Required for Industrial Electrical Maintenance

Job Skills Required for Industrial Electrical Maintenance

Reading Clock data in PLC

Real-Time Clock in Omron PLC? – CX Programmer

Learn More

Time Response Analysis

Approximation of Higher-Order Systems by Lower Order

Temperature and Humidity Objective Questions

Temperature and Humidity Objective Questions

Top 80+ Valve Questions and Answers

Top 80+ Valve Questions and Answers

Industrial Internet of Things Projects

Top 100 Industrial Internet of Things Projects (IIoT)

Calculate Power in Parallel RC Circuit

Calculate Power in Parallel RC Circuit

valve actuator yoke

Advantages and Disadvantages of Valve Actuators

Nameplate Markings

Explosive Atmospheres & Hazardous Classification

Air Release Valve

What is an Air Valve? Purpose, Types, Advantages, Disadvantages

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?