Use Excel File don't support file path

Help Studio
, ,
1

hello Uipath community:
I am trying to use the OC function to obtain a file path variable from the asset and use it in Excel,but an error occurs, the activity USE EXCEL FILE report “Use Excel File: The given path’s format is not supported.” as shown in the figure.

utyts
utyts2372×1152 227 KB

However, when I try to use the Assign activity with this value, USE EXCEL FILE will not report an error. waiting for your applies;
BEST REGARD!
Thanks in Advance:-)

2

Hi,

There might be extra spaces. For now, can you try f.Trim() in UseExcelFile?

Regards,

3

Thank you for reply.
I’ve tried almost string methods, even split the oc value with “" and splicing it again, like t.Split(”"c)(0) and get some array value splicing with Enviorment.username, but it doesn’t work :joy: