Microsoft Excel

Microsoft Excel

The spreadsheet program Excel is the most widely used tool of its kind. A lot of information is administered, stored and calculated manually in tabular form. The OPC Router can access the files with the Excel plug-in, with access to all tables and cells to read and write data.

Achieve More with Combined Systems

Instead of manually transferring data from other systems to Excel, this process can be automated with the OPC Router and the Excel plug-in. Machine data acquisition is set up easily. That saves time and increases data quality. If data is read from Excel and transferred to subsystems, Excel even serves as a source for recipe- or machine-parameters.

Industry 4.0 for Excel

Excel users implement complex process knowledge in data tables and perform manifold calculations with the contained data. Integrating Excel to make it a part of an interlinked production systems network utilizes and multiplies knowledge and information – to make it both useful to and usable for the whole business enterprise.

About the OPC Router

The OPC Router offers a visual network configuration interface for successful cross-linking of your systems. A high variety of plug-ins turns the OPC Router into a powerful data hub for industrial applications.

Easy configuration, sophisticated monitoring and robustness are main distinguishing features of the OPC Router.

Combining Systems

That’s how easy it is.

Transfer Objects

The transfer object of the Excel plug-in alles access to Excel table sheets and table rows inside an Excel file.

Excel File

The respective Excel file can be dynamically determined, or its status can be predefined. In case the Excel file does not exist, an error message can be optionally generated, or an new file can be created, named and saved.

Excel Table Sheets and Rows

Any table sheets can be predefined as static approach, or dynamically determined through the respective transfer data. Reading into a table row can be approached in several ways, for instance via: Update (ie. new data overwrites older data), Insert (i.e. new data is added on top of a data row, and older data slides into rows below) and Append (i.e. new data is appended at the end of a data row).

Trigger Functions

The Excel plug-in does not have its own triggers and therefore works with the standard triggers of the OPC router.

Browsing

The Excel Plug-in addresses rows in Excel files directly by referencing table sheets, columns and rows. The configured cells are shown a data fields in a visual display.

More Plug-ins

How do Transfer Objects, Triggers and Browsing work?

The OPC Router establishes connections between systems that address core functions of the OPC Router.

Functions of the respective plug-ins may vary, due to the different nature of each connected system.

Run a free test now

Transfer Objects

Sources and Destinations

Transfer objects are the sources and destinations inside the OPC Router. They contain data fields with read and write functions. Depending on the respective interconnected system, the possible configuration scope of sources and destinations may vary.

Homegeinity on the Outside – Heterogeinity on the Inside

Inside the OPC Router configuration, the transfer object abstracts the respective system of any connected system into a simple data input and data output block. Thus, the functions can be treated in the same way although each connected system has very individual features.

Trigger Functions

Prompting Connections

Triggers determine execution time of data connections. Various triggers can be used for these connections, independent of transfer object type. Within each connection, several triggers can be used together via AND/OR-connections. Triggers can also be useful as data sources if the prompting event is combined with data reception.

Browsing

Searching and Finding Data Fields

Easy browsing also makes data field configuration easy when establishing transfer objects in order to establish the respective interface connection. The browsing mechanisms may vary, depending on the system and its available plug-in.

Reading out Structures

Many plug-ins that are available for the OPC Router offer easy search and selection tools for quick identification of respective data fields without the need for specific knowledge about inherent subsystems. The user can easily browse through the data. Data source structures may vary according to the specification of each respective plug-in.

2018-07-10T12:35:15+00:00

Testen Sie jetzt den OPC Router!

Kostenlos und unverbindlich!
close-link

Download now!

Get your free OPC Router demo!
close-link