Easy Excel Reports for OPC Data
Version 3.7.0.8691
OPC Excel Reporter is an OPC Client for Excel that transforms Excel into a
reporting tool for your process and equipment data. Connect to any real-time
(OPC DA) or historical (OPC-HDA) data source. Sample reports make getting
started a snap. Easily create production, quality and performance reports. OPC
Excel Reporter is an out-of-the-box solution that is easy to set up, configure
and manage - get up and running in less than 5 minutes.
OPC Excel Reporter logs PLC Data whether from Allen Bradley, Siemens, GE Fanuc, Mitsubishi,
Modicon and Omron PLCs in to Excel quickly. With its simple and easy to use interface, Excel sheets
and cells can be linked to specific I/O point(s) in the PLC in a matter of seconds – making it easy
to log data and transform them into reports.
Advanced Features
- Office 2003, 2007,2010, 2013, 2016 and 2019 compatible
- Easily compare data from different time ranges
- Create scheduled or adhoc reports easily
- Connect to multiple data sources including popular PLC’s, DCS’s and Historians
- Compatible with VBA
- Security signed for high-security environments
- Filter results from the data source
- Supports millisecond queries
- Pull processed and raw data
- Array Value Support
Familiar and Convenient
Unlike other reporting solutions, OPC Excel Reporter uses the power of Excel.
Excel is the most widely used tool for data analysis and reporting. With OPC
Excel Reporter, now you can retrieve process and equipment data easily from
anywhere in your organization and take advantage of Excel's advanced
calculations and data manipulation features.
 MatrikonOPC's
Industrial Strength Guarantee
|
| Here at MatrikonOPC, we stand behind our products.
Included in your purchase price is all software updates,
24/7 access to MatrikonOPC’s world-class support from our
highly trained professionals around the globe and more for
1 year.We'll support you or your money back!
|
|
Access All Your Data
OPC provides the most popular access method for industrial automation data.
With both OPC DA and OPC HDA access, OPC Excel Reporter lets you pull data from
multiple systems in Excel using OPC, without relying on custom tools for each
device. Compare data from separate lines, units, or plants, all in a single
tool.
Real-time Dashboards
OPC Excel Reporter’s (OPC-DA) real-time data access turns Microsoft Excel into
a simple dashboard for keeping track of your system, from the comfort of your
office. Calculate KPIs, color code, trend, and analyze them all in real-time.
Scheduled Reports
Got your report just right? Our report scheduler can wipe out your 6am Monday
reporting blues. Schedule your KPI report to go out every Monday, grab the
day's production numbers, or tally up your monthly material balance.
OPC vs. DDE
Replace your Excel-DDE solution with OPC Excel Reporter. Why use an OPC-Excel
solution instead of DDE?
-
Supportability. Microsoft is gradually phasing DDE out – and there are more OPC
data sources
-
Interoperability. OPC has compliance and interoperability testing for clients
and servers
-
Speed and Through-put. OPC has better performance for real-time applications
than DDE
-
Scalability. With Excel as an OPC client, you can connect to multiple data
sources more easily
-
Robustness. Unlike DDE, OPC has built in error handling in the specification
-
Security - OPC Security is more flexible and works better over networked
configurations
Our Clients
|
|
Our Partners
|
| |
 |
|
 |
| |
Datasheets
Manuals
Case Studies
Whitepapers
Sample Reports
Videos
|
| |
Supported OPC Specifications
-
OPC DA (OPC Data Access) 1.0a
-
OPC DA (OPC Data Access) 2.0a
-
OPC DA (OPC Data Access) 2.05a
-
OPC DA (OPC Data Access) 3.0a
-
OPC HDA (OPC Historical Data Access) 1.0
-
OPC HDA (OPC Historical Data Access) 1.1
-
OPC HDA (OPC Historical Data Access) 1.2
Microsoft Excel Supported:
- Microsoft Windows 7 (32-bit or 64-bit)
- Microsoft Windows 10
- Microsoft Windows 11
- Microsoft Windows Server 2008 R2 SP1
- Microsoft Windows Server 2012 R2
- Microsoft Windows Server 2016
- Microsoft Windows Server 2019
- Microsoft Office Excel:
- Excel 2010 (32-bit)
- Excel 2013 (32-bit)
- Excel 2016 (32-bit)
- Excel 2019 (32-bit)
- Office 365
|
|