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
Regarding excel operations Help	3	1658	March 1, 2018
Transforming DataTables, turning columns into rows Help datatable	1	1987	February 22, 2018
Writing data into excel column based Help excel , activities	11	7130	January 25, 2020
Transposing Excel Data Into a DataTable Help	8	6516	April 1, 2019
How to convert horizontal excel data to vertical excel data individually Activities datatable , excel , activities , question	3	2297	November 18, 2020

Reading Data With Vertical Header From Excel to DataTable

Related topics