Summary for multiple excel files

[Amol_Golhar]

Dear Team,
I have a multiple excel files, i have to prepare a summary file by adding all excel files data,
Sample excel file, with 3 columns.
LABWORKS 1 SP Who2.xlsx (7.9 KB)

The issue is, for some files data is coming with erorr meassage in first column.
LABWORKS 21 SP Who2.xlsx (8.0 KB)
i have to add this error also in summary file in single row.
As shown in below file.
32 All Results Summary.xlsx (9.9 KB)

Thanks,
Amol

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @Amol_Golhar

I have solved your query!

Just execute it, I’m unable to execute it cause didn’t have input files!

I’m attaching the .xaml for your reference!
MergerMultipleExcelSequence.xaml (16.7 KB)

Let me know if need any further assistance.

If your query got resolved, then kindly mark the post as a solution. It will help others to find the correct solution.

Regards,
Ajay Mishra
RPA Developer