How to read horizontal key and value from excel file

I want to read the university name and well all below data

well you can DataTable.Select("YourColumnName = ‘University Name’ ")

without using datatable used only read range activity.

image

what do you want do exactly?

Hi @Aarti_Godhasara

Use @balupad14

https://go.uipath.com/component/balareva-xl-activities

based on merge and unmerge cells

Thanks
Ashwin S

1 Like

hi @Pradeep_Shiv

i want to add excel headers as a key and corresponding row to values

i get only testcase value in runtime i.e 1,2,3 or 4