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

Question

Hi I have one excel sheet named Sheet1 there is some data like; Sr.No Particular Mail_ID 1. abc xyz@xyz.com 2. def xyz@xyz.com 3. ghi xyz@xyz.com 4. jkl xyz@xyz.com But I want that data in other Excel sheet like; Sr.No 1 2 3 4 Particular abc def ghi jkl Mail_ID xyz@xyz.com xyz@xyz.com xyz@xyz.com xyz@xyz.com So how should I do this using C# ASP.NET 3.5 ?

Muralidharan Deenathayalan · Answer

public DataTable PivotearTabla ( DataTable source ) { DataTable dest = new DataTable ( ) ; dest. Columns . Add ( Sr.no ) ; foreach ( DataRow r in source. Rows ) { dest. Columns . Add ( r [ 0 ] . ToString ( ) ) ; } for ( int i = 1 ; i Columns . Count ; i++ ) { DataRow fila = dest. NewRow ( ) ; fila [ 0 ] = source. Columns [ i ] . ColumnName ; dest. Rows . Add ( fila ) ; } for ( int fil = 0 ; fil Rows . Count ; fil++ ) { for ( int col = 1 ; col Columns . Count ; col++ ) { dest. Rows [ col -1 ] [ fil +1 ] = source. Rows [ fil ] [ col ] ; } } dest. AcceptChanges ( ) ; return dest; } Hop this helps you.

Muralidharan Deenathayalan · Answer

It is working for web application without making any change.

Sahil Jani · Answer

Hi Murlidharan Ohki I will try and let you know if I will get any error on that code. And once again thank you so much for helping me.

Muralidharan Deenathayalan · Answer

The same will work in both in windows and web applications.

Sahil Jani · Answer

Hi Murlidharn Thanks for giving code. But I want that code in asp.net and I'm new to this so I don't know how to write this windows application code in web application. Please help.

Muralidharan Deenathayalan · Answer

The output will be like this....