How to copy templete and write excel?

Help Activities
, ,
1

If I have template file (header) and file input have 4 file as below. (in example input have 2 files)

input1.xlsx (10.8 KB) input2.xlsx (10.8 KB) output.xlsx (10.6 KB) templete.xlsx (8.9 KB)

round1 :
I want to create new file by copy data from template file.
and read data from file input (row 8 - end) then write it in new file (row9 - end).

round2 :
read file input file2 (row 8 - end) and copy data from template file ----> create new sheet in file output round1.
Please guide me about it please.

2

Hi,

How about the following sample?

Sample20210428-1.zip (44.2 KB)

Regards,