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

Help Automation Ops
,
1

how to copy column data with the index and paste it in another excel file.
how to copy multiple column data at a time

2

@anjani_priya

Read Range dtOriginal

Assign
dtSelectedColumns = dtOriginal.DefaultView.ToTable(False, 0, 2)

Write Range → dtSelectedColumns

3

where the indexes are mentioned?

4

dtSelectedColumns = dtOriginal.DefaultView.ToTable(False, “Column1”, “Column2”)

5

Particular columns should be add in the particular index
how to mention them?

6

no.The data didn’t copy.

7

Hi @anjani_priya ,

Do you have the Column Names and Index Mapping ? For Better and faster responses, would ask you to share with us an Example and the Expected output.

8

task is that salary and name in second sheet should fill in first sheet and salary should be in integr format
how to do it
Book1.xlsx (12.6 KB)

9

Hi @anjani_priya

Try this

image
image882×1344 61.5 KB

O/P:
Book1 (6).xlsx (12.9 KB)

Hope this helps!!

10

salary should be in integer format

11

Hi @anjani_priya

Try using vlookup formula in writecell activity and autofill range activity.

Hope it helps!!

12

yes but how to change salary column in int format?

13

@anjani_priya

Then try this

image
image882×1523 70.8 KB

image
image1159×795 37.6 KB

Book1 (6).xlsx (13 KB)

14

@anjani_priya
Use format cells activity and change it to number with 0 decimals

Hope it helps!!

15

no I have to change the whole column data at a time

16

@anjani_priya

Try this it is changing data type as integer

17

Capture15
Capture151020×776 25.6 KB

this is my code where should i put that?

18

excel files are different
copy paste works only on same excel file

19

@anjani_priya

In that case you can use Use Excel File activity within the Use Excel File activity then do Copy/Paste Range

20

input is one excel file and output is another excel file
copy paste works on single file