Merge multiple sheets in a excel

Help Robot
,
1

I have four sheets in excel i want to merge all data in 1 sheet

2

Hi @Kuldeep_Pandey

If columns are same… Then read all the sheets and use merge datatable to merge and then write back to excel

cheers

3

Hi @Kuldeep_Pandey

Check out this video link

Regards
Gokul

4

@Kuldeep_Pandey u can use simple way of append the data from other 3 excel to first one (or any other).
Read the data using excel activity and use append datatable to merge

5

append data table property

6

Hi @Kuldeep_Pandey

Check out this XAML file

MergeDT.xaml (8.9 KB)

Regards
Gokul

7

@Kuldeep_Pandey Yes let me attach a xaml for the same

8

use this link

In this i have shared the images

9

In append activity we cants add headers?

10

Hi @Kuldeep_Pandey

Just update like this in the screenshot

image

MergeDT.xaml (8.9 KB)

Regards
Gokul