How to copy data from different columns at a time and paste it in another excel file

Help Automation Ops
,
1

How to copy data from different column data at a time and paste it in another excel file.How to copy the random columns at a time

2

Hi @anjani_priya ,
Can you tell more
or send input and expect output?
regards,

3

@anjani_priya

Use this query

Dt.defaultview.totable(false,“column1”,“column2”)

You can pass your column names inplace of column1 and column2

Below to it use write range activity

4

You can use this query in an assign activity and then write the datatable using write range

dt_Sample.DefaultView.toTable (false,“Columnname1”,“Columnname2”,“Columnname3”,…)

6

I have tried but the values are not entering

7

@anjani_priya

can you share any sample excel so that i will send the code

8

Book1.xlsx (11.5 KB)
the data from sheet2 of name and salary should add in sheet1

9

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