ADDING TEXT TO CELL WITH OUT DELETING THE VALUES IN THE CELL

Help StudioX
1

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.

2

Hi @nawaf7456 ,

just thought from my side. please try and let us know if it helps your requirement.

  1. Use excel file activity and assign your excel file path.

  2. 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).

  3. 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

image
image422×571 14.5 KB

3

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