Merge two excel sheets from different excel files using sheet name

[Sukanya_Dutta]

Hello Everyone,

I want to merge two different excel file sheets like “File 1 : Sheet1 & File 2 : Sheet1”, “File 1 : Sheet2 & File 2: Sheet2”…using Uipath activities. Can anyone please help me to resolve this problem?

[RK_0 (RK)]

Hi,

This video might help you

Merge Multiple Sheets of Excel Files to Single Excel using UiPath | Combining Sheets of Input Excels

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
First you can use Read Range(For reading sheet 1 of File 1)-DT1
Then you can use Read Range(For reading sheet 1 of File 2)-DT2
You can use Merge Data Table ACtivity- In Destination you can keep DT1
and in source You can keep DT2

Thanks,
Rounak

[Sukanya_Dutta]

But I have multiple sheets in both file.

[Rounak_Kumar1 (Rounak Kumar)]

Then You can loop the sheets and Append Range Activity you can use so it will append the data sheet by sheet

Thanks

[RK_0 (RK)]

Hi,

Try this workflow and modify it by adding read range for each sheet and add data row to result datatable
Main.xaml (11.5 KB)

[Rounak_Kumar1 (Rounak Kumar)]

Hi,

Follow this worflow
MergeDataTable Scenario.xaml (9.6 KB)

Thanks,

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
if you got expected Output.
Please accept the solution.

Thanks,
Rounak

[Sukanya_Dutta]

How can I extract one sheet from multiple sheets?

[Rounak_Kumar1 (Rounak Kumar)]

Do you have Name of the sheet then you can directly provide or if you don’t have then you can use get Workbook sheets activity . I have provided the workflow Sample.
Please check it will help you.

Thanks,
Rounak

[Sukanya_Dutta]

By using get workbook sheets activity I got all the sheets but I want only one sheet from them.

[Rounak_Kumar1 (Rounak Kumar)]

then you can use break activity after getting one sheet

Thanks

[Sukanya_Dutta]

Can you show me how to use Break activity?

[Rounak_Kumar1 (Rounak Kumar)]

Please follow this workflow
MergeDataTable Scenario.xaml (10.3 KB)
Thanks
Rounak,

[Rounak_Kumar1 (Rounak Kumar)]

Are you getting Expected Output??

[Sukanya_Dutta]

One more question: How to append data by sheet name?

[Rounak_Kumar1 (Rounak Kumar)]

you can use Append Range Activity

[Sukanya_Dutta]

I know but How can I append data by sheet name for example: File 1: Sheet 1 & File 2: Sheet 1.
I want to append file 2: Sheet 1 data into File 1: Sheet 1.

[Rounak_Kumar1 (Rounak Kumar)]

please Follow this

Thanks

[RK_0 (RK)]

@RK_0

Try this workflow and modify it by adding read range for each sheet and add data row to result datatable
Main.xaml (11.5 KB)

Hi,

Following this template workflow and provide the sheet and excel file name you will the required output