How to write all excel sheets data into one excel sheet

[Sindhu_Priya]

How do you consolidate an Excel sheet, lets say you have five excel sheets as input and all the five excel sheets data should written in a single excel sheet?

[THIRU_NANI (NaNi)]

Hey! Welcome to community!

Have a view on this thread

How To Merge Many Excel Sheets in One Sheet Using UiPath?

Dears, How To Merge Many Excel Sheet in One Sheet Using UiPath? Knowing that , the Number of Sheet might Increase or Decrease, So Probably Need For Each Loop to Read first Existing Sheets in Workbook than Merge them all to one sheet. [image] Thanks in Advance

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

Hi @Sindhu_Priya

Welcome to UiPath community

Have a view on it

How To Merge Many Excel Sheets in One Sheet Using UiPath?

Dears, How To Merge Many Excel Sheet in One Sheet Using UiPath? Knowing that , the Number of Sheet might Increase or Decrease, So Probably Need For Each Loop to Read first Existing Sheets in Workbook than Merge them all to one sheet. [image] Thanks in Advance

Combine multiple Excel sheets into one using UiPath

Regards
Gokul

[Sindhu_Priya]

Thank you…

[Sindhu_Priya]

Thank you…

[Gokul001 (Gokul Balaji)]

Just watch over this thread too @Sindhu_Priya

Combine Excel Sheets Into 1 New Excel File

Hi all, I have an Excel Workbook with multiple sheets (amount of sheets & sheet names will vary each time). the structure of each sheet is the same (Same 4 columns, just different data): [image] What I’m trying to do is combine all of these sheets into 1 new Excel Workbook on 1 sheet, with just the headers at the top, and all of the data. So I want each sheet’s data to be copied below the last row on each sheet (no line breaks or spaces between): [image] I’ve tried doing this with Merge Dat…