Reading Data With Vertical Header From Excel to DataTable

excel
activities
studio

#1

Hello, how to read a data from Excel file to DataTable when the heading is laid vertically like this?

Sample Data:


Regarding excel operations
#2

@whyyouandi, Refer this to transpose your datatable,

Regards,
Dominic :slight_smile:


Transforming DataTables, turning columns into rows
#3

Thank you!
Didnt find the article before!


#4

@whyyouandi, We have 22k posts in forum. Now its very heavy to find it.

Regards,
Dominic :slight_smile:


#5

It’s really growing rapidly! (laugh)