Home
Add-ons
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.
Installation of WinCC OA Excel Report
Different WinCC OA versions and COM Manager

Add-ons
- API
- Communication Center
- Disaster Recovery System
- Standard Object Library
  The WinCC OA Standard Object Library (in short: Stdlib) is a base framework that facilitates the creation and use of WinCC OA Libraries. The Stdlib provides templates for creating WinCC OA Libraries and offers a vast range of functions that make the use of a WinCC OA Library in a WinCC OA project easier.
- BACnet Application
- SmartSCADA
  The WinCC OA feature SmartSCADA provides two packages: the Analytics package and the KPI framework.
- 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.
- Video

Different WinCC OA versions and COM Manager

If several different WinCC OA versions are installed on the same computer, the COM manager is registered for the version last installed. If the Excel report of another version than the last installed should be started, the COM manager for the right version must be registered. If, for example, the version 3.20 was installed and the Excel report of the version 3.19 should be opened, it cannot be opened.

Register the COM-Manager for the version 3.18 by opening the command line as an administrator and by executing the following command: C:\Windows\SysWOW64\regsvr32.exe "C:\Siemens\Automation\WinCC_OA\3.18\bin\windows\WCCOAcom.dll"

When WinCC OA Excel Report runs, the COM Manager (the manager starts automatically) is shown in the panel Event Manager Connections as ASCII Manager. You can open the Event Manager Connections-Panel via System Management > Diagnostics > EventMan. Connections:

Figure 1. Event Manager Connections

For more information, see chapter WinCC OA Diagnostics.