How to get whole column value from excel file in uipath

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

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

thanks for replying @arivu96,

In read range whats is range property ??

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

1 Like

Thanks, It’s work