Real-time Data Logging Using RSLinx OPC and Excel

In this video I'll show you how easy it is to get data out of your PLCs on the production and into an Excel spreadsheet in real-time.

Download Link:

Like what you see and want to buy me a coffee to keep going...great I could certainly use one! Just use this link here:

Become an official PLCGuru.NET supporter and get one of your very own PLCGurus.NET T-Shirt or some other great swag from our swag shop!

Also you can support me by becoming a Patron on our Patreon page:

If you like this video and want to see more like it, be sure to subscribe to our channel...and while you're at it, give us a "Like" too. Thanks for watching!

[controlsgirl]

Can you add data to the spreadsheet without having Excel open and running? do the values continue to rollover? anyother nuances for datalogging for if a customer wanted to log leak test values for each part that cycles through the machine?

[ardentdfender]

I know Studio 5000 is a huge application and in what it can do and there are many cool stuff, but i gotta say this is one the coolest features I've ever been made aware of and seen demonstrated. It's also something I don't think i've ever seen anyone made use of the usefulness of this functionality and i'm guessing they maybe didn't quite know how or was aware of it.
Question though: Does that data keep being pulled into Excel only when its open? What happen if you close Excel? Is there some limit to which the data stops plotting? Can you make multiple Real-Time Data Logging of different data points?

[dadlyBuzz]

This is using DDE and com object access rather than OPC though?

[bitodicontroltechnology]

The information you have provided was very helpful for my PLC studies. I have a question and I do not know if you will be able to help. I realize that you have Factory IO installed in your computer and I was wondering if you have ever try to run factory IO and Emulate 500. The reason I asking is that I have an issue creating filters with the RsLinx OPC server.

[navjotSingh-ydke]

also you must share plc program file too

[ahmedb]

very informative video, great job, many thanks.

[ahmedb]

Please do a video and explain how to archive data with excel. many thanks.

[NaserNorouzi]

Hi Fred, Thank you for such a useful video, i get an problem in my excel sheet, and it is telling me server error, do you have any clue?

[ramsesramirez]

In the real world, we would need to connect the PLC over Ethernet right? Is there any way we could have WiFi instead to create a local network for multiple PLC logging into the same server?

[Epsilon]

Is it needed to close the connection or something to close the spreadsheet and disconnect the PC from the PLC?

[sarathraj]

Great job.. may i know how to setup connection in ms_excel.

[ZacOwens]

Cool. I tried this today with real hardware and it works. However, I can't really get any more then the 120 rows out and then I get garbage in the spreadsheet cells. I tried playing with the polling time and nothing seems to increase the amount of rows I am able to transmit. It fails at 200 for me. Any tips to increase the capture size or is this basically the limit here?

[adelinasimanjuntak]

Sir I'd like to know if we can do datalogging from a simulator to excel? not using the real PLC.. sorry Im very new to this hope u dont mind!

[daleybread]

Great page, hope I'm not too late to win the Raspi!!

[BigTimeCharley]

FYI: / is "slash*" and \ is "backslash"


* / is also "foward slash, " but if the "forward" is left off and there is no "backward" in its place, then "forward" is implied


So it's


Just sayin'

[superezbz]

Unfortunately this will no longer work with Windows 10. Microsoft removed DDE support in 2020.

[LearnSomethingHelpful]

This no longer works because DDE is no longer allowed for Windows 10.

It needs to be OPC & not DDE

[Freedomusa]

Could have saved me 9 min of my time by stating the most significant point of this and that is having professional version of linx. Instead the first 9 minutes are of you explaining your code and how an emulator is setup. I was more interested in learning about OPC and excell. Please Youtubers get to the point.

[LGrove-epyl]

7:52 What is the data type for "Data_DDE"? Why do you have ".Time[...]" and [.Data_REAL[....]" under it?

[SofianeBENCHARIF-rqpw]

Please change the title, it's not an OPC connection, because here Excel is initiating a DDE conversation with RSLinx, unfortunatly this type of connection is so old not reliable, slow in case of large systems (conversations are updatind clients data one by one for each connection initiation ) not like OPC Asych . well the title should be "Real-time Data Logging Using RSLinx DDE and Excel"