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).
- If 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?
There are two ways to get data out of Excel and 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.
More Information
|
