How to combine multiple excel files into one workbook with multiple sheets

Hi @canlilar,

Use the below logic.

  • Create a string variable named as “Filenames”
  • Assign Filenames = Directory.Getfiles(“Folderpath”)
  • For each item in Filenames, item type as String
  • Excel application scope, In workbook path give item. Use Read range with output as Datatable1
  • Excel application scope, In workbook path give a new output file name. Use Write range with input as Datatable1, sheetname as item.