If all the sheets in your excel have same columns and the type of date, do the steps
- Use excel application scope and read the excel
- Use get workbook sheets ad it will retrieve all the sheets in excel
- Loop through all those and inside that, read every sheet data and store in a data table
- Use merger data table activity and merge all the sheets data.
- Finally use another application scope and then write the merged data table to that new excel
Hope this is clear
thank you. i have another problem if we have a folder having different excels and we have to put into one excel contaninig diffrent sheets…plz hepl meabc.xlsx (8.6 KB) abc1.xlsx (8.0 KB) these two have in a folder
usecase2.xaml (9.9 KB) ihave attached the workflow
you want to write abc.xlsx and abc1.xlsx in one excel file with all sheets?
exactly so plz help me
to retrive excel files in your folder.
2 Assing CountVar=1
3.Use for each and give Arrvar as value to iterate excel files.
4.Then use excel application scope to open excel files.
5.Inside Excel Application scope use get workbook sheet activity to retrieve all sheets in each excel.
6.use get workbook sheet Output variable in for each activity.
7.In for each, add read range activity and give sheet name as item.tostring and op as dt.
8.Add another excel to write dt in sheets. In That add Write range Activity and give sheet name as “sheet”+CountVar.
9.And Finally add assign to increment counter as CountVar=CountVar+1
Find the attached workflow…
MegeData.zip (15.5 KB)
its not working
i am not getting the complete work flow plz help me out
write your main folder path istead of YourMainFolderPath…
i try but not working
here is an activity that may help you.