Excel formulas in Text format

Help Studio
1

I am designing a flow with Excel, where I fill data in a data table and then I use the activity “Append Range Workbook” and i put the arguments as shown below

image
image905×656 25.5 KB

The data table has some columns that are formulas, and when I put that formulas in the Excel the formulas are written as Text, but the columns are in General format, I’m not sure what is the issue.

I’m using the package UiPath.Excel.Activities v2.23.4

2

@Giancarlo_Ramos_Espinosa

Only write cell or formula can write formulae to the fields in excel…you can ot do it with append range

One way you can do is to use auto fill range after append so that the formul would be filled for the new rows as wel

Cheers

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.