複製Excel欄位資料到另外一個Excel檔案的第二行

[irene1018b (I111018)]

想要複製Excel檔案A的資料到Excel檔案B的某個sheet
從第二行開始貼上
發現只能複製到檔案A的新Sheet，請問要怎麼做才對~
Workflow:
Read range > Write Range
謝謝

[Aaron_Ko]

Hi @irene1018b
Do you need the header from excel A? if you don’t need the header from excel A then you can simply achieve this goal by disable add headers in write range. To be able to write in Excel B you need to have another excel application scope to open Excel B and put your write range inside of Excel B application scope.
belong link might be useful for you please have a look.

Filter the datatable and write in second sheet

Hi everyone, I need help on the filter datatable, I want to write the range in the second sheet after doing the filter. I use the filter data table activity and it is working fine in sheet 1 but it is not writing in sheet 2. Can someone help me to solve this This is my excel file SampleData.xlsx (16.4 KB) And this is my workflow Filter.xaml (8.8 KB)