How to store the the scrapped value in a new line in excel file?

image

1.Searched the value (ABCDE) in website.
2.Get the result and store it in the excel file.(B2 cell)
3.Go back searched the (LMNOP) in website.
4.Get the result and store the value in scrapped column. (B3 cell)
But the value overhere gets replaced in B2 cell. Which command I should write to store the value in new cell.

Use write cell activity where you can mention a counter variable.
Range = “B”+counter_variable.

Initialize it will default value as 2 and increment the value after Write cell activity

1 Like

if you are using write cell you can increment the number of cell, for example b+counter and increment the counter

1 Like

Hi @VIDIT_ZALA

You must be using ForEachRow Activity. Within that you will see the properties panel der is output section which gives you the index. SO declare a variable der as follows.

And within Write Cell Activity just mention as i have shown in the below SS
image

This will get the current row value index that you are searching for in the website and will append it to the Scrapped column for that same row

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes

@Pratik_Wavhal
Can this work in Write Range activity?

Hi @VIDIT_ZALA

See below img
image
Write Range activity requires the datatable

So it depends on the data what you are extracting. If you are extracting the data that returns the data table then its ok to use Write Range Activity.

If as per the eg you gave der is only one value which returns String/Text that you extract and write it into a particular cell then you must use Write Cell.

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

@Pratik_Wavhal
image
1.I have created the flowchart of the process where in Read Range activity we read the excel data.
In read range activity I have used ReadDT as output variable.You can see in the below image.

2.Open browser contains the login process.

3.For each row does the main process where I am facing the issue.Check the below image for better understanding.


image
image

Hi @VIDIT_ZALA

The thing you have done is totally right. I dont see any issue der until now.
The way it should be is der already.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Hi @Pratik_Wavhal
Thanks for reply but I am not able get my desired output.
All the values get replaced in B2 cell.

Hi @VIDIT_ZALA

So as i previously said you that will be better as per my experience
dummyVariable will be the datatable variable you got from extracting data from website
image

One by one it will write into cell in the increment way

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

@Pratik_Wavhal Thank you for help I have achieved what I was looking for :grinning:

Hi @VIDIT_ZALA

Glad that it helps you

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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