The given key not present in Dictionary

Help Studio
,
1

Hi,

Can Anyone help me please.
Tried so many times. Still couldn’t figure out where the error is.

Trying to read data from excel and print data from excel in REframework

while reading data from excel from config file, its giving me error.

Here are my workflow screen shots

error1
error12880×1620 201 KB
error2
error22880×1620 172 KB
error3
error32880×1620 201 KB

2

Well, my guess is maybe you have some blank space in your excel cell there…

3

Also, check for any other references to your dictionary. It may be a different key causing the error.

4

Hello,

Can you run it in debug mode and show us the “content” of in_Config, please?

5

Try putting double quotes in the Value tab of your excel.
You may want to try removing the extension from the name of excel file.

Try Logging with config values to confirm that the config is being read properly.
If yes, try adding another read range with another excel file placed inside the project folder.

6

error4
error42880×1620 195 KB

7

@saritha,

thank you. In order to see the values, could you please expand the display until we can spot anything interesting?

EDIT: I don’t have my studio here to check but I guess your dictionary is empty. You might want to check if the result of InitAllSettings is passed as expected to your in_Config.

image

8

error5
error52880×1620 197 KB

9

EDIT: not saying that there is no dictionary but that your dictionary is empty.

EDIT 2: Please run the project in debug mode (F5)

Yes, that’s the case. Check in your Init state that by accident the Config value is not lost. You could also add an invoke workflow with InitiAllSettings just before using in_Config to see if the problem is not at InitAllSettings level

image
image

10

No Spaces in config Excel file for

error6
error62880×1620 170 KB
InputFile

11

I didn’t get it exactly where i need to check it.

Thanks.

12

Go to the InitAllSettings file and debug from there, something may be wrong and your config file is not read at all…

1 Like
13

@saritha

In read range remove the range as “A1” it should be nothing

image

Hope this helps

Thanks