엑셀 공백 셀에 원하는 문자를 넣고 싶습니다.
예를 들어 if 문으로 1번 엑셀에서 공백을 확인 하면 2번 엑셀에 오늘이 적히고
반복을 돌다가 다시 1번 엑셀에서 공백을 확인 하면 2번 엑셀에는 내일 이라는 문구가 적힐 수 있게 하는 방법이 있을까요? 미리 감사드립니다.
Hi @geuncho ,
You can use Read range to get data table
for each row in data table
if row(“namecolumn”) is empty → assgin row(“namecolumn”)= “tomorrow”
after loop write range
to detail, You can share input and expect output?
regards,
LNV
@Nguyen_Van_Luong1
Thank you for your response. However, what I want to do is to have ‘Today’, ‘Tomorrow’, ‘Day After Tomorrow’ sequentially entered into the empty cells. Is this possible?
Yes, it is possible, if we have a rule of writing in the cell
To clear more your requirement , can you share screen short about sample input and expect output ? I will code flow it
OK, it’s very clear
I understand what you mean,
what’s value after ‘Day After Tomorrow’ ?
in case I understand there are more than 3 blank positions,
then they are all “after” right? or according to what rules?
@Nguyen_Van_Luong1
The position of the blank is always random! ‘Today’, ‘Tomorrow’, and ‘Day After Tomorrow’ are just one example. Other words can be inserted. Thank you in advance!
There can also be multiple blank spaces!
I see, but I want know what’s value in 4th blank, 5th…
they are “After”
that’s right?
my input
my output
Are your expect output?
my code and my file to this in/out
Geuncho.xlsx (8.4 KB)
Sequence.xaml (18.1 KB)
output
Thank you very much. When I applied it to my code, I’m getting this kind of result. Could you please help me identify what might be the issue?
@Anil_G
Because it needs to be executed on two separate Excel files, not just one.
Could you please share what the issue is?
Can you shre the xaml or project you created…why not use two use excel file activities?
As per previous screenshot looks like only one file needs to be updated
Cheers
Can you share your input?
Hi, I compare have some differ with my way
I used intCount to count number of blank position
and intIndex to get index in excel
→ with your file I have output
I will clone your Main to edit
then send to you