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 ?
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
Have you had a chance to review this link?