How to remove formula in excel without changing values?

Hello,

i am applying formula in excel using UiPath.
but when i am deleting som columns then values are changing.
i need to remove formula and keep values as it is.

i need to remove formaul and keep all values even though i remove any column then also as it is value i need in each row of hour total which is 198

@Mathkar_kunal,

Try reading the data using Read Range activity and use Write range to just write it back. Make sure you are disabling PreserveFormat while reading.

You can use wrtie range for wrting data and disbale preserve formatting

1 Like

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