How to calculate excel

I want to know how to calculate excel.
Please let me know.
Thank you.

We can do the same @BoBou_JunG I mean, sending the excel inbuilt functions to get the sum

  1. Read the excel and get the last row count as rowCount = datatable.rows.count
  2. Then in the same excel application scope, use write cell activity as formula, as

"=SUM(D2:D" + rowCount.tostring + ")"

the range to the write cell activity will be “D” + (rowCount + 1).tostring which will write the sum in the last row fter the data

Thank you so much .:slightly_smiling_face:

Happy to help @BoBou_JunG