To input all the row in the first column in the type into

[Irfan_Musa]

Hi everyone how do I type everything under this column “IMO_list”

I have create a datatable = DT_IMO
I have read the range and assign to variable = X

X = DT_IMO.Columns(0).ToString.Trim

I have a type into activity to do this.

I want it to act like a copy and paste.
Just paste the whole list.

[Anil_G (Anil Gorthi)]

@Irfan_Musa

Where do you want to paste it?

if on another excel you have copy paste range activity

if on some ui then get all values at once using this below in assign activity which convert whole column to string and you can use in further activities

str = String.Join(Environment.NewLine,dt.AsEnumerable.Select(function(x) x("IMO_List").ToString))

cheers

[Irfan_Musa]

@Anil_G ,

I tried the method but it does gives me error:

[Irfan_Musa]

I will paste it in a UI, there is like a text box to input these numbers

[Irfan_Musa]

Hi @Anil_G it works, I think I had a typo and I did not assign the datatable correctly. Thank you so much for your help