Data

[Ak_4]

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.

[sarathi125 (Parthasarathi)]

@Ak_4,

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.

[Gokul001 (Gokul Balaji)]

HI @Ak_4

Try with this following

1. Use Read range activity → Store it as dtConfigExcel

2. Use Assign activity

Create a new Dictionary for storing Excel key/val from Config.xlsx datatable

dictConfig = New Dictionary(of String, String)

3. Use For each row in data table activity

4. Use If activity → Check the column is empty or not

not String.IsNullOrWhiteSpace(CurrentRow("Name").ToString.Trim)

5. Use Assign activity

Add Key/Value pair to New Dictionary

dictConfig(CurrentRow("Name").ToString) = CurrentRow("Value").ToString

6. Use Assign activity → set variables based on Config.xlsx name/value

Hope it will heps

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

@Ak_4
Refer to this video, You may get Some Idea

How to use a Config file in UiPath - Tutorial