COM03. OPC UA - Microsoft Excel (OPC UA Client) and PLC (OPC UA Server)

[@BallAndBeam]

Best tutorials of automation, Thank you!

[@electricalautomation]

Thanks, Happy New Year!

[@genantamtam9364]

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?

[@electricalautomation]

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.

[@genantamtam9364]

@@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.

[@electricalautomation]

@@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.

[@nicoladelcolle3833]

It is possibile to use this library for a connection client? No plc

[@electricalautomation]

Yes, This demonstration shows the Excel running as OPC UA Client, it can connect OPC UA Server evenif it is not a PLC.

[@phaman695]

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?

[@electricalautomation]

I think it could be. You could test it.

[@leonardonieto4917]

Thank you very much for your video it was really helpfull greetings from mexico gracias 🙏

[@electricalautomation]

Glad it was helpful! Welcome!

[@geokou18]

you rock man!

[@electricalautomation]

Thanks!

[@ikkusoft]

Thank you, Great tutorial. Can u do video on How to Get the values to MsAccess database using this Library?

[@electricalautomation]

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.

[@rangaswamy8604]

Please do a video on getting data into OPC UA from RS232 devices.

[@electricalautomation]

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.

[@РусланЖаныбеков-ч7з]

Thanks.👍👍👍

[@electricalautomation]

Welcome 👍

[@satheeshkumaran274]

HI, What Liscense should I have to install for the OPC in TIA?

[@electricalautomation]

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.

[@satheeshkumaran274]

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

[@electricalautomation]

@@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!

[@claudio1371]

Thanks

[@electricalautomation]

Welcome

[@revolver2329]

does it work with any plc or only with s7-1500 ?

[@electricalautomation]

Any PLC with OPC UA functions, they should work.

[@YMM_Play-Learn]

When i complete path for opc.excel but can't getendpoint ,pop up error Please advice

[@electricalautomation]

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

[@gabbermafia2]

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?

[@electricalautomation]

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.

[@gabbermafia2]

@@electricalautomation the problem is in excell saying "microsoft visual basic, class not registered. Runtime error"

[@electricalautomation]

@@gabbermafia2Pls check the library register from 5:15.

[@gabbermafia2]

@@electricalautomation Got it solved, i have redone the registration via cmd again and now it works.

[@electricalautomation]

@@gabbermafia2 Glad it got solved

[@joonchoi5419]

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).

[@electricalautomation]

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.

[@joonchoi5419]

@@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!

[@electricalautomation]

@@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.

[@joymohadani9366]

Pls help it's showing run time error

[@electricalautomation]

Please make sure the runtime register was done correctly around 8:00

[@virlocloic]

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)':

[@electricalautomation]

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.

[@leozhou65]

您是中国人吗？

[@electricalautomation]

我是中国人，北京人

[@leozhou65]

@@electricalautomation 谢谢你的回复，你的视频做的非常好！

[@electricalautomation]

@@leozhou65 欢迎！多谢！

[@rudishen2222]

@@electricalautomation 谢谢！Good Job! 我也刚想问，听得出来