Copy data from excel & paste in other excel

Help Studio
,
1

hello, anyone can tell me
I have two excel files below output and base excel files i want to copy data from output excel file only upto BW column

Then in base file existing data paste output file data upto to only BW column and remaing data need not to be changed

output excel file
col-a |col- b | col- c | col-d --|–col-bw |col-bx | col-by |col-bz
AB | PQ | MN | ST | YZ | SE | RT | YT

Base file
col-a |col- b| col- c | col-d --|–col-bw | col-bx col-by |col-bz
ed rt | ty | yu | hg | y | y | y

--------------result------------------------------
Base file
col-a |col- b | col- c | col-d --|–col-bw | col-bx| col-by |col-bz
AB | PQ | MN | ST | YZ | y | y | y

2

Hi @yogitagaikwad2206

Can you please explain your query in much better way.

Thanks!!

3

Hi @yogitagaikwad2206

Check the below image for reference. Here You need mention the Range in the Copy Paste range Activity.
The Below Image will copy entire sheet.
To Copy only specific range Need to mention .range(“”)

image
image899×1351 58.8 KB

Hope it helps!!

4

This is my output file & there is number of columns with data
I want to copy output file data only from 1st column to BW column

image

This is my second excel base file
In that paste output file data which is 1st column to BW col
and must no change to existing data next to BW column of base file
means only 1st column to BW column data changed in existing data in base file

image
image836×412 11.6 KB

5

Hi @yogitagaikwad2206

Try this

image
image828×1353 58.4 KB

Thanks,
Pallavi.

6

Use Excel activities and use copy paste range activity by giving your data range.

Or you can also use the
Excel application scope read range activity for your input file and write range activity for your output file.

Thanks!!

7

image
image722×631 21.5 KB

it’s right?
plz tell me why this error is come

image

regarding excel

8

Refer this forum link

9

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