Hello Experts,
I have extracted data using Screen Scraping and Gettext activity ( both are inside a foreach activity). I want to write this data in a excel sheet.
The first time when I run, the data is written in the 1st two rows but next time when it runs again I need data to be written from 3rd row and so on. But its not working in my case, its overwriting on previous data in excel.
Can someone please help me with the solution. It’s urgent.
Thanks in Advance.
Hi @sowmya.krishna ! 
What do you use to write your data ? Are you using write range ?
If yes, what about you try to use append range ?
Let us know if it works for you !
Hi Hiba Beldi😊,
I am using write cell. Since am using both gettext and screen scraping for data extraction, I’llbe getting output as a string. I cnt pass my output to append range.
use if activity to verify iteration Ex: if it was a first run use Write range activity or else use append range activity
Hi @sowmya.krishna !
Do you mind sending us your current workflow ?
Because of the fact that we are not dealing with a datatable, we could go for working with incrementation of your writing starting cell coordinate.
To help you, we will need to see your code, otherwise we can’t help that much 
Hi Hiba_B,
I cant attach my actual workflow. Its having some confidential data so.
I just tried to attach the similar kind of flow where am using gettext, screen scraping and data scraping for data extraction and need to write the same in a excel one row after the other.
Testing.zip (15.5 KB)
Thank you.
Hi @sowmya.krishna !
Thank you for your code
Would you mind testing with the following changes ? Sequence1.xaml (19.7 KB)
I did not run it so hoping it runs without issues. If it does not work let us know !
If the code is unclear, let us know too so we give more details 
As of understanding you want to write the scrapped data into excel right ??
In that case you need to use write range activity not write cell activity
I modified your flow , once again run the flow and tell us whether you got output or not
Testing (2).zip (15.7 KB)
Thanks,
Robin
Hi @Robinnavinraj_S !
She will have the same problem: at the second time it will overwrite the data written 
I totally agree with you that write cell is not the best solution here.
In her case I think it’s better to use append range.
[EDIT] or using write range but with a dynamic starting cell
Hi @Hiba_B
I already suggested append range activity above, but when i saw her code there is no looping statement in that code , thats why suggest write range activity
if the process runs recursively then we must go for append range
Indeed ! I did not see your post specifying it, sorry 
I was also wondering where is the loop part (except in the Main, but there are no in/out argument with sequence1).
But because she said that she reproduced a similar xaml kind, and seeing her first post speaking of overwritten data, I assumed that she did not fully succeeded into reproducing the similar kind workflow 
Let’s wait her info
My process runs recursively. And as suggested by both of you append range is working perfectly with the flow and am able to get desired output.
Thank you,
Sowmya
Hi @Hiba_B 
I have followed your changes and checked with my flow, it’s working perfectly. Thank you for the solution
Regards,
Sowmya
That’s great !!
Don’t forget to mark your topic as solved so the others stuck with the same problem find it easily
Happy automation and happy new year !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu