Illegal characters in path in write range activity

Hi Guys,
I’m facing issue while writing the data to the excel.
when i hardcoded the path in write range activity, it is working fine.
but when i tried to store the path in variable and when i try to use the variable, the issue is popping out.
this is the path called from an asset and storing in a variable
“E:\Automation Data Files\Bank of Baroda\Currentstatus\Updated_current_status.xlsx”
requesting anyone’s help here.

Thanks in advance,
Naveen Kumar

HI @naveenkumarr

Check out this thread

Regards
Gokul

1 Like

Hi @naveenkumarr
Replace single slash with double slash in path string
variable
“E:\Automation Data Files\Bank of Baroda\Currentstatus\Updated_current_status.xlsx

@sangeethaneelavannan1 ,

No luck, still the same issue.

I have added trim function too, it ain’t working :confused:

Share the screenshot of the activity?

hhshshshshs


this path is stored in asset and called using config
“E:\Automation Data Files\Bank of Baroda\Currentstatus\Updated_current_status.xlsx

Can you print the Asset value in the log message and share the screenshot @naveenkumarr


@Gokul001 sure

1 Like

Why do you have two \\ in the path

image

@naveenkumarr

i just replaced single slash with double slash and tried as @sangeethaneelavannan1 said.
but i’m not using the double slash path, just tried with that one

Just Pass the path directly in write range activity and try it @naveenkumarr

it is working by hardcoding the path in write range activity

Hi @naveenkumarr

Please click on info beside your log message and see if any character is different . or post a screenshot

cheers

Hi @naveenkumarr

Mostly issue might be with space or the : or slash…So check how they are

cheers

@Anil_G

Hi @naveenkumarr

Instead of Workbook Write Range activity can you try with Excel Application scope Write range activity

Regards
Gokul

Hi @naveenkumarr

In your output panel where the path is printer you see a ! button right…click on it and you will see if there are any special characters. Or in local see the variable you can see there as well if there are any special characters.

cheers

Hi @naveenkumarr

Did you give double quotes in your asset? If yes then that is the issue. You should not give…Directly give the path

cheers

2 Likes