Excel Option for QuickOPC

Excel Option for QuickOPC

Member: OPC Labs

Product website: www.opclabs.com/products/quickopc/options/excel


The Excel Option for QuickOPC 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.


The Excel Option for QuickOPC 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 Option for QuickOPC User's Guide (online)


Getting Started

It's easy to get started. Essentially, you just double-click the desired OPC data in the QuickOPC 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.