Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

XSLT Transform to Microsoft Excel Problems

I have an application that exports a XML file to Microsoft Excel using XSLT. A problem I am having is that it is given me some extra rows. I just need the data in the XML file as is. Below is a copy of my XML file, XSLT file, and what is displayed in Excel. Any help would be greatly appreciated.

The XML file:

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table1>
<Title>Theories in Prevention</Title>
<NumEnrolled>1</NumEnrolled>
<NumCompleted>1</NumCompleted>
<NumIncomplete>0</NumIncomplete>
</Table1>
<Table1>
<Title>Drugs and Society</Title>
<NumEnrolled>1</NumEnrolled>
<NumCompleted>0</NumCompleted>
<NumIncomplete>1</NumIncomplete>
</Table1>
<Table1>
<Title>Family Dynamics</Title>
<NumEnrolled>0</NumEnrolled>
<NumCompleted>0</NumCompleted>
<NumIncomplete>0</NumIncomplete>
</Table1>
<Table1>
<Title>Another curriculum test</Title>
<NumEnrolled>1</NumEnrolled>
<NumCompleted>0</NumCompleted>
<NumIncomplete>1</NumIncomplete>
</Table1>
<Table1>
<Title>Test Curriculum</Title>
<NumEnrolled>1</NumEnrolled>
<NumCompleted>0</NumCompleted>
<NumIncomplete>1</NumIncomplete>
</Table1>
</NewDataSet>

XSLT file: (sorry for the link, but the board will not let me post the code)
http://Preventionidaho.net/development/Excel.xsl

Excel Output:
(notice that the data is outputted twice)
Title NumEnrolled NumCompleted NumIncomplete
Theories in Prevention 1 1 0
Drugs and Society 1 0 1
Family Dynamics 0 0 0
Another curriculum test 1 0 1
Test Curriculum 1 0 1
Theories in Prevention 1 1 0
Drugs and Society 1 0 1
Family Dynamics 0 0 0
Another curriculum test 1 0 1
Test Curriculum 1 0 1

Any help would be greatly appreciated, and thanks in advance.
[2299 byte] By [FlyingAce] at [2007-11-11 9:50:03]