Illegal characters in path in write range activity

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

Hi @naveenkumarr

Mark the solution so that the thread can be closed and others also can get help

cheers

hey @Anil_G , you’re right,i gave “” in asset.
Thanks buddy :), it is working perfect now

1 Like

Anytime . Happy Automation

cheers

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.