How to update a status cell in excel automation

Hi,

i extracted data from browser and write in excel
in that excel sheet we have values, if the values are in lessthan 0 then i need to update a status price is increased or else condition price is decreased.

for example,
name value status
a +0.125 increased
b -0.7 decreased
c -0.126 decreased

value column is extracted using get text activity, and it is stored in string variable
the status column we need to update

please help with the code and it would be appreciated for your help.

check after reading the excel, check if row(“Value”)<0
1.if yes in the assign activity set ctrl+k status= increased
2.if no set status=decreased then use build data row column name status type should be string
3. then Add build data row to pass the {“Status”}
4.Then use Append range thats it

Hi,

Thanks for your response.can you please provide a .xaml file for my reference

add status in the excel sheet.zip (2.7 KB)
Pls refer, any doubt feel free to ask.

1 Like

Hello, @Sai.Srinivas - Have a look on the attached workflow

Example.zip (10.3 KB)

Output

Capture1

1 Like

@Sai.Srinivas It converts the string to double as we are comparing the decimal format type value with 0

@Sai.Srinivas If it resolves your issue please close the topic by choosing an appropriate post as solution

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.