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:
plcgurus.net/product/rslinx-o...
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:
paypal.me/plcgurusnet?locale....
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!
plcgurus.net/product-category...
Also you can support me by becoming a Patron on our Patreon page:
/ plcgurus
You are watching video's from PLCGurus.NET. Check out our blog and forums at plcgurus.net and become an active member in our growing community of professional engineers, technicians and technologists all centered around Industrial Automation. Membership is completely FREE!
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!

[@yangrong7868]

Great job!!!!Thank you so much

[@ahmedb8395]

very informative video, great job, many thanks.

[@jimmyflinn8718]

Very cool video

[@acluster3411]

very cool

[@mohammadmajzoub4061]

thanks

[@timkloehn9887]

Wow !

[@bfd420]

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

[@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?

[@bitodicontroltechnology4451]

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.

[@ardentdfender4116]

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?

[@PLCGurusNET]

Hi Ardent, thanks for all the comments. Yes, I'm this scenario Excel need to be open. If data retention was needed then I would certainly opt for a database. Another series perhaps that leverages C#, PLCs and SQL Server!

[@d3adlyBuzz]

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

[@superezbz]

Windows 10 no longer supports DDE.

[@Epsilon9494]

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

[@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?

[@adelinasimanjuntak3032]

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!

[@ZacOwens22]

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?

[@ramsesramirez1910]

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?

[@ahmedb8395]

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

[@fastabiqhidayatulah9444]

I need this too 😁

[@NaserNorouzi]

i need it as well

[@sarathraj6194]

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

[@blingVolcano]

you just create a basic line graph chart in excel, change the chart parameters to suit the data you want to see, then do as he does in the video beginning at 9:22

[@kcmo1992]

What download link below?

[@navjotSingh-yd9ke]

also you must share plc program file too

[@jouellet100]

this is using DDE, not OPC.

[@superezbz]

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

[@BigTimeCharley1956]

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 "haitch-tee-tee-pea-colon-slash-slash-..."
Just sayin'

[@PLCGurusNET]

Lol. That's funny you mentioned that because I realized I was saying it wrong a short time after..lol...you're the first to pick up on it. Well done!

[@BigTimeCharley1956]

@@PLCGurusNET LOL thx.

[@LearnSomethingHelpful]

This no longer works because DDE is no longer allowed for Windows 10.
It needs to be OPC & not DDE

[@Freedom1776usa]

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 TH-camrs get to the point.

[@SofianeBENCHARIF-rq5pw]

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"

[@LGrove-ep9yl]

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