How to Get only Total value in Excel

Help Studio
, ,
1

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.

total

2

Hi,

Hope the following helps you.

img20210511-6
img20210511-6710×662 16.3 KB

Sample20210511-3.zip (9.9 KB)

Regards,

1 Like
3

@nithya,

  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
4

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