How to write an excel command in a datatable?

Help
1

So, I’m trying to make a cell that can sum a column. But i’m writing it in a Data Table and then putting in the Excel File. Is there a way to do this? Or I’ll need to write it in Excel directly?

Example:

image

2

Hi welcome to the community!
I hoping you mean excel FORMULA, if so, just use:
row("Column") = "=SUM(C2:C4)"

3

Yea, that’s what i meant, sorry.
But it’s not working here. It just gave me the exact formula in the space, not the result of it.

4

Is the column formatted as “text” in the Excel sheet? If that is the case, then this might work:

Changing excel cell format with UiPath

5

can you show how you are doing this, because it works well for me…

image
image1222×352 13.7 KB