How to remove formula in excel I need only the Value for the future calculation, if the formula is their means bot is not able to read it

Help Activities
, ,
1

Please provide a solution

1 Like
2

Hey @Gopikrishna_S

Which activities are you using to perform Excel Write operations ?

Thanks
#nK

3

@Gopikrishna_S

  1. Use Read Range activity to read the data from Excel file and will give output as DataTable. Let’s say dtInput. This activity helps you to read the data only without formula.

  2. And then use Write Range activity and pass above DataTable to write it back to sheet.

4

Hi @Gopikrishna_S
The best option is copy the data to different sheet or excel

So use Excel read range activity - store the output to a Datatable

Next use write range Activity, pass that output Datatable and provide your desired location/filepath

Thanks

5

Workbook Write range