OPC client|Classic OPC: DA, A&E, HDA, XML-DA, etc.|Forum|OPC Foundation

We (OPC Labs, http://www.opclabs.com) will be releasing a product (a new version of our QuickOPC toolkit) that can do what you are asking for. With the Excel Option for QuickOPC, you can have cells in Excel that automatically with data coming from OPC Data Access or OPC Unified Architecture servers, without any programming. You simply drag (or copy & paste) the dynamic data from the Connectivity Explorer tool to Excel.

You can have a look at preliminary documentation here:

• http://opclabs.doc-that.com/fi.....ption.html
• http://opclabs.doc-that.com/fi.....Excel.html

Let me know should you be interested in knowing more, or trying out an Alpha version.

To avoid possible confusion, this is a commercial product from an independent vendor, and not something coming from OPC Foundation or endorsed by it.