Excel Report

An easy-to-use and powerful solution

A simple, easy-to-use and powerful java-based reporting solution that leverage MS Excel advanced formatting capabilities. Solution for reporting generation, automation and distribution.

Reporting tools are often complex and require long learning curve and high maintenance cost. It is necessary to spend a lot of time to program and / or to configure the application with all the required formatting, formulas and other specific parameters. It is also necessary to develop interfaces to retrieve data from source systems and to populate the workbook. This part can reveal difficult to analyze, to implement and to maintain.

Key features

Leverage MS Excel complex formatting capabilities
Pixel-perfect reporting (use existing templates, corporate layouts and formats)
Compatible with all MS Excel versions
Advanced reporting features (total, sub-total, tree format – collapsible nodes, merge, group…)
Support complex formatting (conditional, pivot tables, charts, auto-filtering…) and MS Excel Macros

GUI interface for report edition
Fast implementation, no deployment on end-user desktop
Minimal learning curve
Easy maintenance

Support all common DB (Oracle, SyBase, MS SQL Server, MySQL, PostgreSQL, Access…)
Support CSV files via in-memory DB

Schedule and automate report execution and distribution (via script)
Execution by batch
Advanced functions (CSV loader, .zip with password, send via e-mail, ftp, http)

Developed 100% in Java
Strong architecture, Multi-OS
Generation of pure Excel files (no macro, no plugin required on client side, no connection to source)