Home
Reporting
Create state of the art project reports without limits.
WinCC OA Excel Report
WinCC OA Excel Report, is a program extension of MS Excel for integrated data evaluation and protocol generation with WinCC OA archive data. Reports can be created with the WinCC OA Excel Report. Templates are used for the reports. If a report is to be generated over a defined period of time, the system accesses the template and automatically fills it with data from the process database. Reports can also be created, printed and saved on a scheduled basis without requiring user access.
Requirements

Version Information
Release Notes, Update information, Certifications and Frequently Asked Questions.
Concepts
Your first step into modern and powerful process visualization.
Deployment
Topics you need to know before using WinCC OA.
Security
Go beyond the norm in cybersecurity.
Engineering
Powerful tools for easy or complex engineering tasks.
Data Management
Classify, structure and archive your data.
Business Logic / Control
Endless possibilities in data processing for your projects.
Data Visualization
User interfaces, Trends and Reports for every purpose and device.
Southbound Interfaces
The process connection to the actual machines/sensors.
Northbound Interfaces
Your portal to the cloud or supervising systems.
Web Connectivity / Network Interfaces
Data exchange, APIs and web technologies
User Management
All about authorization, authentication and login-customization.
Availability
How to get your system uptime to the maximum.
Reporting
Create state of the art project reports without limits.
- XML Reporting
  The Reporting feature allows you to create reports in XML format. Therefore, add the WinCC OA Reporting Manager to your project. Historical data can be queried via the Reporting manager by using the SOAP (Simple Object Access Protocol) interface. SOAP is a network protocol which allows sending data in XML format between systems.
- WinCC OA Excel Report
  WinCC OA Excel Report, is a program extension of MS Excel for integrated data evaluation and protocol generation with WinCC OA archive data. Reports can be created with the WinCC OA Excel Report. Templates are used for the reports. If a report is to be generated over a defined period of time, the system accesses the template and automatically fills it with data from the process database. Reports can also be created, printed and saved on a scheduled basis without requiring user access.
- REST Reporting API
  The REST Reporting API is integrated into the Standard web server and can be activated via the config entry [restRporting] enabled.
- Rpc Service - ManagerDiagnostic
  The ManagerDiagnostic is a remote procedure call (RPC) service available for all manager types except Data Manager. It allows you to retrieve diagnostic data using flags in C++, C#, Node.js or CTRL.
Addons
Useful tools and enhancements for special demands.
Reference Tables
Detailed and extensive content for special project adaptation.
Videos & Tutorials
Explore the capabilities of WinCC OA with our carefully selected collection of video tutorials and guides.
Documentation
Basic information about terms and functions within the documentation.
Support & Services
An experienced team of support agents, consultants and trainers are ready to facilitate active partnerships with our customers, so they can profit from our comprehensive service.
Disclaimer
A brief clarification of liability exclusions or legal notices.

Requirements

Install Excel Report. The Excel report is part of the WinCC OA installation (WinCC OA Add-ons option).
Windows Operating System
Correctly installed version of MS Excel - see chapter Software requirements.
Use of the "History DB" (WCCOAvalarch), "RDB Archiving" (WCCOArdb) or NextGen Archiver (NGA).
You will need your own license to run Excel Report.

Important:

Note that if you use statistical functions and have specified the "Always start calculation at" time on the synchronization tab of the data point function, the start time for the report has to be the same as the "Always start calculation at" time of the DP function (otherwise, the report won't get the required data).

Warning messages appear at the start of the Excel Report if any of the following conditions are not met:

Missing License: The button to start the Excel report is disabled if the license is missing.
Excel installation: Checks if Excel is installed on the system.
Excel version: Verifies that Excel has the correct bit version (32/64-bit) as required by the registered COM manager.
COM manager registration: Confirms that the COM manager is registered with the correct version.
Check availability: Determines whether these checks can be performed.

Example of a warning message:

WCCOAui (1), 2025.02.25 08:57:22.079, CTRL, WARNING, 54, Unexpected state, 
Potential version mismatch between registered COM Manager and WinCC OA, report may not run, 
"C:\Siemens\Automation\WinCC_OA\3.19\bin\WCCOAcom.dll"

This error indicates that the COM manager for 3.19 is registered instead of the 3.21 version.