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.
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.
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
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)
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
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