How to copy the all the value in same excel

Help Studio
1

Hi,

I have two sheet which is sheet 1 and sheet 2
header for the both sheet will be same…
i need to merge the sheet…
example i need to merge sheet 2 value into sheet 1…

  1. excel application scope
    2 inside that read range for two sheet( sheet1 and sheet2)
    DT1, DT2
  2. Then i tried with append range and it is appending in 10 or 15 th row. it should append in 4th row.
    even i tried merge data table with source as DT2 and destination as DT1 its not doing any operation…
    Kindly help me out to resolve this issue.
2

@vaishaliR

image
image704×582 17.2 KB

It worked as expected with merge datatable, what is your issue?

Thanks

3

merge.xls (21 KB) Main.xaml (6.6 KB)

Please find attached example

1 Like
4

Thanks for the reply…
yes i got the output but am getting the extract heading as column 1, column 2… till column 13
why so…?
how to get rid of that