сряда, 9 юли 2008 г.

Excel export from APEX + Cocoon

Carl Backstrom has posted nice howto Print in PDF and RTF from APEX without the BI Publisher.

However from time to time you (just like me) need to export to Excel. First you try the easy way - google for "fo2xls" and other to_xls converter. Then you ask or you read other asking in one or two forums.
The things are even worst if you are not so familiar whit fo and xsl.

As I didn't found a solution for generating Excel files I had to spend some time to do it. Now the export to Excel is working, alltgough very basic functionality, and I want to help other APEX developer with little to no knowledge of XSL Transformers get it done.

So follow Carl Backstrom's howto and then replace the content of fop_post directory whit this one.
In addition to Excel you get export to XML and HTML, too.

Hope this helps.

Няма коментари: