How to update column of existing excel


I have a requirement to update the column of existing excel. I am able to copy the content of the excel in the data table and create a new excel using it as expected. But I am not able to update the column of the existing excel.

Please advise.


@chandravadanj Hi,
Use Read range activity to read the excel and set output datatable to a variable(DT).
then use foreach activity,
foreach row in DT
assign index= DT.rows.IndexOf(row)+2
Next use write cell activity and set the range as “K”+index.tostring.
(if you are trying to write into K column

Thank you @shibani , I am able to update the existing excel using the logic provided.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.