[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] process xslt and xml spreadsheet via web browser


Subject: [xsl] process xslt and xml spreadsheet via web browser
From: "rl@xxxxxxxxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 12 Sep 2014 11:53:00 -0000

Subscribers,

For those unaware, Gnumeric is an Xml-based spreadsheet (see below, edited for brevity).

The objective is to use a web browser to transform the xml spreadsheet file into text output (\t=keyboard tab), i.e.:

text test1 \t other textx \t 100
text test2 \t other texty \t 200
text test2 \t other texty \t 700
text test2 \t other texty \t 300
text test2 \t other texty \t 250
text test3 \t other textz \t 400

An Xslt file was created:

<?xml version="1.0"?>
<xsl:stylesheet
	version="2.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns='http://www.w3.org/1999/xhtml'>
	<xsl:output
		method="text"
		encoding="utf-8"
		indent="no"
		omit-xml-declaration="yes"
		media-type="text/plain"
		standalone="yes"
		/>
	<xsl:template match='Cells'>
		<xsl:apply-templates select='Cell'/>
	</xsl:template>
</xsl:stylesheet>

The Jedit text editor was used with the plugin XLST processor (uses Xalan Java), which produces the text file (below). Why does the text file contain text from nodes outside the nodes 'Cells' and 'Cell'?




4 WorkbookView::show_horizontal_scrollbar TRUE


4 WorkbookView::show_vertical_scrollbar TRUE


4 WorkbookView::show_notebook_tabs TRUE


4 WorkbookView::do_auto_completion TRUE


4 WorkbookView::is_protected FALSE




2014-09-12T09:56:44Z 2014-09-12T09:53:41Z




Sheet1 Sheet2 Sheet3




Sheet1 2 6 1


Print_Area #REF! A1


Sheet_Title "Sheet1" A1




















d_then_r portrait


iso_a4





Sans














        columnnamea
        columnnameb
        columnnamec
        text test1
        other textx
        100
        text test2
        other texty
        200
        text test2
        other texty
        700
        text test2
        other texty
        300
        text test2
        other texty
        250
        text test3
        other textz
        400





      Sheet2
      -1
      -1
      1


Print_Area #REF! A1


Sheet_Title "Sheet2" A1




















d_then_r portrait


iso_a4





Sans














      Sheet3
      -1
      -1
      1


Print_Area #REF! A1


Sheet_Title "Sheet3" A1




















d_then_r portrait


iso_a4





Sans
















Gnumeric Xml file (named test.gnumeric in the Xhtml further below):

<?xml version="1.0" encoding="UTF-8"?>
<!--attempted to add a stylesheet but unable to view transformed document in web browser
<?xml-stylesheet type="text/xsl" href="testgnumeric.xslt"?>
-->
<gnm:Workbook xmlns:gnm="http://www.gnumeric.org/v10.dtd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.gnumeric.org/v9.xsd">
<gnm:Version Epoch="1" Major="10" Minor="2" Full="1.10.2"/>
<gnm:Attributes>
...
</gnm:Attributes>
<office:document-meta
...
</office:document-meta>
<gnm:Calculation ManualRecalc="0" EnableIteration="1" MaxIterations="100" IterationTolerance="0.001" FloatRadix="2" FloatDigits="53"/>
<gnm:SheetNameIndex>
...
</gnm:SheetNameIndex>
<gnm:Geometry Width="1080" Height="586"/>
<gnm:Sheets>
<gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
<gnm:Name>Sheet1</gnm:Name>
<gnm:MaxCol>2</gnm:MaxCol>
<gnm:MaxRow>6</gnm:MaxRow>
<gnm:Zoom>1</gnm:Zoom>
<gnm:Names>
<gnm:Name>
...
</gnm:Name>
</gnm:Names>
<gnm:PrintInformation>
...
</gnm:PrintInformation>
<gnm:Styles>
...
</gnm:Styles>
<gnm:Cols DefaultSizePts="48">
<gnm:ColInfo No="0" Unit="48" Count="3"/>
</gnm:Cols>
<gnm:Rows DefaultSizePts="12.75">
<gnm:RowInfo No="0" Unit="13.5" Count="7"/>
</gnm:Rows>
<gnm:Selections CursorCol="0" CursorRow="0">
<gnm:Selection startCol="0" startRow="0" endCol="0" endRow="0"/>
</gnm:Selections>
<gnm:Cells>
<gnm:Cell Row="0" Col="0" ValueType="60">columnnamea</gnm:Cell>
<gnm:Cell Row="0" Col="1" ValueType="60">columnnameb</gnm:Cell>
<gnm:Cell Row="0" Col="2" ValueType="60">columnnamec</gnm:Cell>
<gnm:Cell Row="1" Col="0" ValueType="60">text test1</gnm:Cell>
<gnm:Cell Row="1" Col="1" ValueType="60">other textx</gnm:Cell>
<gnm:Cell Row="1" Col="2" ValueType="40">100</gnm:Cell>
<gnm:Cell Row="2" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="2" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="2" Col="2" ValueType="40">200</gnm:Cell>
<gnm:Cell Row="3" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="3" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="3" Col="2" ValueType="40">700</gnm:Cell>
<gnm:Cell Row="4" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="4" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="4" Col="2" ValueType="40">300</gnm:Cell>
<gnm:Cell Row="5" Col="0" ValueType="60">text test2</gnm:Cell>
<gnm:Cell Row="5" Col="1" ValueType="60">other texty</gnm:Cell>
<gnm:Cell Row="5" Col="2" ValueType="40">250</gnm:Cell>
<gnm:Cell Row="6" Col="0" ValueType="60">text test3</gnm:Cell>
<gnm:Cell Row="6" Col="1" ValueType="60">other textz</gnm:Cell>
<gnm:Cell Row="6" Col="2" ValueType="40">400</gnm:Cell>
</gnm:Cells>
<gnm:SheetLayout TopLeft="A1"/>
<gnm:Solver ProblemType="0" MaxTime="30" MaxIter="100" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0"/>
</gnm:Sheet>
</gnm:Sheets>
<gnm:UIData SelectedTab="0"/>
</gnm:Workbook>


An Xhtml file was created (below): is it possible to use a web browser to perform the transformation, via linking to both the Xslt and Xml files?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML Basic 1.1//EN" "http://www.w3.org/TR/xhtml-basic/xhtml-basic11.dtd">
<html xmlns='http://www.w3.org/1999/xhtml' lang='en' xml:lang='en'>
<head>
<title>spreadsheet transformation</title>
<link rel="stylesheet" type="application/xslt+xml" href="testgnumeric.xslt" media="screen"/>
<link rel='stylesheet' href='styles.css' type='text/css' media='screen' />
</head>
<body>
<form
action="test.gnumeric"
method='post'
name=''
>
<p>
<select
name=''
>
<option>
...
</option>
</select>
<input
type="submit"
value='send'
/>
</p>
</form>
</body>
</html>
<!--


-->


Current Thread
Keywords