How to do not delete Excel formula

Help
1

Hello community

I am reading an excel sheet using the read range activity, I modify the datatable, and write back in the excel using write range.

The problem is that all the formulas that are written in the excel sheet are deleted! Do you know how to tell uipath to read data and write data to excel without touching the formulas?

I tried to select “preserve format” in the read range activity but is not working.

Thanks a lot for the support

2

preserve format - will preserve the only format (font etc…) but not formulas.

If you want to preserve the forumals may be you have to write cell by cell.