DDE / Excel

Drag and drop real-time data into Excel

The Cogent DataHub uses DDE to connect to Excel, and allows 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.

DDE screen capture

DDE support

  • Cogent DataHub can make DDE Advise connections to DDE servers. DDE Advise is an asynchronous mechanism by which the server sends data to the DataHub whenever it changes.
  • By default, the Cogent DataHub will act as a DDE server itself, accepting DDE Advise connection requests from other DDE programs.
  • When you drag and drop data from the DataHub into an Excel spreadsheet, you automatically configure Excel to establish a DDE Advise connection with the DataHub.
Product Code Features
DataHub DDE Tunneller DHDTUN DDE/Excel, Tunnel/Mirror
DDE/Excel support ** ADDDDE DDE/Excel

* Includes Aggregation, Scripting, QuickTrend, and Security
** Available as an add-on feature