plc.myforum.ro

maersk · Member 3 Joined: 17 Aug 2014 Posts: 891

OPC UA Excel-Client for WinCC V7.4 SP1
https://support.industry.siemens.com/cs/document/109752976/
This application example describes the communication using the OPC UA server of a WinCC V7.4 SP1 Update 2 by means of Exel Client. The Connectivity Pack provides a OPC UA server.
The server communicates with you in Excel client that was downloaded from this entry page. For the validation of the connection an example project was added, which creates data, this project is also located in the download section.

All configurations required by Windows and WinCC are explained to guarantee quick and secure transfer of data between server and client.

OPC UA Excel-Client for WinCC V7.4 SP1 OPC UA Excel-Client for WinCC V7.4 SP1

OPC UA Excel-Client for WinCC V7.4 SP1 OPC UA Excel-Client for WinCC V7.4 SP1

Documentation and lib
https://support.industry.siemens.com/cs/attachments/109752976/109752976_OPC_UA-Excel_Client_WinCC_V7.4_en.pdf
https://support.industry.siemens.com/cs/attachments/109752976/109752976_OPC_UA_ClientLibrary_CODE_V10.zip
https://support.industry.siemens.com/cs/attachments/109752976/Heating_Tank.zip

https://ulozto.net/tam/_dsliM13T4TLx

https://anonfiles.com/hdbcO1K8o8/109752976_OPC_UA-Excel_Client_WinCC_V7.4_en_pdf
https://anonfiles.com/j5b0O1Kdo5/109752976_OPC_UA_ClientLibrary_CODE_V10_zip
https://anonfiles.com/55bfO3K8o0/Heating_Tank_zip

gert · Member 3 Joined: 02 Jan 2015 Posts: 645

OPC UA Client Library for Microsoft Excel
https://support.industry.siemens.com/cs/document/109748892/opc-ua-client-library-for-microsoft-excel
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 Excel-Client for WinCC V7.4 SP1 OPC UA Excel-Client for WinCC V7.4 SP1

The following functions are implemented in the object library:

gert · Member 3 Joined: 02 Jan 2015 Posts: 645

OPC UA client example for RFID devices according to "AutoID" for the .NET runtime
https://support.industry.siemens.com/cs/document/109769038/opc-ua-client-example-for-rfid-devices-according-to-autoid-for-the-net-runtime
OPC UA client example for the .NET runtime to operate, respectively diagnose the SIMATIC Ident devices via OPC UA.
OPC UA (Open Platform Communications Unified Architecture) is an M2M communication protocol specified by the OPC Foundation. The OPC specification was developed to provide an interoperable, secure and reliable communication protocol. OPC UA enables vertical and horizontal communication in the entire automation environment. Due to these characteristics, OPC UA is becoming more and more accepted as standard in the industrial environment.

The SIMATIC Ident products RF600 and RF18xC offer you an OPC UA server according to the OPC UA company specification "AutoID". This provides an additional option for direct process data exchange between the devices and many other systems that support OPC UA.
OPC UA Excel-Client for WinCC V7.4 SP1 OPC UA Excel-Client for WinCC V7.4 SP1

Documentation and downloads
https://support.industry.siemens.com/cs/attachments/109769038/109769038_OPC_UA_RFID-Client_DOC_V1_0_en.pdf
https://support.industry.siemens.com/cs/attachments/109769038/109769038_OPC_UA_RFID-Client_CODE_V1_0.zip
https://www.mediafire.com/file/l2bwtrlxphyx8g6/109769038_OPC_UA_RFID-Client_CODE_V1_0.zip/file