[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
Re: stylesheet templates for OpenOffice spreadsheets
Subject: Re: stylesheet templates for OpenOffice spreadsheets
From: Emmanouil Batsis <Emmanouil.Batsis@xxxxxxxxxxx>
Date: Thu, 01 Sep 2005 18:56:31 +0300
|
Last time i had a similar problem i just came up with a "normalization
filter" used before the transformation. In my case it was a simple SAX
filter so it had a minor effect in performance and the benefit of low
XSLT complexity. You can of course start creating variables by adding
positions and number-columns-repeated and use that, but i preffer simple
solutions ;-)
hth,
Manos
Stan wrote:
I've been taking a look at the xml format that the latest OpenOffice
spreadsheets produce and was trying to come up with a generalized
template that would extract the value from the nth row and mth column.
In general, OpenOffice expresses a spreadsheet grid like this (removing
the cruft for illustrative purposes):
<table>
<row><col>1</col><col>2</col><col>3</col></row>
<row><col>4</col><col>5</col><col>6</col></row>
<!-- and so on -->
<table>
A template for this is fairly easy to reproduce because the mth column
of the nth row is just "table/row[n]/col[m]". The problem comes in for
spreadsheet grids that are sparsely or reduntantly filled. In this case,
presumably to save space, the format looks something like this (assuming
the first two columns of the first row are empty):
<table>
<row><col number-columns-repeated="2"/><col>3</col></row>
<row><col>4</col><col>5</col><col>6</col></row>
</table>
This makes things much more difficult since now we have to account for
the number-columns-repeated attribute. A generalized approach will now
have to add all the number-columns-repeated values to find the mth
column.
I thought that before I started working on producing this, I'd see if
anyone has tackled this before or perhaps there is some magic xpath
statement that eludes me.
StanD.
|
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
RSS 2.0 |
|
Atom 0.3 |
|
|