Hi…
I have Database in Excel Sheet…
Datas are repeatively changing every time… i want to update the data in excel sheet…
if the is changed i have write the cells depending upon the column Name…
Example
Share Market price change every time… (as it same)
Any One tell me How to do ? i dont have any idea to start the process…
Thanks
Shyam
You can use For Each Row activity for this
and use Get Text activity to get the current share market price
Now use If condition let say SharePrice is your column then write as
Cdbl(row(“SharePrice”).ToString) <> Cdbl(GetTextValue)
Then-> use Assign activity and write as Row(“SharePrice”) = GetTextValue
Else-> blank
Hope this will help you
Thanks
i think this step is clear and can solve you problems @Shyam_Pragash
to compare you can use this inside for each
just another way to solve it :
IF
row(“rowname”).ToString = NEW_VarValue.Tostring
Then
ASSIGN
row(“rowname”)= NEW_VarValue.Tostring
Then you can write the new datatable based on the column/row u want or entrire excel
Hi @Srini84
U r replied well as per your knowledge…
But i doesnt understand… Plz Explain me in details (in Uipath Studio)
Thanks
Shyam
