EMI Softech

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

No Historian, No Problem!

Are you manually reporting on data from your PLC?
Eliminate errors caused by manual entry and automate it with Excel Reporter

Excel reporter is a standard Excel plug-in that works directly in Excel 2010/2013/2016/2019/MS365

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

Excel Reporter transforms Microsoft Excel into a reporting tool for your process and equipment data. Easily create production, quality, and performance reports. Connect to any real-time or historical data source via OPC

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

Supported OPC Specs

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

Familiar & 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

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 Excel Reporter