In a task, from our excel sheet data, the data should fill in the website. After every row is updated, the new column should be created and the status should be updated in that row. How to do?
In the for each row loop, put an assign currentrow.item(“column_name”) = <your_status>
In assign activity left side give row(“Status”) and in right side give “success” it will automatically update value in specific row. and if you want to create new column then use Add Data Column activity.
Main.xaml (9.0 KB)
In the for each row data table loop only at the end of transaction you can use the assign activity like this…!
After that inside the excel application scope you can use the write range activity to write the data to excel sheet and see the results…as you excepted it will show the success for every transaction
In write range, I wrote currentrow(“status”) but object is not converting into datatable
No, not like that you have done everything correct based on your case
but in the write range activity you need mention the data table
i have done some change in your code and attaching the xaml please check that
practice task 4.xaml (44.3 KB)
Let me know it’s working or not for you
Is there any package for updating the status?like transactions etc.,
Actually we have a package like activitiesteam.robot status but its not suporting for windows11
In your code, Iam getting the extra column how to remove it
practice task 4.xaml (29.9 KB)
i was attaching the new xaml and excel sheet here you can try this way instead of using the anchor base and all just use the Type Into Activity and in that only we can provide the anchor
for that you can see the output…!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.