Exelica spreadsheet reporting

Exelica Spreadsheet Reporting V3.0 Overview

Exelica enables your clients to output MS Excel compatible reports with active formulas from their Java applications. In order to keep Exelica relevant to your clients' needs, we continually plan and develop exciting new features for future versions of Exelica. Current features of Exelica are detailed here in this overview.

Exelica is most easily understood when it is broken down into its three main component parts: the report designer, the processing engine, and the report viewer.

The Exelica designer provides programmers with the tools and guidance to create report templates in a MS Excel-compatible spreadsheet environment. The Exelica designer assists the programmer to identify and link the cells and formulas to data sources such as Java classes or databases. The report templates are engaged by the Exelica processing engine. The engine can either be embedded in a standalone application or located on a server. The Exelica engine will process the report template with the most current data and output reports to the Exelica viewer. Reports can be viewed in either PDF or MS Excel format.
Exelica Spreadsheet Reporting illustrated in its three main components: the report designer, the processing engine, and the report viewer

Features of the Exelica Report Designer
  • Table Area: The table area provides the ability to model an expanding table such as list of contacts, revenues or expenses over a year. It is similar to the detail section of most page layout reports.
  • Repeating Table Area: Repeating table area is a unique feature utilized to model tables that expand both across and down. For example, the monthly expense projections of a company over 2 years with annual sub totals. Other reporting applications may use Cross Tab or Pivot Tables to mimic this capability.
  • Grouping: Grouping in Exelica is a spreadsheet version of grouping features commonly used in page layout reporting. For example grouping may be done by type, by company, by sales per region, or by sales rep.
  • Active MS Excel Formulas: Exelica reports can contain MS Excel compatible formulas such as ‘sum’ and ‘if’. The MS Excel formulas will be output to the final MS Excel report preserving the functionality of a spreadsheet model.
  • Area Header: The area header works the same as “Print Title” in MS Excel. Exelica has a header that changes when the table ends and start with a different header for the second table. The headers are repeated on the subsequent pages only if the table expands to the next page. This enables multiple table headers printing on pages when the table extend across or down to another page. In page layout reports, page headers of sub-reports are used to mimic this feature.
  • Additional Features: Exelica's report designer includes many other features to aid programmer such as conditional row/column delete, dynamic formatting of cells, data-sources and sample data, and many of MS Excel compatible features.

Processing Engine Versatility
  • Server Side
    Exelica's Report Engine can run on a server. The report engine can be integrated to provide reference server-side implementation into any J2EE application server, or any Java servlet container.
  • Embedded in Standalone Java Programs
    Embedding Exelica into a standalone Java application is a straight-forward approach that requires the programmer to create a single Java class that will interact with Exelica. The embedded Exelica runtime allows report previews in page mode and spreadsheet mode. The integration Application Programming Interface (API) is well-documented.

Report Viewer File Formats
Exelica reports are output in four possible views/file types:
  1. Print Preview in the Exelica Viewer.
  2. Spreadsheet view in the Exelica Viewer. Can copy the cell values.
  3. PDF Acrobat format to be open by the Acrobat Reader
  4. MS Excel format to be opened by MS Excel.