We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Transpose Excel data from rows to columns or vice versa

Thread ID:





149194 Nov 18,2019 12:17 PM UTC Nov 20,2019 10:07 AM UTC WPF 3
Tags: XlsIO
Aleksander Zotov
Asked On November 18, 2019 12:17 PM UTC


I am currently using ExtractDataTable function to show content of Excel file in my SfDataGrid.
Is there a possibility to transpose rows into columns and backwards?

Best Regards,

Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On November 19, 2019 12:44 PM UTC

Hi Aleksander, 

Greetings from Syncfusion. 

We have prepared simple sample to Transpose the rows and columns in a DataTable. The sample can be downloaded from the following link. 

Kindly try this and let us know if your requirement is fulfilled. 


Aleksander Zotov
Replied On November 19, 2019 02:33 PM UTC

Thank you very much!
This worked as charm.

Best regards,

Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]
Replied On November 20, 2019 10:07 AM UTC

Hi Aleksandar, 

Thanks for the update.  

We are glad that your requirement is achieved. 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon