Write Cell Activities

Help Activities
, ,
1

Hi, for the context, I am scraping Excel-based data with for each row and will write the scraping results using write cell, but when there is an error while scraping, the UI path does not skip the error row and leaves the row empty. so that for the next process when automation searches for data in the next row, it will fill in the previous row where it is not quite right. is there any way to solve this? thanks in advance

2

@Bintang_Bintang

Try this :
→ Wrap your scraping code in a try-except block to catch any exceptions that may occur.
->When an exception is caught, instead of leaving the cell empty, you can write a default or error value to the cell. This will ensure that the downstream processes can continue without issues.

HAPPY AUTOMATION!!

3

Hi, thanks for the advice. do you have any videos or picture that have a same issue/solution? i’m very new on this automation and neede a visual tutorial. Thanks in advance.

4

@Bintang_Bintang

Use can refer to this :

Hope it helps!!

5

@Bintang_Bintang

check for excel related activitys

6

@Bintang_Bintang,

Share your code screenshot so we can suggest where you will have to add this logic.

Thanks,
Ashok :slight_smile: