Hello,
how can add to the cell without deleting the values in the cell i am new in the RPA and i am using studiox.
Hello,
how can add to the cell without deleting the values in the cell i am new in the RPA and i am using studiox.
Hi @nawaf7456 ,
just thought from my side. please try and let us know if it helps your requirement.
Use excel file activity and assign your excel file path.
Inside use excel file activity use read cell activity to read the information from cell in the excel and store the value in the saved value(variable in the Studiox).
Now use the write cell activity and combine the already saved value from above with the new text you want to enter in the cell. this will help you to not to delete the existing data it will combine the new value existing data.
please refer the below screenshot for your reference. thanks
hI try this
-read excel and save to datatable
-iterate trough datatable
-with assign activity
row(“rowname”).tostring =row(“rowname”).tostring+newvalue.tostring
THIS WILL ACT LIKE APPEND
-Update Ecxel using
Write Ecxel activity
regards
ahmad