Copy one whole column data

Help Studio
,
7

Hi @Aarthy1

If you want a single column as output

Read the sheet as a datatable
Take an assign activity
in the RHS of Assign
image
write something like this - dtNew.DefaultView.ToTable(False,"ColumnName")
here dtNew is a datatabe variable of the sheet your read, in the LHS just take a new datatable variable.
Now print that new datatable variable in that specific range, you will get the single required column.

Thanks