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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- 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]
