xml/Excel column order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top