Need urgent support for foreach activity with excel file and Oracle application

Help Activities
, ,
1

I have finished an oracle application automation to get some data from excel file to the application.
what I need is to do the same action for all row in Excel sheet and all files in the folder also.
this is the excel file

image
image1920×1080 266 KB

1-25-ECC-GL.costing -Adjust Health & Safety expenses.xlsx (344.5 KB)
and this is the automation
Main.xaml (98.5 KB)
thanks, in advance.

2

@mohamed.saty2012

  1. Yse for each file in folder
  2. Use excel file and pass currentFile.FullName
  3. Use for each sheet in excel with excel as handler
  4. Inside the above for eqch use the while code you built for each row

Hope this helps

Cheers

3

hi, i have done the for each row in data table first.

image
image1920×1080 278 KB

but i get this error.

4

if things are not clear enough, I can provide a remote access to my laptop Webex or Anydesk.
if it is not too much to ask.

5

i have fix this error but there is a new problem now. the robot work fine but in the oracle form when he finish line one it doesn’t move to line to. the robot take line to in the excel sheet and repeat it in line 1 again and aging until all rows are complete.
i have send a hot key at the end to move to line to but it comes back to line 1 again.

image
image1920×1080 178 KB

6

@mohamed.saty2012

That mwans you are using same selector generally tablerow or idx will be changing for each row check that in the selector and change it in the for loop using for loop index property in the for loop properties

Cheers

7

sorry for this but i am new at this, i don’t know what to do i have send the automation for you.
could you pleas look at it and see what exactly i have to do?