ToDataTable for transpose worksheet data

[spk33]

is there easy way to load worksheet data into DataTable , where the sheet is has transposed data like below

Hey can we use TODataTable options for easily reading transposed data in excel

[swmal]

No, unfortunately not.. you'll have to read from the sheet cell by cell.

But a good idea to support this, I'll add the enhancement label to this issue and we´ll see what we can do,

[spk33]

awesome thanks for considering