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:
Code:
<?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.