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.