thanks for this wonderful package, I just played with idea of JAVA calling external Excel generator and then found this simple solution, usage of Excel-oriented HTML is really product of genius. :)
Are you still working on this package? I am especially interested in enhancement to support reports of type PL/SQL function returning a SQL Query, because I have lots of dynamically generated reports (based on time interval).
And one advice - it is possible to tell Excel to change page orientation to landscape by adding row "mso-page-orientation:landscape;" in @page section of header (recognized by setting it in Excel and saving document :) ).
I do not support this package anymore. Actually, it has been set up and that's it. I think
with some PL/SQL knowledge, you can do it much better. However, I didn't have time to
deal with it - too many projects and so many other things to do. As you already noticed,
you can do much more with that package. Thanks for you advice.
There is one thing you need to know. Bind variable (:PXXX_YYY) cannot be evaluated in the returned SQL. This must ve replaced by v('PXXX_YYY'). We have mostly evaluated page items and returned the actual value.
It seems that (at least in APEX 3.1) apex_application_page_rpt_cols view has NULL values in include_in_export column.
Try modifying the package (PROCEDURE print_report_header) and replace
" AND include_in_export = 'Yes' "
" AND NVL(include_in_export,'Yes') = 'Yes' "