On wednesday morning (08:00 am, really early) I have been presenting at ODTUG Kaleidoskope 2009 in Monterey / California.
The presentation was about "Generating complex Excel reports with APEX and jXLS".
There I first covered your basic choices when it comes to exporting data to Microsoft Excel.
Then I showed how to integrate the open source library jXLS into your APEX applications in order to generate complex Excel sheets using a templating approach.
In more general terms this was a showcase on how to integrate any kind of open source java library into you Oracle applications.
Since I have just loaded java classes into the database and made them available via a pl/sql wrapper, you can use them in any language accessing the Oracle database and calling the interface via pl/sql.
Thus, you can leverage this in applications using Forms, Reports, APEX, PHP, Java, ... You name it.
You can download the presentation slides here.
If anybody is interested, I will put up an example on how to integrate a java framework into your APEX application.
Are you interested?