Multiple Excel

[muhammet.sezer2 (Muhammet Sezer)]

Hi,
I have 3 excels (Excel 1, Excel 2 and Excel 3)
All of these Excels have the same design.
We need some information between lines 7 - 10.
Each Excel has a different sheet name.
The output I want to have will be like the output Excel.
The page name should be ‘Info’.

Input :

Output :

[lchirathapudi (Pallavi Chirathapudi)]

Hi @muhammet.sezer2

Try this

Sequence.xaml (19.4 KB)

Regards,

[sarvesh.b (Sarvesh)]

Hi @muhammet.sezer2

Read all three Excels from Row 7 in for each activity. Then use append range in new excel sheet or file however you required.

Thnaks

[muhammet.sezer2 (Muhammet Sezer)]

Hi.thanks for answering.It created “Final.xlsx”. But it does not write into it. Why could this be?

[Nawazish_Ahmad]

Hi @muhammet.sezer2

Try this:

---

Forum.zip (2.6 KB)

---

Happy Automation
Cheers!!

[lchirathapudi (Pallavi Chirathapudi)]

@muhammet.sezer2

How about the following?

Sequence.xaml (20.3 KB)

Output:

Final.xlsx (9.2 KB)

Regards,

[lchirathapudi (Pallavi Chirathapudi)]

@muhammet.sezer2

If you want only 3 columns try below

Output:

Regards,
Regards,