- Publish date: 01/29/2018
- Product release date: 01/29/2018
- Product Webpage
Excel Connector
The Excel Connector allows you to set up a communication link between Excel and any OPC server. It is possible to subscribe to and view real-time data, and also write the data back. No programming, macros or add-ins are necessary. With just drag-and-drop or copy-and-paste, you can create Microsoft Excel sheets with live, animated OPC data.
Features
The Excel Connector supports connections to OPC servers with following specifications:
* OPC Data Access
* OPC XML-DA
* OPC Unified Architecture (data access)
The Excel Option is a product from the QuickOPC family, while technically it is contained in the same installation package. You can also easily combine the Excel Option easiness of development with all other options and features provided by QuickOPC, such as to add VBA code to handle more complicated tasks.
For more information: Excel Connector User’s Guide (online)
Getting Started
It’s easy to get started. Essentially, you just double-click the desired OPC data in the Connectivity Explorer application, and then drag the changing grid cell to your Excel spreadsheet.
For step-by-step instructions, see Getting Started under Excel in the User’s Guide.
Product details
Category: SDK | Subcategory: Commercial SDK |
Supported Profiles and Facets
Application Profiles:
UACore 1.04
- Minimum UA Client Profile
- Standard UA Client 2017 Profile
Security Policies:
UACore 1.04
- SecurityPolicy - Aes256-Sha256-RsaPss
- SecurityPolicy - PubSub-Aes256-CTR
- SecurityPolicy [A] - Aes128-Sha256-RsaOaep
- SecurityPolicy [A] - PubSub-Aes128-CTR
- SecurityPolicy [B] – Basic256Sha256
- SecurityPolicy – Basic128Rsa15
- SecurityPolicy – Basic256
- SecurityPolicy – None
User Tokens:
UACore 1.04
- User Token – Anonymous Client Facet
- User Token – Issued Token Client Facet
- User Token – Issued Token Windows Client Facet
- User Token – User Name Password Client Facet
- User Token – X509 Certificate Client Facet