OPC to Excel

The OPC DataHub makes it easy to get OPC data into Microsoft Excel. No special plug-ins are required. Simply drag and drop data into your spreadsheet. Also works with any other DDE enabled Windows application.

How do you get data from the DataHub into Excel?

• Drag and drop point names directly from the DataHub into your Excel application (see animation below).
• f you prefer, you can also use a simple Excel macro to read data from the DataHub in a more controlled manner.

How do you get data from Excel into the DataHub?

• Configure the DataHub to act as a DDE Client and have Excel automatically send the data whenever it changes. (See the OPC DataHub manual for more details).
• Write a simple macro in Excel to send data to the DataHub under conditions you get to define more closely.