I am trying new process, where I copy column value and paste it on new excel for validation
Just use Read Range foe that one column, you can so this by using the range field, make it for only one column.
Then that datatable you read, can be pasted using Write Range, on an another file.
can share screen shot or xaml file for this.
Use Read Range activity to read the data from input excel file and it will give output as DataTable. Let’s say ‘InputDT’.
And then use below expression to fetch only one column.
columnDT = InputDT.DefaultView.ToTable(False,"ColumnName")
Here, Mention corresponding column you want to copy.
- And then use Write Range activity and pass Sheet name, above output DataTable ColumnDT and mention Range as below.
Eg. “L2”(If you want to write into L-Column)
You can try as below
or you can try with the @lakshman suggestion too
Hope these help you
@Srini84 I was trying without enter the range of the column. Thank you for the support.
@lakshman is there any other way to add a header of the colum?
Mention Range as “L1” in Write Range activity and check Add Headers option in it.
@lakshman Thank you once again.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.