COM03. OPC UA - Microsoft Excel (OPC UA Client) and PLC (OPC UA Server)
ฝัง
- เผยแพร่เมื่อ 5 ส.ค. 2024
- #OPCUA #Excel #PLC #Siemens #S71200 #UaExpert
COM09. OPC UA - Siemens S7-1500(OPC UA Client) and S7-1200(OPC UA Server) TIA Portal
• COM09. OPC UA - Siemen...
Industrial Automation Data Collection playlist
• Industrial Automation ...
In this video, Microsoft Excel will run as OPC UA Client and a PLC controller Siemens S7-1200 V4.4 is the OPC UA Server. With this Client Libary and this test, you can use Excel to get the data and from PLC (built-in with OPC UA Server) directly.
OPC UA Client Library for Microsoft Excel
support.industry.siemens.com/...
The robot cell picture:
trends.directindustry.com/mot...
COM01.OPC UA - Siemens S7-1200 PLC(OPC UA Server) and UaExpert(OPC UA Client)
• COM01. OPC UA - Siemen...
COM02.OPC UA - Three OPC UA Client Tools For Free
• COM02. OPC UA - Three ...
COM08.OPC UA - BECKHOFF TwinCAT 3 TF6100(OPC UA Server) and UaExpert(OPC UA Client)
• COM08a. OPC UA Beckhof...
COM12.OPC UA - Connect PLC (PID Controller) to Matlab/Simulink (Process Model) via OPC UA
• COM12. OPC UA - Connec... - วิทยาศาสตร์และเทคโนโลยี
Best tutorials of automation, Thank you!
Thanks, Happy New Year!
Thank you very much for your video it was really helpfull greetings from mexico gracias 🙏
Glad it was helpful! Welcome!
you rock man!
Thanks!
Thanks.👍👍👍
Welcome 👍
Thanks
Welcome
I appreciate your video very much, can I ask, can I use 2 software on the same computer with the same OPC server (PLC) at the same time?
I think it could be. You could test it.
Thank you, Great tutorial.
Can u do video on How to Get the values to MsAccess database using this Library?
I am not familiar with MsAccess. I would recommend you could use the OPC/OPC UA software running as the interface between PLC and MsAccess.
One question... do i have to create server interface? 10:17 I heard that OPC works even without any server interface. It's enough to check ✔ the "access to OPC" Mark in the tags in DBs. Is that correct?
I would recommend the manual "support.industry.siemens.com/cs/document/109775168/opc-ua-server-of-the-s7-1200-cpus?dti=0&lc=en-WW". Also I recommend using server interface if you are using S7-1200. For S7-1500, making OPC in DB and Server interface all workable.
@@electricalautomation Thanks for taking your time and sending me the manual.
Yes iam using S7-1500 in TIA Portal v14, in that case i dont need to create "Server interface"?
So the Server interface is only a tag talble to external communication right? what if i USE server interface in s7 1500 and put some tags there, will the other tags outside the interface not communicate with external comunnication?
Thanks again for the professional way of explaining, i will hit the subscribe button.
@@genantamtam9364 For new version S7-1500, using server interface and DB OPA UA check both work. Personally I recommend using a server interface. However, TIA Portal V14 and its supported hardware firmware are a little bit old, I am not quite sure the specific firmware functionalities. how about do a quick try and see which way works better for you. I think both ways workable. Thanks for subscribing.
It is possibile to use this library for a connection client? No plc
Yes, This demonstration shows the Excel running as OPC UA Client, it can connect OPC UA Server evenif it is not a PLC.
HI, What Liscense should I have to install for the OPC in TIA?
As I know, likely there is no physical file needed to be in TIA Portal. The license is a certificate paper. For more specific, I would recommend asking Siemens support.
@@electricalautomation Thank you! and I made it work now, Further if I use UDT in the excel at read struct udt tab the values are not updating cyclically.?
any suggestions
@@satheeshkumaran274 I didn't try UDT in the list before. But if you find once you use the udt, then the communication will not work, then you'd better use a normal way. I recommend that not paying to much time on this try, because it might be the limitation on the current firmware of the CPU. Good luck!
Please do a video on getting data into OPC UA from RS232 devices.
Hello, you could use S7-1200 runs as a bridge, RS232 device S7-1200 + RS232 Signal board, then S7-1200 runs as OPC UA Server to communicate with any other OPC UA Client. S7-1200 PLC can play diversities roles, it is real handy controller with cost effective price.
does it work with any plc or only with s7-1500 ?
Any PLC with OPC UA functions, they should work.
When i complete path for opc.excel but can't getendpoint ,pop up error
Please advice
Use another OPC UA Client software for a test, e.g. UaExpert. Review every setting shown in the video. Also, turn off the windows firewall and anti-virus software
Hey man, thanks for your awesome tutorial. I've been using this library since 2021 and everything seems to be ok except for a little issue I have. for some reason the excel client seems to crash every 3-4 hours a day and the only work around I have is to manually reconnect to the database. I'm currently using WinCC Unified Runtime v17 (OPC UA Server) running on Windows Server 2022. Have you ever had the same issue like mine? I am using an allen bradley PLC as well and everytime this happens I can see crash logs for Excel.exe and WCCILpah.exe (libAllenBradleyEip.dll_unloaded).
Hi Joon, I didn't have this issue. Sorry for hearing this issue. May be you could try to use VB script to 'save as' the excel every 2 hours. also try to increase the RAM of your computer.
@@electricalautomation My RAM's 16GB I think i have enough ram, about saving, I think excel itself does auto saving quite often so I'm not quite sure your suggestion to 'save as' by VBS may help. I can try regardless. Thanks!
@@joonchoi5419 Except the software compatibility issue, I am slightly concern the buffer of the Excel is gradually increased. So "save as"/ or close-reopen can alternately release the RAM resources.
i'm having a problem when i want to get the endpoints in excell, i did the command prompt, i enabled the opcua in tia portal and i have made a opcua server. do i need to do anything else?
You could use UaExpert OPC UA Client software for a test, then you could have a rough idea if the Excel side has issue or you server side has issue.
@@electricalautomation the problem is in excell saying "microsoft visual basic, class not registered. Runtime error"
@@gabbermafia2Pls check the library register from 5:15.
@@electricalautomation Got it solved, i have redone the registration via cmd again and now it works.
@@gabbermafia2 Glad it got solved
Pls help it's showing run time error
Please make sure the runtime register was done correctly around 8:00
Hello. I am using an B&R OPC server I know that the certificat for the connection should be tranfert. Is it automatic. By clicking on "get point" I have an error message. Erreur d'exécution '-2147221164 (80040154)':
You could use another OPC UA Client for a test to connect your B&R OPC Server. This can validate if the problem comes from client or server.
您是中国人吗？
我是中国人，北京人
@@electricalautomation 谢谢你的回复，你的视频做的非常好！
@@leozhou65 欢迎！多谢！
@@electricalautomation 谢谢！Good Job! 我也刚想问，听得出来