In my excel: some columns contain formulas and some columns don't. Formula columns should update as per formula, other columns normal?

In my excel: some columns contain formulas and some columns don’t. While I am automating normal columns should get updated with values and formula applied columns should update as per formula?

Any advice to this kind of issue.

there is a new property called " PreserveFormat(slower)" enable this and try,

What is your need here.? Write to other excel? or copy one sheet to other.?

1 Like

“PreserveFormat(slower)” property is available in UiPath or Excel ?

I need to copy data from pdf and copy into excel on daily basis. This formula contained columns should work as per formulas. How can we do this kind of situation?

Property is in uipath.

If possible can you send me .xaml file on my scenario, that will be appreciated.

You said u need to copy data from PDF then paste it in excel, and excel will contain formula?? Do you have excel template?? I don’t have any xaml ready with me regarding this scenario…