With QuickOPC, you can visualize real-time process data in Excel, and even control your process by writing into OPC items. You can use Microsoft Excel to create live reports, or pull data from cells on the worksheet and use them as input to your control systems. OPC Excel solutions like this provide high value by combining computational and presentation capabilities of Excel with real-time OPC data.
How does QuickOPC allow integration of OPC data into Excel?
If you want see it for yourself, we have an OPC Excel example that shows how to create a simple worksheet with one OPC item, and read its value upon opening the worksheet. The result looks like this:
The example connects to Simulation OPC Server, but you can quickly modify it to connect to your OPC server instead. Simply download the product and then open the project, or follow the tutorial (for OPC Data Access):
It is also possible to communicate with OPC Unified Architecture (OPC UA) servers from within Excel. The corresponding example is included with the product, and you can read about the few steps needed to achieve this in the knowledge base article below.