Hi @doosanhero6 ,
My step
1-read file to get data table
2-use open browser
use for each row in data table
type into row value to website
send hot key with key enter to down line
hope it help,
hope it help,
1 Like
Thank you so much.
This is the goal I wanted.
Thanks to you, it’s solved! 
If you don’t mind, can I ask you again if I have any questions next time?
1 Like
Yeah, Ask me anything about RPA and UiPath, I’m ready to help you
pls mark it as solution, to close thread
happy automation @doosanhero6
1 Like
혹시라도 For each가 싫으시고, 원본 데이터테이블 자체가 컬럼이 1개밖에 없다면 Output Data Table 액티비티를 사용하는 것도 간편한 대안이 될 수 있습니다.
대신 컬럼명이 같이 튀어나오기 때문에 첫번째 줄을 지워주는 처리가 필요합니다.
Output Data Table 사용한 샘플입니다.
원본 데이터테이블이 좀 복잡한 경우에는 String.Join과 Linq를 잘 혼합하면 특정 열들만 하나의 String으로 가공 가능합니다.
샘플 소스 및 DT 예시 입니다.
타이핑내용은 result라는 이름으로 변수 생성해서
result=String.Join(Environment.NewLine, DT.AsEnumerable.Select(Function(row) row(0).ToString) ) 로 Assign 했습니다.
Type Into 결과입니다.
참고 바랍니다.
1 Like
안녕하세요.
도움 주셔서 감사합니다.
가이드 주신대로 적용해보니 잘 작동됩니다.
For each 때문에 작동시 한셀 한셀 돌아서 처리 속도가 느렸는데 이 방법대로 하니 상당히 빨라졌어요!
그런데 열에 있는 모든정보를 불러오지 않고 엑셀에 필터를 적용했을때 보여지는 데이터만 불러오는것도 가능할까요? 시간이 되신다면 알려주시면 감사하겠습니다!
Hello
Is it possible to have the data in a specific column call up only filtered data?
I don’t know how to use this activity 
Could you tell me how to use it as a sample file or as an example?
My input
I will filter to get value “a”, we can get more value, eg: a,b,…etc, what value we need
my output
1 Like
You’re amazing!
It worked out right away.
Thank you so much, teacher
1 Like
Cheer bro @doosanhero6 ,
Ask me anything about RPA and UiPath, I will help with all my exp
1 Like
I don’t understand the output you want,
that is, take the values contains a,b,c,d…
if get all value contains them use filter data table
Or take about the first 5 items
you can use
Dt2 = Dt1.Clone Dt2=Dt1.AsEnumerable().Take(5).CopyToDataTable()
1 Like
이해하기 쉽게 표현하는게 어렵네요…
이미지 예시로 드려봤습니다.
a
b
c
d
여러 데이터 중에 예시로 ‘b’ 만 필터하여 입력하려면 어떻게 세팅해야 하는지 궁금합니다.
이미지 처럼 저런 형식으로 하니 동작이 안되네요
Can you share your input and expect output
eg:
input
output
and in filter have many option
if choose “contain”
→ it will choose all map with
eg: contains “a”-> it will select : a, ab, aaa,…
pls share input and expect output to have best solution
regards,
1 Like
Let me give you another example
a
b
c
d
From a pile of Excel data
When you filter b in Excel
“Enter only the data you can see.” I really want to do that.
Oh, so easy, you keep 2nd row only
like this
output
1 Like
If you want add filter to excel file
from
to
you can open this file, then send hot key citrl+shift+l
1 Like
Yes, I know that.
What I’m curious about is
In my file, like the 4th week of July, 1st week of August, 2nd week of August, 3rd week of August
The data is accumulated
There are times when I only need the data for the 4th week of July,
Just like if you need a three-week tater in August
Is there a way to configure it in a fluid way?
We can add if before filter
You can share sample input and output?
I haven’t seen the weekly data above,
it makes me feel confused
1 Like
It’s not easy to share using text or capture
I’m at a loss,
The current situation
I only want to filter the “c” data and print it out
It is a problem because data is retrieved from the first cell in turn, as shown in a → b → c, and unwanted data is output.