plc.myforum.ro

valz · Member 3 Joined: 26 Jul 2015 Posts: 771

OPC UA Client Library for Microsoft Excel
https://support.industry.siemens.com/cs/document/109748892/
Access to the OPC UA Server of a SIMATIC S7-1500 via Excel VBA

Accessing directly from Microsoft Excel the OPC UA Server of a SIMATIC S7 controller (e.g. S7-1500) is a very frequent application case. An object library establishes the connection between Excel and the OPC UA Server and thus provides very easy access to the variables of an OPC UA server. In this example, the OPC UA Excel Client created with the object library communicates with the OPC UA server of a SIMATIC S7-1500.

The SIMATIC S7-1500 OPC UA server is engineered and configured via TIA Portal. Client and Server are connected via Ethernet and communicate via OPC UA via TCP/IP.

OPC UA Client Library for Microsoft Excel OPC UA Client Library for Microsoft Excel

OPC UA Client Library for Microsoft Excel OPC UA Client Library for Microsoft Excel

Fig. 1
The following functions are implemented in the object library:
GetEndPoints
Connect/Disconnect
ReadValues/WriteValues
ReadStructUdt
RegisterNodeIDs/UnregisterNodeIDs
Subscribe/ Unsubscribe
AddMonitorItem/RemoveMonitorItem
CallMethod
The OPC UA Client Library uses internally the class C# "UAClientHelperAPI" from the entry "OPC UA .NET Client for the SIMATIC S7-1500 OPC UA Server" (109737901). This class comprises the basic functions of the OPC Foundation’s .NET stack. The Visual Studio project includes the complete Source Code of the object library and thus enables you to add this functionality to further OPC UA objects.

Documentation and Example Project
https://support.industry.siemens.com/cs/attachments/109748892/109748892_OPC_UA_ClientLibrary_DOC_V2_1_en.pdf
https://support.industry.siemens.com/cs/attachments/109748892/109748892_OPC_UA_ClientLibrary_CODE_V2_1.zip

https://ulozto.net/tamhle/ewUo4uIkU2mg/

[URL=https://www.file-upload.net/download-15143424/109748892_OPC_UA_ClientLibrary_CODE_V2_1.zip.html]109748892_OPC_UA_ClientLibrary_CODE_V2_1.zip[/URL]
[URL=https://www.file-upload.net/download-15143423/109748892_OPC_UA_ClientLibrary_DOC_V2_1_en.pdf.html]109748892_OPC_UA_ClientLibrary_DOC_V2_1_en.pdf[/URL]