Inverting DataGrid columns and rows in excel

[Jack Mullins]

I am populating a datagrid and allowing it to be exported as an excel spreadsheet but my internal customer needs the columns and rows inverted. Any help will be appreciated. Asp.Net, Office XP, Visual Studio.Net 200
Jac

 

[Alvin Bruney]

Excel renders whatever the grid looks like so you need to get the grid to
conform first. Here is some code to flip rows with columns


http://www.networkip.net/tidbits/flip.htm
--
Regards,
Alvin Bruney
Got Tidbits? Get it here
www.networkip.net/tidbits

I am populating a datagrid and allowing it to be exported as an excel

spreadsheet but my internal customer needs the columns and rows inverted.
Any help will be appreciated. Asp.Net, Office XP, Visual Studio.Net 2002

 

[Jack Mullins]

Thanks Alvin, this looks like exactly what I'm trying to do.