Hi all!
I am using excel process cope to use excel file “RO”. > then inside i use for each row to take IDs and enter website to get needed texts. After completion of saving texts in variables i need robot to write them inside “Excel” excel file.
Should i use another excel process scope for 2nd excel or i can put all activities inside “DO” of for each row of the first excel scope?
hope i was able to explain
Hello,
If you are using two different excel files then you need to use different scope. else you can try workbook activities for writing instead using e el process scope.
Thanks,
Pathrudu
thanks Pathrudu, when i am using second excel scope to write in cell i cannot find CurrentRow variable from 1st excel scope. thats the problem
Got it.
When you are looping you might be using for each row in excel. instead use read range activity to read entire data to data table and then use for each row in data table activity to loop through rows and then you can update there.
Please do let me know if your approach is different.
If this helps you please mark as solution.
Cheers,
Pathrudu
Hey @elnur.isgandarov You can use as many excel files as you want in your 1st Excel Process Scope if you want to write into another excel then you have to use use Excel File Activity with different reference name so that it should not create confusion.
Cheers
If you need two different excels…then place one scope inside the other and change the reference name and you can access each file using separate references
Cheers
Cheers
You can use excel write range workbook or write cell workbook activity for 2nd excel file. you can use in DO of for each row activity if you want to update that file on row by row basis.
Thanks!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
