Reading multiple excels and writing one excel

Help Studio
, ,
1

hi, help please Reading multiple excels and writing one excel

2

Hi @yildirim01.burak

1.Use Workbook Read Range Activity pass the path of excel file, sheet name and create output data table variable(DT).
Use another Workbook Read Range Activity pass the path of excel file, sheet name and create output data table variable(DT1).
2.Use Workbook Write Range Activity pass the path of excel file, sheet name and pass the output data table variable(DT) in properties check add headers.
Use Workbook Append Range Activity pass the path of excel file, same sheet name and pass the output data table variable(DT1).

Regards,
Kommi Jeevan.

3

I did it too, but it erases the first data and writes the second data. What I want to do is READ (EXCEL 1, EXCEL 2, EXCEL3, EXCEL4, EXCEL 5) WRITING THEM NEW EXCEL 6 WRITE

4

image

I have to read the excels in the picture and write the excel below

5

image

6

Main.xaml (7.8 KB)

Check this and modify your excel folder paths