In Today's article I'll walk you through how you can bring Allen-Bradley Programmable Controller Data into Microsoft Excel 2016 using RSLinx Classic.
NOTE: The below procedure works with any licensed copy of RSLinx Classic, including Single Node, OEM, and Gateway shown below. However, it will not work with the free “Lite” version.
Step 9) And click on OK when done:
To watch a video demonstration of the above, check out Episode 41 of The Automation Minute Season 4 below:
If you found this article helpful, please share it with your colleagues on LinkedIn, Facebook, Twitter or Goggle Plus!
And if you know anyone who would benefit from Allen-Bradley PLC, HMI, or SCADA training, please let them know about my affordable courses over at TheAutomation School.
You can also share your own thoughts and opinions on this subject by clicking on the “post a comment or question” link below.
Enjoy the benefits of membership! Insider news, rewards, & more: Patreon.com/automation
If you enjoyed my article, you may like my courses at TheAutomationSchool.com
Have a question on this topic? Click here to scroll down to the comment link
Have a news tip? Share it with us here
Latest posts by Shawn Tierney (see all)
- Siemens Basic HMI Product Overview (P52) - April 9, 2020
- ViewSE on Ethernet to PLCs on Data Highway Plus via Logix Gateway (Early Access) - April 7, 2020
- RSView32 Direct Drivers to MicroLogix on DH485, PLC5 via DF1 (S37) - April 5, 2020
Click HERE to scroll down to view or leave comments
- Does this procedure allow you to store data or is it real time only?
My client wants to perform 5 task, storing 3 data points for each task and the once a week download the spreadsheet.
Is this possible@BB32152,
I'll let the article and video speak for themselves 🙂
If you decide you don't want to write Excel VBA code to automate data collection, there are lots of products out there that will do this for you, plus you can also write PLC code to store data in the PLC and then use a button in Excel to read that stored data into Excel.
Best of luck,
Instructor at The Automation School