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

Ask in Your Language Korea RPA 개발자를 위한 공간
,
1

엑셀 공백 셀에 원하는 문자를 넣고 싶습니다.
예를 들어 if 문으로 1번 엑셀에서 공백을 확인 하면 2번 엑셀에 오늘이 적히고
반복을 돌다가 다시 1번 엑셀에서 공백을 확인 하면 2번 엑셀에는 내일 이라는 문구가 적힐 수 있게 하는 방법이 있을까요? 미리 감사드립니다.

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

1 Like
3

@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?

4

Yes, it is possible, if we have a rule of writing in the cell

1 Like
5

@Nguyen_Van_Luong1
I’m still a beginner, so could you show me the code as a screenshot?

6

To clear more your requirement , can you share screen short about sample input and expect output ? I will code flow it

1 Like
7

@Nguyen_Van_Luong1

thank you. Are you saying it like this?

image
image846×644 29.9 KB

8

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?

1 Like
9

@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!

10

I see, but I want know what’s value in 4th blank, 5th…
they are “After”
that’s right?

1 Like
11

@Nguyen_Van_Luong1

yes!
image

It feels like repeating in this manner!

Thank you for your kindness!

12

my input

image
image471×729 22.5 KB

my output
image
image516×694 24.4 KB

Are your expect output?

my code and my file to this in/out
Geuncho.xlsx (8.4 KB)
Sequence.xaml (18.1 KB)

1 Like
13

@Nguyen_Van_Luong1

image
image855×556 22.4 KB

image
image661×599 23.4 KB

output
image

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?

14

@geuncho

Can you please tell why are you using use excel and excel application scope as well

Cheers

1 Like
15

@Anil_G
Because it needs to be executed on two separate Excel files, not just one.
Could you please share what the issue is?

16

@geuncho

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

1 Like
17

Can you share your input?

1 Like
18

빈프로세스2.zip (78.0 KB)
Is it okay to provide it like this?

19

@Anil_G
빈프로세스2.zip (78.0 KB)
Is it okay to provide it like this?

20

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
image

I will clone your Main to edit
then send to you

1 Like