How to Get only Total value in Excel

Hello All,

I want to get only Total value from excel

For Example in Column G if AAABNERSUPPL Total… Then I should get the Invoice Amount from Column I. Similarly for all the Total…

a screenshot is attached for your reference,

Thanks in advance.



Hope the following helps you. (9.9 KB)


1 Like


  1. Read I column only using read range activity and will get output in datatable,
  2. Use read cell activity and provide in range property as “I”+(dt.rows.count + 1).tostring
  3. Read cell activity’s output is in String and use it further.
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.