Get rid of formula in excel and leave only its value

[dias97 (Dias Duisembayev)]

Good day, Community. I have an excel file where for example column A has formula. Now I want its value to stay same but get rid of formula (So user would not accidenlty change this document)
Is it possible to do it without excel application scope and without read range and write range sequence?

[Palaniyappan (Forum Leader)]

hope this would help you

Fastest way to write an excel formula into an entire column

Hello everyone, Is the Write Value activity the fastest way to write formulas in Excel sheets? I’m asking you this because as far as I know when we are using this activity, we need to iterate between the excel rows in order to fulfill each row with the proper Excel formula, which means that it takes some time if the excel sheet contains too many rows (an average of 1 second per row, to write a new formula on a specific column). If I use the Write Range activity, is there a way to accept f…

Cheers @dias97

[ashley11 (Ashley Nihal Dcunha)]

hi @dias97
this could be done using VBA i have attached the files for your reference.

New folder.zip (1.9 KB)

but there is a modification in excel

[etss1016 (Tao Tang)]

Yes，using invoke vbnet code in uipath.