[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    RE: XML/XSL without using Cocoon
From:       "Andrew C. Oliver" <acoliver () apache ! org>
Date:       2002-03-14 13:43:41
[Download RAW message or body]

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:Iouri.Michtchenko@cern.ch]
> Sent: jeudi, 14. mars 2002 13:36
> To: poi-user@jakarta.apache.org
> 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


[prev in list] [next in list] [prev in thread] [next in thread]