The serializer uses the same tag language as the popular spreadsheet program Gnumeric. (The decision was based on the freely availalbe information and the simplicity of the format -- Office's XML tag languages are a royal mess, OpenOffice.org uses multiple files to represent a single sheet which is too painful IMHO, gnumeric was ripe and mature as far as XML went). You can find gnumeric at www.gnome.org/gnumeric. The XML schema was donated to Gnumeric by HSSF Serializer designer Marc Johnson and is maintained as part of Gnumeric.
As a general strategy I recommend just creating a spreadsheet styled as you like it and then create an XSL out of it. (Okay thats the other reason we picked gnumeric :-) laziness). -Andy On Thu, 2002-03-14 at 08:12, Ducret, Gilles (CH) wrote: > Just one more question: where can I find the XSL syntax I have to use to > describe my Excel document? > -----Original Message----- > From: Iouri Michtchenko [mailto:[EMAIL PROTECTED]] > Sent: jeudi, 14. mars 2002 13:36 > To: [EMAIL PROTECTED] > Subject: RE: XML/XSL without using Cocoon > > > Hi, > I am using POI with Oracle XSQL Servlet: > > import org.w3c.dom.Document; > import oracle.xml.parser.v2.XMLDocument; > import java.io.PrintWriter; > import oracle.xml.xsql.*; > import net.sourceforge.poi.serialization.HSSFSerializer; > > public class XSQLExcelSerializer implements XSQLDocumentSerializer > { > public void serialize(Document doc, XSQLPageRequest env) throws Throwable > { > try > { > HSSFSerializer hssf = new HSSFSerializer(); > String mimeType = hssf.getMimeType(); > env.setContentType("application/" + mimeType); > hssf.setOutputStream(env.getOutputStream()); > ((XMLDocument) doc).reportSAXEvents(hssf); > } > catch(Exception e) > { > e.printStackTrace(); > throw e; > } > } > } > > > ********************************************************************** > This E-mail and any files transmitted with it are confidential > and intended for the exclusive use of the addressee(s) only. > You should not disclose its contents to any other person. > If you are not the intended recipient please notify the sender > immediately. > ********************************************************************** -- http://www.superlinksoftware.com http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound Document format to java http://developer.java.sun.com/developer/bugParade/bugs/4487555.html - fix java generics! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh
