Excel Connector

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