Place all the activities in for each loop.
Yes I want to write it in all 3 files ,not only remark column but also “status” ,“QT”, and “Claim” columns are there.
So you gotta place those write cell activities as well in the Loop
see i have added all the write cell and read range activity inside the for each.
still it is only processing one excel.
And what are those invoke Code activities doing, are these also working on all 3 files? If so please keep them in the loop as well
Write cell activity is not in initial state it is also in the process state to update each transaction.
I added all invoke code activity in the for each file in folder activity still it is processing only 1 excel.
if you want i can share the code as well
Guys anyone please help out on this.
Please share the code or explain what you properly wanted to do.
- In this process i want to read 3 excel from a folder.
- it should process one excel after another.
- i have used “FOR EACH FILE IN FOLDER” to read all the excel files from the folder. and it is reading.
4)The thing is that RPA is only reading the 2nd excel and after processing it is not moving to the next excel it got stopped in the first excel
Hello @Gokul_Murali
Main.xaml (109.5 KB)
I made some changes you can directly replace your main xaml with this one and review that your data will run with it or not. (you can copy your main xaml to another folder for 5 min and add this one)
Hope this helps
Any Idea brother
That error occurs when the arguments and variables were not passed properly. So check if you have passed all the variables and arguments properly.
Regards
till the process is Not working !!
Try assign activity for initializing datatable. Dt_finaldatatable = new datatable ,before assign inside of if index=0 then part.
Now the process is running but only taking one excel and after processing one excel it is not processing the second excel.