DataHub Add-in for Microsoft Excel
Analyze and report data from industrial systems
Access your process data from Microsoft Excel ™. Run real-time analysis on production numbers, calculate statistics, create your own charts, and more. Leverage the power of the world’s most popular spreadsheet anywhere in your operation.
You can
- Turn Microsoft Excel into a user interface for sharing data securely, at millisecond refresh rates.
- Connect over LAN, WAN or Internet.
- Instantly update Excel cells as the underlying source data changes anywhere on your network.
- Share bi-directional data among multiple Excel users.
Unique Advantages
- Faster and more reliable than DDE or RTD.
- Eliminates spreadsheet silos: each Excel spreadsheet can be a data publisher.
- Keeps every team member up to date with the same data.
- Simple and fast deployment for multiple users.
- Aggregate data from multiple sources, and multiple Excel users.
- Pick and choose only the data you need or wish to share from each workbook.
- Share data, not workbooks, so every user can have a unique view.
Using DataHub Add-in
Demo Workbook
The best way to start using the DataHub Add-in for Excel is with the demo workbook, DataHubExcelDemo.xlsx, included in the DataHub Add-in archive. This workbook gives an easy, a hands-on demonstration using live data from the Cogent DataHub service for Azure.
Connect to a local DataHub instance
Once you are familiar with Vine Add-in, you may want to connect it to a local DataHub instance.
- Start a DataHub instance. (Here’s how)
- Run DataPid if you want sample data. (Here’s how)
- Configure a connection from Excel to the DataHub. instance. (Here’s how)
Share data between workbooks
Connect another workbook to the DataHub, and you can share data between workbooks.
Connect Excel to other DataHub clients
Once connected to a DataHub instance, the Add-in will send data updates for every data point configured with a Direction of “Write”, “Write before Read”, or “Read before Write”. These updates are then published in real time to every DataHub client that has subscribed to those points.
In a similar way, the Add-in can simply receive data from other DataHub clients by configuring data points with a Direction of “Read.”
Excel and Excel logo are trademarks of Microsoft Corporation.
