EXCEL ACTIVITY copy data

How to copy Column 1 and Column 2 from file A and create new sheet in file B and paste it ?

@sujith_naik … Please find the sample xaml and outputs below:

Main.xaml (10.6 KB) MoveColumnsFrom.xlsx (8.4 KB) Output.xlsx (7.3 KB) …

Mark this as solution, if it solve your query… Cheers

Hi @sujith_naik,

To copy column1 and Column2 from file A.

You can use this activity to copy the data to clipboard.
Cell rang as “A:B”.

To pasete ,
you can use the paste clipboard activity.

Cell range as “A1”.

Thank you
Balamurugan.S