i need someone to tell me how to select excel cells like : A1 copy , go to browser , paste , save audio , A2 copy , go to browser , paste , save sudio … and so on
i want a variable or something like that ( i hate variables because they are tricky but i’ll do it ) to solve the problem.
Better approach would be to use Read Range Activity to read the whole excel file into a Data Table and then use the For Each Row in Data Table Activity to iterate through whole data table and to get the required value you have to use - CurrentRow(0).ToString
For further information please read about these activities.
Use Read range(Workbook) activity to read the excel file and save it in a data table variable.
Use the for each row in data table activity and all other sequences will be inside the body of for each activity.(Do not use build Data Table activity, by using read range you have already saved the excel file into data table variable)
Wherever you want to use the excel cell value just use row(0).ToString
You put the datatable name into the “in” box for the For Each Row activity. Then it loops through the rows in that datatable. Inside the For Each Row you put the steps you want done on each row.
The Read Range puts it into myDT (or whatever you name it) and you use that datatable as the input to the For Each Row:
In the Body portion, you put the steps you need done to each row (build the URL with the data from the row’s appropriate cell, go to that URL, save the file).
By the way, if you hate variables then you should take some basic programming classes. Variables are essential to proper programming.
it worked uncorrectly but i did some enhancements and it’s working now right
But google stops it after some words and it needs a captcha verification , how to make the robot recognise the captcha button and click it ?
I didn’t comment yesterday because uipath forum tells me i have reached the maximum for a new user , but i’m not new with RPA and i have a uipath account for a year … strange things happen always.
i made it click the button but it makes an error when i try to step over and says ui element is no longer valid , What to do now to tell it to press the button if seen ?
i tried the if condition but it seems that it’s not solved by this way.