Add Office reporting feature to your APEX application
Why use APEX.report?
APEX.report allows you to easily generate Excel files based on XLSX template files and data returned by SQL query.
This unique solution on the market gives you the possibility to edit template files using an Excel application (e.g. to apply formatting and computations) and provide a query that fills this template during runtime XLSX generation. Query can have bind variables (parameters) that allow you to reference APEX session variables.
How it works?
Create a template in the MS Excel
No special tool or XML knowledge is needed to prepare templates. Anyone who knows Excel is able to generate XLSX templates.
Prepare SQL statement
just enter SQL statement that fills your XLSX template and you are ready to go.
Upload template to the APEX application or use predefined one
Template has been filled with data from the data source and as a result we get a file in .xlsx format
How to install it?
Just load plugin file to your application from Application Builder. No SYS, Instance admin nor shell access is needed!
Compile PL/SQL package
You are ready to use!
Main functions/ features:
you can easily export data to .xlsx file
SQL query or function returning SQL as a data source
data export based on dynamic SQL
dynamically created set of result columns
you can pass parameters to SQL query
you can present data using the chart in your template
you can easily and flexibly create and use of templates using Microsoft Office Excel
support two results set in the same xlsx
you can hide any sheets in template (for example hide sheets with source data or not applicable sheets in report)
further customization using page item substitution
Sample application using APEX.report:
Report and dynamic chart:
Charts can be dynamically adjusted and resized by plugin to match number of columns.