엑셀 공백 셀에 원하는 문자 넣는 방법 문의

@Nguyen_Van_Luong1
You’re a genius!!! Thank you so much, I’ll wrap it up! Have a great day!

1 Like

Thanks @geuncho ,
Happy automation !
have nice day!

1 Like

@Nguyen_Van_Luong1
I apologize for asking again. What should I do if it starts with a space? It’s causing an error.
image

Hi @geuncho ,
because file “News(out put).xlsx” is not available
we can add step create file “News(out put).xlsx” before
It will ok
You can check it
Main - Clone.xaml (48.9 KB)

1 Like

@Nguyen_Van_Luong1
Error message: There is no range for a0
However, I’m still encountering errors after adding. Is there any solution?
image

Or simple is we can check data in file “News(out put).xlsx” before
if count = 0
we assign =1
because Excel start 1
Main - Clone.xaml (51.8 KB)

Ok I see it, I updated, you can try newest update
Excel cell from 1
we can check data in News.xlsx
if it = 0
we can assign = 1
Main - Clone.xaml (51.8 KB)

1 Like

@Nguyen_Van_Luong1
I apologize to you. The mentioned error has been resolved, but there are no spaces in the cell. Is there a solution?

I think append range over write in blank row
Can you tell me know in step click and extract data in web?
then send me input file, I will check detail it to have best solution
image

1 Like

@Nguyen_Van_Luong1
I use the activity called data extraction!
image
Check.xlsx (9.9 KB)
this is input file

Yes, I see you use data extraction, but in step click, I want to know image about button it click to test full step in my PC
this is image after robot search kt


where is robot click?

1 Like

@Nguyen_Van_Luong1
I apologize for the confusion. Are you referring to this?

OK, it’s what I need

1 Like

@Nguyen_Van_Luong1
I appreciate your kindness!

Sr for reply late, because I have online meeting with customer
my output


my input

my code
naver.xaml (58.5 KB)
you can check it,

1 Like

In some cases, if it is not convenient to publicize file information
you can send me by message

1 Like

@Nguyen_Van_Luong1
You’re very welcome! No need to apologize for the delay. Everything seems to be running smoothly, and you’re doing great. Have a wonderful day!

OK, thanks @geuncho
Let ask me if you have any questions

1 Like

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