@Nguyen_Van_Luong1
You’re very welcome!
Main - Clone.xaml (38.7 KB)
You can check it
1 Like
I appreciate your kindness once again. However, the location where “today” needs to be recorded is not in “Check.xlsx,” but in “news.xlsx.” Could you please provide guidance on how to accomplish this?
I apologize for causing confusion due to my insufficient explanation.
Can you share input “news.xlsx”?
1 Like
@Nguyen_Van_Luong1
I’m truly sorry. Here it is
Check(input).xlsx (10.0 KB)
News(out put).xlsx (13.8 KB)
OK, I will try it in step fill blank
then in case access web you test
I will test with this files
1 Like
I see News.xlsx file
the red text is position you need write
I want to know, write in News.xlsx is after or before access website
I think after access website
that’s right?
1 Like
@Nguyen_Van_Luong1
If a blank is detected in check.xlsx, “today” should be written in news.xlsx without accessing the website! If my explanation was insufficient, I will be sure to provide a more detailed explanation! Thank you!
Yeah, image is clear
I was thinking the same thing just now, so nothing has changed, finding and writing blank cells is the same.
We will write it after we finish accessing the website and have the file New.xlsx
we will deal with this file, so we don’t need to care about Check.xlsx anymore
I will fix Main_clone in this direction
1 Like
@Nguyen_Van_Luong1
You’re welcome for your kindness!
Thanks for waiting me,
This is file New.xlsx
suppose,
after getting the not null values in the file Check.xlsx to access in Website
we have this file New.xlsx
then I find blank position in New.xlsx and fill them with your rules
we have output
my code
Main - Clone.xaml (42.0 KB)
You can check end edit with your file
regards,
1 Like
@Nguyen_Van_Luong1
Thank you for your code.
However, this code encounters an error if empty cells in Check.xlsx are being modified.
Could you please guide me on what I should do to address this issue?
Can you share image about error?
Have you closed file before run robot?
1 Like
Can you share file after access website?
1 Like
Problem is file not have blank row to file " today", …
that’s right?
I know you have a input file,
check row not empty go to https://www.naver.com/
else fill “today”, …etc
But I see 1 value at input file have a data table form web with extract data
that’s right?
and you can check range after extract from web, count value to have blank cell
1 Like
Main - Clone.xaml (45.4 KB)
You can try it
1 Like
You are a genius But I can’t keep up… What’s wrong with this?
In https://www.naver.com/
you extract data table have 4 cloumns
that’s right?
If it’s right
you can try , I modified
Main - Clone.xaml (47.1 KB)