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]]

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" <ey*****@discussions.microsoft.com> wrote in message
news:00**********************************@microsof t.com...

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.