How to calculate excel

Help
#1

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

image
image1300×602 204 KB

#2

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

#3

Thank you so much .:slightly_smiling_face:

#4

Happy to help @BoBou_JunG