Hello.
In a cell of an Excel file the value is different by Formula.
After my knowledge, these are different properties of the cell.
And in UIPath, I think it should have to work in the same way.
When retrieving a value of a cell, just use the item property.
ColumnName can be also the name of an Excel range.
Your code string of the Item argument must be ColumnName
Formula is actually the value you want to get from cell.
myvalue = CurrentRow.Item(ColumnName)
Item gives the value of a column in a row, which is a cell.
This is when you read the formula in the first Excel file.
This value must be kept somehow in a DataTable, or a list.
When setting the formula, this happens into another Excel:
CurrentRow.Item(ColumnName).Formula = myvalue
I think this might have to be working.
Hope it helps, Adrian