Encounter illegal characters in path in Write range

[Betta_path]

I encounter this error message when robot is attempting to write range for the second record in excel file (data table).

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).

How can I resolve this issue?

[Yoichi]

Hi,

There seems no WriteRange activity in the above image.
Is there just after ExcelApplicationScope activity?

If possible, can you share specific content of Workbook path property of the WriteRange?

Regards,

[Betta_path]

hi @Yoichi… thank u for the prompt reply… this is the screenshot that i can provide

[Yoichi]

Hi,

Can you share content of strExtPIPUrl variable at the WriteRange?

Regards,

[Betta_path]

Hi @Yoichi

is this what u want?

[Yoichi]

Hi,

Unfortunately no.
Can you try to put WriteLine Activity just before Write Range, and set strExtPIPUrl in WriteLine.
Next run workflow, then content of the variable will output to Output panel. Can you share this?
The error shows it contains illegal character.

Regards,

[Betta_path]

hi… it’s showing the file path of the excel file

[Betta_path]

hi @Yoichi … after running the next workflow, i realise in the output it created an unexpected column1 as seen here

is this where the error is?

[Yoichi]

Hi,

If the above is not what you expect, need to fix it, first.
Can you check in which activity the variable is assigned the value?

Regards,

[Betta_path]

noted, thank u… i think i know what to look out for next

[Betta_path]

I can’t seem to rectify the above error. When it goes to the flow of data scrapping after the Delete Range sequence above, i will hit this error message and unable to continue the flow…

[Yoichi]

Hi,

Is content of the variable what you expect? Even if it’s good but error occurs, can you try to use ExcelWriteRange inside ExcelApplciationScope instead of WriteRange (Sysytem-File-Workbook)?

Regards,

[Betta_path]

I managed to find the solution. I needed to clear the output data of the ExtractDataTable so when it goes to the next record, the “invisible data” is erased from the robot