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