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 …

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

HI @naveenkumarr Check out this thread [image] Encounter illegal characters in path in Write range Robot 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 hittin…

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.

[image] Read Range using variable as workbook path returning Illegal characters in path Studio 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 = strFi…

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

Share the screenshot of the activity?

[hhshshshshs] [ss1] 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

Why do you have two \\ in the path [image] @naveenkumarr

Illegal characters in path in write range activity

Help Studio

Gokul001 (Gokul Balaji) November 10, 2022, 9:38am 2

HI @naveenkumarr

Check out this thread

Regards
Gokul

Topic		Replies	Views
Encounter illegal characters in path in Write range Robot robot , question	12	1562	November 24, 2021
Error "Read Range Illegal characters in path" only when using the path through "Get Asset" activity Orchestrator orchestrator , activities , read-range , get-asset , illegal-characters	6	1168	July 20, 2022
Illegal Path Error Studio uiautomation	28	1238	July 14, 2023
Write Range: Worksheet names cannot contain any of the following characters: :\\/?*[] Studio studio , question , tools	1	2032	January 30, 2021
Write Range Activity throwing error Help excel , activities , error	11	2686	January 7, 2020

Illegal characters in path in write range activity

Related topics