I have dates in config file of every thursday of a week. I need to use that date in my bot how to do it in uipath.
In general you can use
Config("YourConfigName").ToString
If you have multiple config values for the Thursday then you have to read it dynamically or based on the current date.
HI @Ak_4
Try with this following
-
Use Read range activity → Store it as
dtConfigExcel
-
Use Assign activity
Create a new Dictionary for storing Excel key/val from Config.xlsx datatable
dictConfig = New Dictionary(of String, String)
-
Use For each row in data table activity
-
Use If activity → Check the column is empty or not
not String.IsNullOrWhiteSpace(CurrentRow("Name").ToString.Trim)
- Use Assign activity
Add Key/Value pair to New Dictionary
dictConfig(CurrentRow("Name").ToString) = CurrentRow("Value").ToString
- Use Assign activity → set variables based on Config.xlsx name/value
Hope it will heps
Regards
Gokul
@Ak_4
Refer to this video, You may get Some Idea
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.