How to Export Excel Formula into Value-Based Excel?

Is there any way to export an Excel file whose values are formula-based into an Excel whose contents are value-based?

Hi @incuesta

Welcome to the UiPath Coummunity.

You can try this method

  1. Read the excel file using the Read Range Activity. The output of this activity is saved inside a Data Table Variable.

image

Look at the properties panel of this activity

image

  1. Use Write Range Activity to write the Data Table into an excel File

image

image

Hope it works!

Attachment

Copy Excel.xaml (4.6 KB)