RE: Gnumeric xml (Excel) - Email has different SMTP TO: and MIME TO: fields in the email addresses

[robby . pelssers]

But if i want to use the HSSF serializer, i have to know the gnumeric
syntaxis to be able to write a stylesheet (eg. see below)
I don't find good tutorials, a schema or DTD of what all elements and
attributes do...



<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                              xmlns:sql="http://apache.org/cocoon/SQL/2.0";
                             xmlns:gmr="http://www.gnome.org/gnumeric/v7"; >

  <xsl:template match="html">   
    <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";> 
      <gmr:Sheets>
        <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
HideColHeader="false" HideRowHeader="false">
          <gmr:Name>Sheet 1</gmr:Name>
          <gmr:MaxCol>2</gmr:MaxCol>
 
          <gmr:Styles>
            <gmr:StyleRegion startRow="3" endRow="3" startCol="0"
endCol="2">
              <gmr:Style HAlign="8" VAlign="4" WrapText="1" Shade="1"
Hidden="0" Fore="FFFF:FFFF:FFFF" Back="FFFF:0:0" PatternColor="0:0:0"
Format="General">
                <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">Helvetica</gmr:Font>
              </gmr:Style>
            </gmr:StyleRegion>
            <gmr:StyleRegion startRow="4" endRow="4" startCol="0"
endCol="3">
              <gmr:Style HAlign="8" VAlign="4" WrapText="1" Orient="1"
Shade="0" Indent="0" Locked="1"
                     Hidden="0" Fore="FFFF:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="General">
                <gmr:Font Unit="10" Bold="1" Italic="0" Underline="1"
StrikeThrough="0">Helvetica</gmr:Font>
              </gmr:Style>
            </gmr:StyleRegion>
          </gmr:Styles>

          <gmr:Cols DefaultSizePts="200"/>
          <gmr:Rows DefaultSizePts="50"/>      

          <gmr:Cells>
            <xsl:apply-templates/>
          </gmr:Cells>          
        </gmr:Sheet>
      </gmr:Sheets>
    </gmr:Workbook> 
  </xsl:template> 
</xsl:stylesheet>



-----Original Message-----
From: David Merrilees [mailto:[EMAIL PROTECTED]
Sent: 01 September, 2004 16:23
To: [EMAIL PROTECTED]
Subject: RE: Gnumeric xml (Excel) - Email has different SMTP TO: and
MIME TO: fields in the email addresses


You can create excel using the HSSF serializer or you can use using
Microsoft's SpreadsheetML and serialize your output as xml and include a
processing instruction which will force the file in excel.

David Merrilees

>Hi all,

>i'm trying to generate excel-files with cocoon... I have written basic
stylesheet that transforms xml-file to gnumeric xml.  But i'm looking
for tutorial, DTD, or schema to know which elements and attributes there
are.

>Anyone worked with this before?

>Regards,
>Robby




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]