Update value to an existing column in excel

Hi ,
Can anyone help me.
Im trying to update Balance of an User Account and wants to replace the updated value to existing value
in Excel.
May I know how to do it please.

Hi @saritha,

  1. Take an Excel application scope and read the Excel.

  2. Take an write cell activity , pass the sheetname , cell and updated value.


Mukesh

1 Like

Just use the below code in your assign statement,
Datatable(rowAsInt)(“ColumnName”) = YourValue.
and after updating Write Range the datatable.

1 Like