×
Siemens Industry Online Support
Siemens AG
Entry type: Application example Entry ID: 109748892, Entry date: 06/10/2020
(10)
Rate

OPC UA Client Library for Microsoft Excel

  • Entry
  • Associated product(s)
Access to the OPC UA Server of a SIMATIC S7-1500 via Excel VBA.

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



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
  Documentation (1,1 MB)
 Registrierung notwendig  Visual Studio project, OPC UA Client Library and Excel example (6,4 MB)
SHA-256 Checksum: 88CDE0DCDDC0BB5FB7100DADFC5E290E03CC2178762AA5A4B24980F1DDBF8928

You can find Informations to SHA-256 at the entry
How do you determine the SHA-256 checksum of a file?

 
Last Changes
Added ReadStructUdt

Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit
https://www.siemens.com/cybersecurity#Ouraspiration.
Rate entry
no rating
Requests and feedback
What do you want to do?
Note: The feedback always relates to the current entry / product. Your message will be forwarded to our technical editors working in the Online Support. In a few days, you will receive a response if your feedback requires one. If we have no further questions, you will not hear from us.