Read Excel Row and Update after action

,

Hi Sir/Madam,

I have read in the forum for the question and noted that the write cell activity is used to update to Excel and a counter is used together with the cell address.

My question is, can the assign activity be used also ?
eg assigning the data captured and updating back to the cell name, after “for each row” loop process.

Kindly advise as I am very interested to learn how this can be done with UiPath Studio or using Dotnet.

@HENRY_CHAI

For Updating Row Value using Assign, check as below
https://forum.uipath.com/t/rpa-datatable-get-previous-row-column-value-set-to-current-row-column-value/256199/2

Hope this helps you

Thanks

Hi @HENRY_CHAI

You can update values in column using assign activitiy

Like

row(column name) = value

Thank You !!, Thank You !!, really appreciate your advise.

yes, i can use now the below, once the write range activity is done first

row(column name) = value

if the write range activity is not done, the assign activity cannot be used

Thank U again !!!

1 Like