How to generate XLS from Cocoon

XLS is the binary format used by Microsoft Excel spreadsheets. XLS can be produced by Cocoon, using a component called POI, itself an Apache project. For an example on how integrate this with Cocoon, see XLSSerializer.

A very good outline on why and how to use POI is available at xml.com, under Excel Reports with Apache Cocoon and POI, showing how to use XSL to generate the Gnumeric file. Note it does not use the XLSSerializer.

Bear in mind that the Cocoon will not "automagically" generate XLS - you still need to write an intermediate stylesheet to convert XML to the Gnumeric File Format used by POI.

Reader comments

ExcelGeneration (last edited 2009-09-20 23:41:36 by localhost)