How to remove formula from excel in Uipath

How to remove formula from excel in Uipath

Hi @T_Y_Raju !
Do you mean removing formula everywhere in the excel file (so in all the sheets), or do you want to remove formula in one specific cell ?

specific cell

Use read range to read the whole datatable …delete the excel and use write range to write the datatable to the new excel

Ok do you mind sending me a dummy file with the formula you want to remove ?

like sum formula =(B2+S2)

RemoveFormula.xaml (4.6 KB)
Please check this. This can be achieved with read cell and write cell activities

Hi @T_Y_Raju,

Have you had a chance to review this link?

Get rid of formula in excel and leave only its value - Help - UiPath Community Forum

Regards,
MY