How to update status in excel sheet

#1

Hi All,
I am facing one issue.
I need to fill web form from an excel sheet. After each form i need to add Status (Pass or Fail) in column “Status”. Could somebody plz help.
I tried Assign activity but its not working. Uploaded screenshot for reference.

image
image.png1191×58 5.75 KB

1 Like
#2

Hi
welcome to uipath community
hope these steps could help you resolve this
–use excel application scope and pass the file path as input
–use read range and get the output with a variable of type datatable named dt
–use for each row loop and pass the above variable as input
–inside the loop use a open browser and mention the url of that web form
–inside the browser to get the value of a specific column use the expression
row(“yourcolumnname”).tostring
–after mentioning them, use a assign activity like this
row(“Status”) = "your string"

–now next to this for each row loop use a write range activity and mention the input as dt and sheetname which will update that new datatable with status column to the excel we need

Cheers @Anamika15

#3

Hi,

1)use read range activity so all the data from the excel will be available in Datatable.
2)Use for each row for processing row by row
3)inside the for each row activity, give assign to write the status.(if status pass—> In assign activity row.item(“status”)=“Pass”.
4)this will add the status to the Datatable.
5)once all the rows are completed, use write range activity to write everything in a new excel sheet

#4

image
I am doing this for now. But its not writing in the excel sheet. Please let me know what is wrong in this.
I need to write in the same excel sheet. Not the new one.

1 Like
#5

hi,

Give pass in double quotes.“Pass” and use wite range activity by giving input as the datat table name as mentioned above

#6

hi,

Give pass in double quotes.“Pass” and use write range activity by giving input as the datat table name as mentioned above

#7

you were almost done
Pass is a string so we need to mention them between double quotes buddy

kindly try once and let know for any queries or clarification
Cheers @Anamika15

#8

image
Still not updating the excel sheet. Any suggestion?

1 Like
#9

–in assign mention like
row(“Status”) = “Pass”
–kindly check with the spelling of Status columnname and mention that in the above expression between double quotes
–then kindly use the write range next to the for each row loop
–and mention the range as “” and not as “J1”
you were almost done
Cheers @Anamika15

#10

Hi,

Please remove “J1” and leave it blank . I hope now the ouput will write in excel

#11

I have learned the Excel Sheet updating process by checking in the facebook page. It helps me to understand the essential basics which I need to know.

#12

ExcelUpdate

“M”+rIndex.ToString

This can work your situation.

#13

Hi @Anamika15

In set transaction state success case
you can follow like below according business exception and system exception as well.

image
image.png634×560 9.64 KB

#14

Thanks :slight_smile: This worked.

1 Like
#15

No worries
Cheers @Anamika15

#16

Thanks for the response :slight_smile: