How can add one by one add integer in web page

Help Activities
, ,
1

Hi,
In the web page, By using the get text get the integer value
How can i set the row numbers because this already in dowhile loop. So, the row counts was changing. So can plz tell me What I set in row Count to add the all integer values in a row?
And store the sum of the integer in variable

Can u plz give me a clarification for this?

2

Can u plz anyone rply for me?

3

Hi,

Could you please share the screenshot where you are trying to capture the integer value from website so that it would help the forum members to understand your requirement better. thanks.

4

@Rajiduraikannu_Santhosh_G

You can make Get Text value as Int as (Cint(GetTextVariable)+1).ToString

This will place inside the Do while statement

But I didn’t get what row number you are talking about

Better to give a Input & Output file required

Thanks

1 Like
5

It was the company websites so that i didn’t attach the screenshots

6

I explain the purpose of automate,

I want to adding the datatable values in a web page
ColumnName(Inventory) in this column add the all rows value and stored in the variable

7

@Rajiduraikannu_Santhosh_G

Can you datascrape the data and store that data into Excel? Then you can use as below

dt1.AsEnumerable().Where(Function(row).Sum(Function(row) Cint(row(“Amount”).ToString))

Hope this may help you

Thanks

8

Can u said another method sir, without store the data in Excel
Because this step was in between the dowhile its looping more then 20 times and the row counts also changing and the other reason I want the verify test cases by sum the values equal to Total values.

So, Can plz said the alternative method sir

9

@Rajiduraikannu_Santhosh_G

Then as it is in dowhile loop then use Assign activity as below

TotalSum = Cint(GetTextVariable) + TotalSum

Here TotalSum is a Int32 type

So every time get text gets the value it will convert to Cint32 and add to TotalSum

and Totalsum will store the actual sum

It’s difficult without seeing the input, but based upon your inputs I have given this

This may help you

Thanks

10

image
image867Ă—638 24.6 KB

I want to add Sheet1 (Inventory column) all rows but i didn’t know the number rows in there.
And if I get the sum of (Inventory Column) value.

And the next step the DoWhile Loop go to the Sheet 2,And add the Sheet2(Inventory column)

11

In the dowhile condition
I did’t know the how may rows in the Inventory column

12

@Rajiduraikannu_Santhosh_G

To know the how many rows in the Inventory Column

Use Read Range activity which will output a DatatableVariable

Then Assign activity

SheetIndex = DatatableVariable.Rows.Count.ToString

This will returns how many rows that sheetIndex you can place in DoWhile condition as example

CounterVariable <> Cint(SheetIndex)

Hope this may help you

Thanks

14

image
image351Ă—632 35.6 KB

Is this crt?

15

@Rajiduraikannu_Santhosh_G

In Read Range activity no need of “*”, you can remove that

So did you get any issue?

Let me know that

Thanks

16

image
image1838Ă—312 48.3 KB

The error was occurs in Data Scraping step

17

@Rajiduraikannu_Santhosh_G

Okay, I can’t help in that step, because as you don’t want to disclose the website

So, you can debug and fix and let me know if you are facing any issue in the next logic

Thanks

18

image
If I this (Read Range: Workbook Path needs to be set.) this exception was shown?

20

Hi @Srini84 ,
Can u plz rply me for this exception?

21

@Rajiduraikannu_Santhosh_G

Okay, If you have datatable directly from other source then no need of Read Range

Read Range will give when we don’t have datatable and we have to read the excel file

So skip that and use the datatable which you are extracting

Thanks

22

Hi,
The exception was clear
image

But, the Output value was 0?