Get OPC data into Excel
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?
- QuickOPC provides COM objects with easy interfaces to perform all kinds of OPC tasks
- You reference the QuickOPC objects from a code written in Visual Basic for Applications (VBA) and embedded in your Excel file.
- You call methods that perform operations such as OPC reading or writing.
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):
How to read an OPC item value in Excel
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.
How to read an OPC-UA node value in Excel