Easy Excel Reports for OPC Data
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.
- Office 2003, 2007,2010, 2013, and 2016 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.
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
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.
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
Interoperability. OPC has compliance and interoperability testing for clients
Speed and Through-put. OPC has better performance for real-time applications
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
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) or
- Microsoft Windows 10 or
- Microsoft Windows Server 2008 R2 SP1 or
- Microsoft Windows Server 2012 R2 or
- Microsoft Windows Server 2016
- Microsoft Office Excel:
- Excel 2010 (32-bit), or
- Excel 2013 (32-bit), or
- Excel 2016 (32-bit)