[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

selecting associated headings based on sequence positi

Subject: selecting associated headings based on sequence position
From: "Rushforth, Peter" <prushfor@xxxxxxxxxxx>
Date: Wed, 30 Jul 2008 23:53:33 -0400
 selecting associated headings based on sequence positi
Hi,

My input document is spreadsheet stuff like below.  In the first Row element,
I have the names of the columns, in subsequent Row/Cell/Data elements I have
the values of the columns.  I need to output a list for each Row with the
heading followed by the value, something like this:

<b>Project name: </b>The name of a project

<b>Proponent: </b>The proponent of a project

etc

such that the stuff inside the <b> element is taken from the first Row's
Cell/Data element from the same position in the sequence of Cell elements in
the first Row as the current Row's Cell/Data element sequence position.

Is this possible?

Thanks

Peter

<Worksheet xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<Table>
<Row>
<Cell><Data>Project name</Data></Cell>
<Cell><Data>Proponent</Data></Cell>
<Cell><Data>Authority</Data></Cell>
<Cell><Data>Theme</Data></Cell>
<Cell><Data>Year</Data></Cell>
<Cell><Data>Province</Data></Cell>
<Cell><Data>Region</Data></Cell>
<Cell><Data>Sector</Data></Cell>
<Cell><Data>Proponent Address</Data></Cell>
<Cell><Data>City</Data></Cell>
<Cell><Data>PostalCode</Data></Cell>
<Cell><Data>Country</Data></Cell>
<Cell><Data>Government contribution</Data></Cell>
<Cell><Data>Proponent contribution</Data></Cell>
<Cell><Data>Partner(s) contribution</Data></Cell>
<Cell><Data>In-Kind contributions</Data></Cell>
<Cell><Data>latitude</Data></Cell>
<Cell><Data>longitude</Data></Cell>
</Row>
<Row>
<Cell><Data>The name of a project</Data></Cell>
<Cell><Data>The proponent of a project</Data></Cell>
<Cell><Data>The name of the project manager</Data></Cell>
<Cell><Data>The theme of a project</Data></Cell>
<Cell><Data>2008-2009</Data></Cell>
<Cell><Data>New Brunswick</Data></Cell>
<Cell><Data>Atlantic</Data></Cell>
<Cell><Data>Provincial/Territorial</Data></Cell>
<Cell><Data>65 Some St.</Data></Cell>
<Cell><Data>Fredericton</Data></Cell>
<Cell><Data>E5B 5B1</Data></Cell>
<Cell><Data>Canada</Data></Cell>
<Cell><Data>40000</Data></Cell>
<Cell><Data>3000</Data></Cell>
<Cell><Data>6000</Data></Cell>
<Cell><Data>41600</Data></Cell>
<Cell><Data>45.364286000000001</Data></Cell>
<Cell><Data>-66.621815000000007</Data></Cell>
</Row>

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.