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]

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

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.

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

How to write an excel command in a datatable?

jrobot February 3, 2020, 7:35pm 4

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

Topic		Replies	Views
How to get sum of excel column Studio uiautomation	5	1017	September 25, 2022
How can I get sum of columns and write other worksheet? Studio studio , question	3	303	October 29, 2023
Putting formula text in a DataTable Help datatable , excel	5	5726	May 11, 2017
Data table sum into a cell Help datatable , excel , uiautomation , activities	4	4758	April 30, 2018
Insert excel formulas from Datatable into Excel as formulas and not as strings Help	2	6574	March 21, 2018