xml/Excel column order

[eye5600]

This may be an Excel question, not a VS or C# question. I create write a
table from a dataset using XmlWrite. Looking at the xml file, the column
order looks the same as the SELECT statement that created the table, but when
I read it into Excel, the columns appear in sorted order. UGH!

How do I get the columns in the proper order.

[Alvin Bruney [MVP - ASP.NET]]

Re: xml/Excel column order

you might want to write a post load routine that goes thru the spreadsheet
and re-sorts in the order of the original data.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"eye5600" <eye5600@discus sions.microsoft .com> wrote in message
news:00EB1080-3169-4E27-9F0A-DAB492F03898@mi crosoft.com...[color=blue]
> This may be an Excel question, not a VS or C# question. I create write a
> table from a dataset using XmlWrite. Looking at the xml file, the column
> order looks the same as the SELECT statement that created the table, but
> when
> I read it into Excel, the columns appear in sorted order. UGH!
>
> How do I get the columns in the proper order.
>
>[/color]