Illegal characters in path in write range activity

[naveenkumarr (Naveen Kumar)]

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

[Gokul001 (Gokul Balaji)]

HI @naveenkumarr

Check out this thread

Encounter illegal characters in path in Write range

I encounter this error message when robot is attempting to write range for the second record in excel file (data table). [illegal characters in path] Before hitting the error, I wanted to delete range for the same excel file which contains data scrapping to prepare for the second record as it goes through a loop (for each row in data table). [delete range] How can I resolve this issue?

Regards
Gokul

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

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

[naveenkumarr (Naveen Kumar)]

@sangeethaneelavannan1 ,

No luck, still the same issue.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Read Range using variable as workbook path returning Illegal characters in path

Hi, please assist i have all my filenames (full path + extension) in a multi-line string so i assign it into a string individually for my process strFileNameReadRange = strFileNames1.Split(cchar(System.Environment.NewLine))(intFileCounter) strFileNames1 = multi-line string intFileCounter = line of multi-line string it can return me properly when i use a message box and write line but when i put into workbook path of read range activity below message occurs [image] the variable i put i…

[naveenkumarr (Naveen Kumar)]

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

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Share the screenshot of the activity?

[naveenkumarr (Naveen Kumar)]

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

[Gokul001 (Gokul Balaji)]

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

[naveenkumarr (Naveen Kumar)]

@Gokul001 sure

[Gokul001 (Gokul Balaji)]

Why do you have two \\ in the path

@naveenkumarr

[naveenkumarr (Naveen Kumar)]

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

[Gokul001 (Gokul Balaji)]

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

[naveenkumarr (Naveen Kumar)]

it is working by hardcoding the path in write range activity

[Anil_G (Anil Gorthi)]

Hi @naveenkumarr

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

cheers

[Anil_G (Anil Gorthi)]

Hi @naveenkumarr

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

cheers

[naveenkumarr (Naveen Kumar)]

@Anil_G

[Gokul001 (Gokul Balaji)]

Hi @naveenkumarr

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

Regards
Gokul

[Anil_G (Anil Gorthi)]

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

[Anil_G (Anil Gorthi)]

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