How to update the status

[anjani_priya]

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?

[Anas-p-v]

In the for each row loop, put an assign currentrow.item(“column_name”) = <your_status>

[neha.upase]

Hi,

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)

[anjani_priya]

practice task 4.xaml (39.6 KB)
in this code, i need to add extra column and for every row, the status should be displayed as “success”.
challenge.xlsx (12.5 KB)
This is the input

[Praveen_Mudhiraj]

Hi @anjani_priya

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

[anjani_priya]

In write range, I wrote currentrow(“status”) but object is not converting into datatable

[neha.upase]

Hi, use for each row in datatable

[Praveen_Mudhiraj]

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

[anjani_priya]

hi @Praveen_Mudhiraj
Yeah done.Thankyou

[anjani_priya]

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

[anjani_priya]

hi @Praveen_Mudhiraj
In your code, Iam getting the extra column how to remove it

[Praveen_Mudhiraj]

Hi @anjani_priya
ExcelSheet
challenge.xlsx (12.4 KB)

Xaml
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…!