Sahil Jani

Sahil Jani

  • NA
  • 274
  • 155.1k

Convert all the columns title into row and rows into column of excel file

Jun 9 2011 1:50 AM
Hi,

I have one excel sheet named Sheet1, there is some data like;

Sr.No        Particular        Mail_ID
1.                abc            [email protected]
2.                def            [email protected]
3.                ghi            [email protected]
4.                jkl             [email protected]

But, I want that data in other Excel sheet like;

Sr.No                1                2                3                4
Particular         abc              def             ghi              jkl
Mail_ID        [email protected] [email protected] [email protected] [email protected]

So, how should I do this using C# ASP.NET 3.5 ?

Answers (6)