Hello, how to read a data from Excel file to DataTable when the heading is laid vertically like this? Sample Data: [vertical-header]

@whyyouandi , Refer this to transpose your datatable, [image] How to copy column into row (transpose) Help Ignore the logic, use this.This is for complete excel transpose. excel_horizontal.xaml (15.2 KB) Regards, Dominic :slight_smile:

Reading Data With Vertical Header From Excel to DataTable

Help

Dominic (Dominic) February 7, 2018, 6:03am 2

@whyyouandi, Refer this to transpose your datatable,

Regards,
Dominic

4 Likes

Transforming DataTables, turning columns into rows

Regarding excel operations

Topic		Replies	Views
Writing data into excel column based Help excel , activities	11	7124	January 25, 2020
Regarding excel operations Help	3	1641	March 1, 2018
Transforming DataTables, turning columns into rows Help datatable	1	1967	February 22, 2018
How to read a worksheet with a table on top into a datatable with it's headers? Studio	12	952	August 21, 2022
How to write a Horizontal value in excel into vertically along with starting from specific cell range? Activities datatable , excel , activities , studio	1	953	September 16, 2021

Most Active Users - Yesterday
ashokkarale
sonaliaggarwal47
anjasing
mkankatala
Anil_G
manasrlenka25
A_Learner
SorenB
balaraman.ramiya
sharazkm32
More details...

Reading Data With Vertical Header From Excel to DataTable

Related topics