I'm trying to select the text Puffball, but I keep getting this error message:
javax.xml.transform.TransformerException: A location step was expected following the '/' or '//' token. Unable to get transformer handler for file:///C:/cocoon/build/webapp/eta/style/main.xsl I don't understand the error message and I couldn't find any help browsing through the forum. Here is the xsl document: <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";> <xsl:template match="/"> <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";> <gmr:SheetNameIndex> <gmr:SheetName>Sheet1</gmr:SheetName> </gmr:SheetNameIndex> <gmr:Sheets> <gmr:Sheet> <gmr:Name>Sheet1</gmr:Name> <gmr:MaxCol>-1</gmr:MaxCol> <gmr:MaxRow>-1</gmr:MaxRow> <gmr:Cells> <gmr:Cell Col="1" Row="1" ValueType="60"> <xsl:value-of select="/Workbook/Sheets/Sheet/Cells/Cell/rowset/row/test_data/[1]" /> </gmr:Cell> </gmr:Cells> </gmr:Sheet> </gmr:Sheets> </gmr:Workbook> The xml document that is supposed to be processed is in my last post. Is there something wrong with the syntax? I'm thinking there is something wrong with the xsl: and gmr: groupings, but after trying various manipulations to the tags I still haven't gotten the application to work. Any help or insight is appreciated, thanks. Hi Matthew, Good that you found out how to "debug" your pipeline. You'll need an extra XSL transformation for that. Be aware of the amespace prefix of the SQL elements. Regards, Jasha -----Oorspronkelijk bericht----- Van: Matthew Monkan [mailto:[EMAIL PROTECTED] Verzonden: ma 2-6-2008 22:04 Aan: [email protected] Onderwerp: RE: Database to Excel Spreadsheet I'm so close! I switched to the XML serializer to see what XML was going into the HSSFserializer. (My produced excel document would crash.) And here is what returns: <Workbook> <SheetNameIndex> <SheetName>Sheet1</SheetName> </SheetNameIndex> <Sheets> <Sheet> <Name>Sheet1</Name> <MaxCol>-1</MaxCol> <MaxRow>-1</MaxRow> <Cells> <Cell Col="1" Row="1" ValueType="60"> <rowset nrofrows="1"> <row> <test_data>Puffball</test_data> </row> </rowset> </Cell> </Cells> </Sheet> </Sheets> </Workbook> Obviously the problem is the <rowset> <row> <test_data>Puffball</test_data> </row> </rowset> which cannot be read by the HSSF serializer. I thought that the SQL transformer would just return the text Puffball which would open fine. Is this easy to fix? Or do I need to transform this XML again? -Matt -- View this message in context: http://www.nabble.com/Database-to-Excel-Spreadsheet-tp17562564p17625045.html Sent from the Cocoon - Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
