Getting error while running Modern Use Excel File

Help Studio
, ,
1

Getting error while running Modern Use Excel File,

please find the given ss

image
image1224×276 20.6 KB

if i indicate the path directly its working , but while i am giving from config its getting this error but from config also i checked by using message box the path value is same

thank you!!!

2

Hi

Config path is not in the right pattern
Check that once and your issue will get resolved

There is some illegal or special character in the path
That’s the issue
If you are formulating inside the code before this use excel file activity use a WRITELINE activity and pass that same filepath as input
And check what is missing with path

Cheers @vineelag

3

i checked it by using message box its showing the correct value,

i copied the path from config and run it, its working,

while taking from config only its not working

4

Hi

It may be better to check your string more exactly. Can you check and share result of the following expression using MessageBox etc.?

String.Join(",",Config("yourKeyName").ToString.Select(Function(c) AscW(c).ToString))

Regards,

5

It clearly says there are illegal characters in the path. What value do you have in the Config file?

6

Hi @vineelag ,
You can use message box check path file by config
I think it’s not right?