Easy to Use
OPCEx Excel Add-In allows you to connect your OLE
for Process Control(OPC)
-compliant systems and
insert OPC server data into an Excel workbook via graphical browsing for OPC
items. OPCEx works within Excel so users don’t need to learn a new interface.
This familiarity allows all plant personnel to read OPC data from devices with
point-and-click ease.
|
Read and Write OPC Server Data
OPCEx provides one-click access to read and write OPC server data.
|
Multi-OPC Server Support
OPCEx can collect data from different OPC servers at the same time.
|
OPC Compatibility
OPCEx supports OPC Data Access Standards 1.0 and 2.0. It operates with any
local or remote OPC server.
|
Update to the Next Cell
OPCEx provides an easy way to create charts containing OPC server data by
inserting the changed values into the next cell.
|
Configuration Management and Recipe Transfers
Data can be put manually into Excel cells or read from the OPC server and saved
in an Excel worksheet, then written back to the device via the OPC server when
the device needs to be reconfigured.
|
Array Data Type Support
OPCEx supports OPC array data type. The maximum number of array elements is
limited by the number of Excel sheet cells. Array type items can be read from
an OPC server and written to an OPC server.
|
Trigger-Based Updates
OPC item values can be set to update whenever the trigger condition is
satisfied. This feature allows data to be recorded only when trigger
conditions, such as alarms, are met.
|
Database Connection
Collect data from relational databases
Update database with real-time values from the OPC server
Schedule database updates at any desired interval (e.g., hourly, daily, weekly,
etc.)
|
Alarm Monitoring
Monitor and analyze real-time OPC values and create alarms and reports based on
the alarms
Send an automated page or email with alarm information
|
Schedule Various Tasks
Generate reports automatically according to schedule with Excel running in the
background
Read real-time data and generate reports daily, weekly, monthly or at any other
designated interval
Send reports automatically via email
Publish reports (Excel sheets) automatically as web pages
Print reports (Excel sheets) automatically
Run macros automatically
|
Script & VBA Macro Support
OPCEx exposes its macro function library to the Excel VBA environment. A user
can develop his own macro to implement OPCEx functionality in his program.
|