sarathic
(Sarathic)
June 12, 2023, 9:21am
1
LoginFile
Use Excel File activity
Path: “path_to_your_excel_file.xlsx”
Read Range activity
Range: Excel.Sheet(“Sheet1”)
Output: dtCredentials
For Each Row activity
Save Data table Values: dtCredentials
Assign activity
To: Username
Value: dtcredentials.Rows(0)(“Username”).ToString()
Assign activity
To: Username
Value: dtcredentials.Rows(0)(“Password”).ToString()
Invoke Workflow File activity
WorkflowFileName: “LoginPage.xaml”
Arguments:
InUsername: Username
InPassword: Password
LoginPage
Use Browser activity
Open a browser to the login page
Type Into activity
Selector: Selector for the username input field
Text: InUsername
Type Into activity
Selector: Selector for the password input field
Text: InPassword
Main
Invoke Workflow File activity
WorkflowFileName: “LoginFile.xaml”
Arguments:
path: “path_to_your_excel_file.xlsx”
Invoke Workflow File activity
WorkflowFileName: “LoginPage.xaml”
Arguments:
InUsername: Username (variable)
InPassword: Password (variable)
Can Somebody Help to Resolve this When run the file it’s not type in the Username field
Hi,
With the help of writeline\Message box activity, please check weather value is present in the variable or not outside the invoke workflow activity.
NMallya_H
(NMallya_H)
June 12, 2023, 10:46am
3
Hi,
Please check if there is any variable named InUsername in LoginPage.xaml. There could be a case that variable is overriding the argument value (You can also check that using writing the values in console or message box).
Also, please cross check the selectors for type into. Try with click before typing checked.
Hope this helps!
2 Likes
sarathic
(Sarathic)
June 12, 2023, 11:16am
4
I Uploaded My File.
Main1.xaml (8.4 KB)
LoginPage.xaml (25.8 KB)
Login1.xaml (12.1 KB)
NMallya_H
(NMallya_H)
June 12, 2023, 12:56pm
5
I am not able to open the file could you please share the complete package?
@sarathic please zip whole package and upload
sarathic
(Sarathic)
June 12, 2023, 1:45pm
7
Hi
This is my zip file. Hope this is can access.
BlankProcess1.zip (21.5 KB)
@sarathic Did you try with “Strict Selector” instead of fuzzy and other. If you are not getting error and its not writing then please change selector type
@sarathic share screen of google where you want to write. I am testing my end
@sarathic Select Strict only from “Targeting Methods”
sarathic
(Sarathic)
June 12, 2023, 2:54pm
12
Hi @raja.arslankhan
I want pass the value to gmail username and password.
sarathic
(Sarathic)
June 12, 2023, 2:56pm
13
I Changed it, but nothing happen
@sarathic show me fields (screen shot) where you want to enter username and password
@sarathic
Do you want to write here?
sarathic
(Sarathic)
June 12, 2023, 3:04pm
16
yes. I want get email data from the excel.
As my structure.
@sarathic Here is one question?
is it necessary to achieve your task by this? By the way you can get attachments/mail message by
using mail activities
sarathic
(Sarathic)
June 12, 2023, 3:13pm
18
Yes. This is sample account I get. I pass variable to type into activity. I just need to login that page as this way.
And I want to maintain 3 separate files as in my project.
I am beginner for UiPath.
@sarathic ok …Here you can see data in username is Null.
Need to check previous module
sarathic
(Sarathic)
June 12, 2023, 3:25pm
20
Hi ,
Then can’t read the excel file.? Even I pass the values. Is there anything wrong ?
I am really appreciating your support.
@sarathic I am looking. I will update u