How to get whole column value from excel file in uipath

activities
studio

#1

Hi,
How can i get whole column name from excel file
like:-image

Is there any solution or any example to get column “A” whole value in data-table??

Thanks,
@Sam


#2

Hi @sams,

use Read range activity to get the all the data to the data table(dt)

use assign activity

dt=dt.DefaultView.ToTable(false,"Country")

Regards,
Arivu


#3

thanks for replying @arivu96,

In read range whats is range property ??


#4

Hi @sams,

leave it as blank or empty. so it will take the all the value then we can filter using above code.

Regards,
Arivu


#5

Thanks, It’s work