Excel automation using studiox

Help StudioX
,
1

I have this excel sheet and I have to get only the total value of 56$ and I need the count of total values for ex: in this the count is 3 how to approach this in studio X

A spreadsheet displayed on a screen contains columns labeled "Reportid," "class," and "mail," along with some totals and calculations. (Captioned by AI)
A spreadsheet displayed on a screen contains columns labeled "Reportid," "class," and "mail," along with some totals and calculations. (Captioned by AI)2268×4032 2.14 MB

2

@govindreddy_nagireddy

I see many totals there how do you know only specificc total?

Cheers

3

Actually the first total I need which is 56$ and next total values are sum of the above ie28,28 instead I mentioned 13,13 and I need the count of all those total values

4

@govindreddy_nagireddy

Can you please be clear and elaborate

Cheers

5

I need the first total I.e 56$ that I will be updating in another excel and the other information I need is the count of total values in this image we have count of 3 let me know if this is understandable or else will post an excel photo

6

@govindreddy_nagireddy

  1. Find /replace actvitiy and find the value total.
  2. Once you find total…add one number to it to get the next row
  3. Now to get count…use for each row in excel and start with the cell next to the total cell and count till you get a blank value

Cheers

7

Count part not able to get it?

8

@govindreddy_nagireddy

For the count …ideally it start from the total row

So use read range activity and gice the cell number as the total cell then it eould read till the end of that table from which you can do dt.Rowcount

Alternately as mentioend above run a loop and keep on incrementing the row number and get the value till the value is null…which gives the count

Cheers

9

Hey Anil, I got the total value but count I am unable to get it

10

@govindreddy_nagireddy

I hope you got the total by findign total keyword then added 1 and got the value

now you need to decrease 1 from the column index and then use read range

cheers

11

This image shows a flowchart from a program with a conditional IF statement, setting variable values for "Currentrowindex" and "ValueTotal" based on specified data conditions. (Captioned by AI)
This image shows a flowchart from a program with a conditional IF statement, setting variable values for "Currentrowindex" and "ValueTotal" based on specified data conditions. (Captioned by AI)2016×1512 1.02 MB

This is the method I used to get the amount and stored in valuetotal. After assign do I need to use read range

12

@govindreddy_nagireddy

can you do the row count of dtoutput once

cheers

13

I am getting row count as 17

14

@govindreddy_nagireddy

that good

looks like you read whole of the table now

now save the currentrowindex+1 value to index variable

use a while loop and give condition as booleanvariable

set the value of booleanvariable to true before the loop

now inside loop use if condition to check if String.IsNullorEmptydt.Rows(index)(0).ToString.Trim)

on then use assign and assign booleanvariable to false

on else side use count = count+1

count is a integer variable

cheers

15

While loop is not available in studiox

16

@govindreddy_nagireddy

Please select filter option in activities and select developer

Cheers