How to communicate with PLC via Excel?
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.
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.
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.
Create DDE OPC Topic
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.
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 Tag : Timer_On_Delay.Acc
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.
You can find the topic name you set from the Topic Configuration window and change it to 100 ms as follows
You can also write to Excel like reading data from plc.