Working with Microsoft Excel

Connect OPC server to Excel - production reports

A Canadian company is using the OPC DataHub to analyze OPC production data in Excel to produce end-of-shift reports and other technical reports. When the shift operators open the Excel application it automatically connects to the OPC DataHub and updates with the latest production values. Reports are quicker to produce and always contain accurate, up-to-date information.

Real-time data from .NET program to Excel over a network

A company had a custom .NET application that was generating real-time data they wanted to analyze using Excel. The problem was the two programs were running on different network computers. The company used the DataHub API to connect from the .NET application to a DataHub on the server computer and networked the data to a DataHub on the client computer. From there a simple drag and drop made the data available in Excel.

Displaying live data in mobile devices

A Chicago based trading company is using the DataHub to deliver real-time quote information from their back-office analysis computers to their floor traders on the stock exchange. The traders view the data in an Excel application running on tablet computers they are carrying. The data rates and reliable connection allow the traders to react immediately to changes in the market.

Combining OPC Tunnelling, ODBC and Excel in one application

A European plastics manufacturer is using the OPC DataHub to access data from a group of OPC servers. Connecting an Excel spreadsheet to the OPC DataHub gives engineers a way to view and interact with the OPC server from a powerful and familiar tool. Connecting SQL Server to the OPC DataHub gives the planning and accounting staff access to up-to-the second figures and records. In order to get the OPC data where it's needed, the company uses the OPC DataHub to tunnel the data across a company network between different locations.