Copy excel column and paste on new excel

Help Studio
, ,
1

Hi team,
I am trying new process, where I copy column value and paste it on new excel for validation

2

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.

3

@rahulsharma

can share screen shot or xaml file for this.

4

@Majunu09

  1. Use Read Range activity to read the data from input excel file and it will give output as DataTable. Let’s say ‘InputDT’.

  2. And then use below expression to fetch only one column.

            columnDT = InputDT.DefaultView.ToTable(False,"ColumnName")

Here, Mention corresponding column you want to copy.

  1. 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)
5

@Majunu09

You can try as below

image
image817×439 12.7 KB

or you can try with the @lakshman suggestion too

Hope these help you

Thanks

6

@Srini84 I was trying without enter the range of the column. Thank you for the support.

7

@lakshman @rahulsharma @Srini84
Thank you for the support.

1 Like
8

@lakshman is there any other way to add a header of the colum?

9

@Majunu09

Mention Range as “L1” in Write Range activity and check Add Headers option in it.

1 Like
10

@lakshman Thank you once again.

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.