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?
Hey! Welcome to community!
Have a view on this thread
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,
Gokul001
August 22, 2022, 6:49am
3
Hi @Sindhu_Priya
Welcome to UiPath community
Have a view on it
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
Gokul001
August 22, 2022, 6:59am
6
Just watch over this thread too @Sindhu_Priya
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…
