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

[David Merrilees <da...@fenc.org.uk>]

I use Office 2003 XML from O'Reilly for SpreadsheetML. There's also
plenty of reference material on it and a schema available from
Microsoft.




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>





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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org