How to Read Excel without losing the formula

Help Studio
1

Hi I have different excel that contains different Formula

Please see the diff formula below

An Excel sheet tabulates various hours, rates, and totals with a focus on calculating regular and overtime rates. (Captioned by AI)

image
image749Ă—126 4.04 KB

any advise, will the high appreciated
Thank you

2

Hie @Vincent_Nuestro try to enable the preserve format in the activity …
like this

3

@singh_sumit

i tried this but after Write Range lose every formula

4

That’s because you’re writing values to Excel instead of writing the formulas.

5

any recommendation? or sample workflow?

6

use read cell to read each cell to preserve it formula and also use the write cell activity to write data that way you can do… use the loop method to iterate the data one by one
cheers Happy Automation…

7

You shouldn’t be writing to columns that use formulas, if you can avoid it.

If you can’t avoid it…

https://forum.uipath.com/search?q=write%20formula%20to%20excel

8

That’s an extremely inefficient and tedious suggestion. There are much better ways to handle it.

1 Like
9

Itried this method

But it returns as a Plain String.

This image depicts a UiPath workflow for iterating through each row in a data table, performing calculations, and writing the results to an Excel workbook. (Captioned by AI)
This image depicts a UiPath workflow for iterating through each row in a data table, performing calculations, and writing the results to an Excel workbook. (Captioned by AI)519Ă—683 25 KB

“=”+rowOT_Savings(13).ToString +“/”+ in_Config(“OT_Savings”).ToString.Replace(“$”, “”)

10

You’re using Write Range Workbook. You need to use the Excel activities.

Also your Write Range should not be inside the loop. You should loop through all the data and make the necessary changes, then after the loop you write to Excel.