I am scraping a web page for element class and saving it to a variable.
I want to save the results to a data table.
My data table has 7 columns: Day1, Day2, Day3, Day4, Day5, Day6, Day7
I need to repeat the ‘For Each UI Element’ activity for each day.
How can I get the values to save to the next column each time? I can only figure out how to add a row to column 0.
Thank you!
Use another loop for days inside for each ui element…and create a datatable with 7 columns called dt
If the day is 1…that is index = 1 in if condition…index is the properly in for loop(add a variable to it)…then use add data row with {statusButtonValue,"","","","","",""}
Then on the else side of if…use assign dt.Rows(dt.RowCount-1) = statusbuttonvalue
Assuming statusbutton value is the one which is getting eqch value to be assigned in columns…if it is something else then change accordingly
Cheers
Share the website link will do video and share the solution
