PLC Programming
  • Home
  • PLC Forum
  • Contact Us
  • PLC & HMI
  • Electric & Electronic
No Result
View All Result
PLC Programming
  • Home
  • PLC Forum
  • Contact Us
  • PLC & HMI
  • Electric & Electronic
No Result
View All Result
PLC Programming
No Result
View All Result

How to get data from plc to excel

How to get data from plc to excel
Share on FacebookShare on Twitter

In order to get data from PLC with Excel, we need to use OPC. If you are using Rockwell Allen-Bradley plc, no other tool is required for OPC because we can transfer data from Allen-Bradley PLCs via OPC with the RSlinx application. Note that the RSLinx application we will only use is not the Lite version.
RSLinx Lite versions do not support data transfer such as OPC, DDE, but you can configure drivers to connect to the PLC.
In order to be able to view a tag ready in the PLC in the Excel you created, you need to have your RSLinx program open and create OPC connected to the PLC.

If your Rslinx version looks like the one below, it indicates that your RSLinx version is the Lite version and as I mentioned above, you can’t get data from the PLC.

plc programming img 5ff1d0fcf2e98 plc

The RSLinx version is license related, if you see the version as Lite and you have purchased another license, you must make sure that your RSLinx program is licensed. If you see RSLinx as OEM or RSLinx Gateway as below, there is no problem.

plc programming plc

plc programming RSLinx Launch Control plc plc programming plc

If your RSLinx program is running as a service, it means it is running in the background and the interface of your RSLinx program is not displayed. In these cases, you should stop your application from the RSLinx Launch Control Panel, remove the Always Run As Service option and run it again.

 

 

 

RelatedPosts

Omron PLC CX-Programmer – I/O Table Creation

PLC Flip-Flop Example Code

PLC Controller Firmware Upgrade

Right-click on your PLC processor in the RSLinx program interface,
After clicking Configure New DDE / OPC Topic, click the Done button by naming DDE / OPC in the window that will appear. Now our communication interface is ready, we can access all tags in our plc processor from anywhere, through this topic.

plc programming OPC 1 plc

 

Since we will read the data from the plc with the excel file for now, we open our excel page and then write the following formula in our cell where we want to see the data. You can organize it according to your own tag name and the DDE / OPC topic title you created.

plc programming img 5ff1d820ef6b6 plc

=RSLINX|PlctrCom_Excel!’Timer_On_Delay.Acc,L1C1′

OPCName: PlctrCom_Excel

PLC Tag : Timer_On_Delay.Acc

plc programming plc

 

The transfer speed between PLC and Excel is set to 1000 ms by default, if you want to read faster data, click the menu below.

plc programming img 5ff1daa8e5f7e plc

You can find the topic name you set from the Topic Configuration window and change it to 100 ms as follows

plc programming img 5ff1dac578c37 plc

You can also write to Excel like reading data from plc.

Tags: excelget dataplcplc to excel
Previous Post

PLC Function Blog Diagram (FBD)

Next Post

Siemens PLC Programming, S7-300 and S7-400 (SIMATIC S5) PLC

Related Posts

Omron PLC CX-Programmer – I/O Table Creation
PLC & HMI

Omron PLC CX-Programmer – I/O Table Creation

PLC Indirect Addressing
PLC & HMI

PLC Indirect Addressing

PLC Flip-Flop Example Code
PLC & HMI

PLC Flip-Flop Example Code

Plc Troubleshooting
PLC & HMI

Plc Troubleshooting

PLC Controller Firmware Upgrade
PLC & HMI

PLC Controller Firmware Upgrade

Connect to PLC via USB cable
PLC & HMI

Connect to PLC via USB cable

Next Post
Siemens PLC Programming, S7-300 and S7-400 (SIMATIC S5) PLC

Siemens PLC Programming, S7-300 and S7-400 (SIMATIC S5) PLC

Please login to join discussion

You might also like

Omron PLC CX-Programmer – I/O Table Creation

Omron PLC CX-Programmer – I/O Table Creation

PLC Indirect Addressing

PLC Indirect Addressing

PLC Flip-Flop Example Code

PLC Flip-Flop Example Code

Plc Troubleshooting

Plc Troubleshooting

PLC Controller Firmware Upgrade

PLC Controller Firmware Upgrade

Connect to PLC via USB cable

Connect to PLC via USB cable

PLC Programming & Automation

PLC Programming

The objectives of PLCtr are to provide practical instruction and help for anybody involved with PLCs from the maintenance staff to the PLC programmer. You don’t necessarily have to be a “writer” to contribute. If it has anything to do with any PLC and the devices connected to it then we are interested. If you want to become a writer, please write to us on the contact page. Join us.

Tags

alarm allen-bradley ALMA analog codes comminucation communication connect control controller ControlLogix cpu devicenet download driver EDS error errors ethernet example factorytalk fault Function instruction issue Ladder Major motor network plc problem program Programming rockwell rslinx rslogix siemens software start state stop Studio 5000 tag timer trend

Contact Us

PLC Programming

The objectives of PLCtr are to provide practical instruction and help for anybody involved with PLCs from the maintenance staff to the PLC programmer. You don’t necessarily have to be a “writer” to contribute. If it has anything to do with any PLC and the devices connected to it then we are interested. If you want to become a writer, please write to us on the contact page. Join us.

  • Home
  • PLC Forum
  • Contact Us
  • PLC & HMI
  • Electric & Electronic

© plctr.com PLC Programming | PLC Forum.

No Result
View All Result
  • Home
  • PLC Forum
  • Contact Us
  • PLC & HMI
  • Electric & Electronic

© plctr.com PLC Programming | PLC Forum.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT