This content has been marked as final. Show 146 replies
It is easy - I generate html.
I made a demo package available here:
for testing. As soon as I'm done with it I will open it for modifications. The package is
generic (let us say in 95% of the cases it should work). I didn't test it with PL/SQL
reports but I doubt it will work with those. However, it should work with all normal
reports. The how - to is also attached.
Basically, you need to create three application items and one conditional page process.
After that, you may create links for exporting to excel as you do it with .csv.
Your feedback is welcome.
I noticed that this happens when you forget to:
1. pass the right report title
2. forget to pass the page parameter on which report is located or pass the wrong page
I still need some time to clean up the package so mistakes like these get handeled.
What is your name? I think it would be fair if you would sign your postings :)
i downloaded the package from your page, but i have trouble getting it to work on Oracle XE.
When i try to install the package i get the message that the body was created with a warning.
This is the output of show errors:
Fehler bei PACKAGE BODY EXPORT_EXCEL_PKG:
255/7 PL/SQL: SQL Statement ignored
257/14 PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden
Thanks for help in advance,
I am still working on this package. Probably, you have two reports on the same page
having the same title?
I corrected the package and I use now region_id instead of the title.
The package works for ApEx 2.2 and higher - it is looking for the region source and
using it to generate the report.
For XE and lower versions, there is no such view where you could get the region source
information (as far as I know) and for those purposes, I would need to create a separate
package which would require some select grants on the corresponding tables.
Eventually, if I have some spare time, I will provide that package.
Life could be easier. Couldn't it?
This error is because you are using either a lower version of ApEx or XE. In the readme
of my demo it says it works on 2.2 and higher only.
However, it was easier to get it working for XE. I provided a download link for XE here:
I did some basic testing only and it worked. You need to follow the instructions carefully
since some grants are required prior to installing anything.