"It's hard to overestimate the importance of the Component Object Model (COM) in the Microsoft environment. COM underlies a large majority of the new code developed for Windows® and Windows NT® operating systems, whether created by Microsoft or by others.”

Microsoft COM Technology
XLReporter is developed with Microsoft’s Automation technology, the Component Object Model (COM) that provides a framework for applications to be seamlessly integrated.

Using this technology, XLReporter completely integrates with Microsoft Excel. This allows XLReporter to harnesses the power of Excel to design, produce and deploy reports for a wide spectrum of applications.

XLReporter uses Automation to ‘push’ data into your report forms without Excel executing! Workbook duplication, worksheet manipulation, chart updates, formulae recalculation, automatic printout and much more are all performed by XLReporter as and when required, either as a foreground or background process.

The net result is a reporting system that manages all your data collection and report generation. Completed reports can be automatically sent to your local drive, remote drive, printer or web server.

Customized Solutions
You can customize your report solution by integrating XLReporter into your HMI system.

Customized solutions can be achieved by a simple pushbutton press on your HMI display or the advanced use of XLReporter's software library designed for programming languages such as Visual Basic and Visual C++.

Architecture

Architecture 
The main components of XLReporter are the Report Designer (XLRdesign), the Collector, the Scheduler and the Schedule Designer programs.
XLRdesign is provided as an Excel add-in. All the functionality provided by XLRdesign is performed from within the Excel application environment.

The Collector program is central to the processing of your reports. It will collect data, create, copy and update workbooks, worksheets and, cell ranges; it will print or convert the report to HTML.

The Scheduler is the component that deploys the schedule created in the Schedule Designer. Each second the Scheduler checks the time based schedule for commands that need to be processed. In addition, it checks the configured events for status changes. If a time or event based command becomes active, the Scheduler will send this command to the Collector for processing.

The Schedule Designer helps you create, configure, and modify a schedule of commands that control the makeup of your report. The commands can be scheduled as Time Based or Event Based, or even as a combination of the two.