Reading Data With Vertical Header From Excel to DataTable

Help
,
1

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

Sample Data:

vertical-header
vertical-header844×165 2.68 KB

2

@whyyouandi, Refer this to transpose your datatable,

Regards,
Dominic :slight_smile:

4 Likes
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)