Update value to an existing column in excel

Help
, ,
1

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.

2

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
3

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

2 Likes