An Automation Question!

[mail4bobbysam (Bobby Sam)]

Can anybody please tell me how to merge the contents in 10 excel sheets into a single excel sheet? Thanks

[rlgandu (Rajyalakshmi Gandu)]

@mail4bobbysam

Note:If you 10 sheets in one excel then use For each Excel Sheet Activity

[lrtetala (Lakshman Reddy)]

Hi @mail4bobbysam

Try this

Input:

Sheet1

Sheet2

Sheet3

Output:

If you have multiple excel files then check below thread

Copy folder with Excel files with columns together into a new Excel file

Hi @Matthias_Kuntz Welcome to Community!! Can you try the below code to write multiple excels to single excel in different sheets [image] Input: [image] Output: [image] [image] Sequence2.xaml (17.1 KB) or If you want to write multiple excel into single excel in single sheet then try below code [image] Merging Excels.xaml (18.9 KB) Cheers!!

Regards,

[suraj.setty]

Hi @mail4bobbysam ,

Merge 64 excel files into a consolidated sheet - Help / StudioX - UiPath Community Forum

Have a look.

[Parvathy (PS Parvathy)]

Hi @mail4bobbysam

Use the below macros code to append multiple excel sheets into single excel.

Append Data into Single Sheet.txt (1.1 KB)

Regards

[Krishna_Raj]

@mail4bobbysam
Sequence18.zip (1.7 KB)
check the file

[Nawazish_Ahmad]

Hi @mail4bobbysam

Try this- IF you have multiple Excel Files

IF you have multiple Sheet in one Excel File

Hope it will helps you
Cheers!!