Encounter illegal characters in path in Write range

Help Robot
,
1

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
illegal characters in path933×129 13.8 KB

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
delete range443×547 10.3 KB

How can I resolve this issue?

2

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,

3

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

follow up
follow up440×1143 25.3 KB

4

Hi,

Can you share content of strExtPIPUrl variable at the WriteRange?

Regards,

5

Hi @Yoichi

follow up2
follow up2833×475 24.2 KB

is this what u want?

6

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,

7

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

8

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

is this where the error is?

9

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,

10

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

11

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…

12

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,

13

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

14

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