XML int column duplication & column alphabetizing

[timandkids]

I have an XML file saved as a .xls file. It was dynamically created i
VB.NET through a web app, pulling data from a SQL Server database (i
that makes a difference). Here are my 2 problems:

When I open the file in Excel 2002, it duplicates every column that ha
only integers in it, adding a *#agg* to the duplicate column title.
don't want the columns duplicated (obviously).

The second issue is that it is alphebetizing my columns. I don't wan
them alphebetized. I want them in the order in which they are listed.

Here is my XML code. You could simply cut and paste this into a blan
text document and save it as a .xls file. Then it will open in Exce
and you will see what I mean.



PHP code
-------------------

<?xml version='1.0'?>
<NewDataSet>

<Table>

<Condition>Consignment</Condition>
<Type>Deck Boats</Type>
<Make>Tracker</Make>
<Year>1999</Year>
<Model>AMP-456</Model>
<Engine>Honda</Engine>
<HP>75</HP>
<Price>4.00</Price>
<Stock>65423467</Stock>

</Table><Table>

<Condition>New</Condition>
<Type>Bass Boats</Type>
<Make>Baja</Make>
<Year>1990</Year>
<Model>ABC1990</Model>
<Engine>Chrysler</Engine>
<HP>120</HP>
<Price>76547.00</Price>
<Stock>6543-DFHG</Stock>

</Table><Table>

<Condition>New</Condition>
<Type>Bass Boats</Type>
<Make>Baja</Make>
<Year>1999</Year>
<Model>GHKJJ-MX</Model>
<Engine>Chrysler</Engine>
<HP>100</HP>
<Price>2534.00</Price>
<Stock>543243</Stock>

</Table>

</NewDataSet>

 

[timandkids]

http://www.dotnetjohn.com/articles/articleid78.aspx



Thanks