Merge multiple excel file sheets into single excel file with multiple sheets

Help Activities
, ,
10

@Yoichi

I am trying to use bit different approach :smile:

  • Excel Process Scope
    ----- Use Excel File (Result.xlsx)

  • For each file in folder (looping through all xlsx files)
    ----- Use Excel File (CurrentFile)
    ---------- Use Each Excel Sheet
    --------------- Copy Sheet (CurrentSheet.Name) (file = Result.xlsx, Sheet = CurrentSheet.Name)

Conclusion:

  • UiPath is simply creating extra empty sheet in the Result.xlsx as Sheet2