OPC to Excel (Cogent DataHub)

The Cogent DataHub^® lets you drag and drop data into your spreadsheet to instantly see live updates. Save the spreadsheet and the next time you open it, all the data is refreshed and you have reports with up to the moment accuracy. The Cogent DataHub also makes it easy for your to pull data back out of Excel and use it as input to your control systems, or as analysis results you can share with a colleague.

• Drag and drop point values directly into your spreadsheets.
• You can display the point value, timestamp, quality and point type.
• Display OPC array points as Excel ranges and transmit Excel ranges as array points.
• The Cogent DataHub acts as both a DDE client and server, so you can both write data to Excel and also read data from Excel.

There are two ways to get data out of Excel and into the DataHub:

1. Configure the DataHub to act as a DDE Client and have Excel automatically send the data whenever it changes.
2. Write a simple macro in Excel to send data to the DataHub under conditions you get to define more closely.

Vendor: Cogent Real-Time Systems

view complete profile

Founded in 1995, Cogent Real-Time Systems is the leader in real-time cross-platform data integration between Windows, Linux and QNX. Cogent serves industrial markets worldwide, primarily in North America, Europe, and Asia. Our clients are end-users and systems integrators who value high reliability and ease of use when connecting data-centric software in mission-critical systems.