OPC UA Client Library for Microsoft Excel
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.
The following functions are implemented in the object library:
- Subscribe/ Unsubscribe
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)
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?
- You have a technical question / problem: Ask the Technical Support
- You want to discuss in our forum and exchange experiences with other users
- You want to create CAx data for one or more products
- You would like to send us feedback on this Entry