If I want combine all file excel in folder in one file.
Please guide me.
If I want combine all file excel in folder in one file.
Please guide me.
Use Append range activity…
@fairymemay - Read range is inside the for each loop…it will read only one file at the time and right output …and then it will read the next file…
@fairymemay - Please find the starter help here…
@fairymemay - Please see the read range…i am not using the file name at all…
I am looping the file names in the for each loop
First time==> data1.xls – Each file – this will read and write to using the read range because the output.xlsx file does not exist first time
2nd time ==> data2.xls – Each file – this will read and write to using the append range because the output.xlsx file does not exist first time
Please take some academy courses for “For Each” loop which will help you…or there is lot of youtube videos out there…
@prasath17 From picture in read range you use sheet1. But I want read first sheet.
Got you…Apologize I did not read correctly…
In that case…Use Excel application scope…
This will always fetch the first sheet…In the read range save the output workbook as “WB”
@fairymemay - Did it worked?? let us know, if you need assistance…
@fairymemay - sure … All you have to do is just follow the screenshot closely and mimic step by step. It has only few activities.
File.exists → you should give your final output excel file name here. In my case ouptut.xlsx
Append Range and Read Range → give the same file name
@fairymemay - Fixed now…Your workflow is perfect other than you had duplicated ‘dt’ variable. Run this below file “As is” you will see the output.xlsx gets created in the project folder…
Append Files_Noona.zip (58.0 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.