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

OPC UA Client Library

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



Figure 1

The following functions are implemented in the object library:

  • GetEndPoints
  • Connect/Disconnect
  • ReadValues/WriteValues
  • RegisterNodeIDs/UnregisterNodeIDs
  • Subscribe/ Unsubscribe
  • AddMonitorItem/RemoveMonitorItem

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
 Registrierung notwendig  Documentation (1,1 MB)
 Registrierung notwendig  Visual Studio Project and ExcelExample (3,1 MB)
SHA-256 Checksum: 2DD6D1AC8803B0B132EC911BC82F8D128BFDE271E0DE65C65CDF058EB522D72E

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


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.