Excel file is not opening by using modern activities

[victoryv4569]

Hi All,

this is actual path
C:\Bot Input\Spec Tender Release\Input\input template prod CHG 2.xlsm

but in UiPath while reading the file path will be showing like
C:\Bot Input\Spec Tender Release\Input~$input template prod CHG 2.xlsm.

why i am facing like this ?

any solution

Thank you!

[Gowtham_K115 (Gowtham Krishnan)]

@victoryv4569 While reading it will show like this only

You are getting any error?

[victoryv4569]

@Gowtham_K115

Error:

Excel Process Scope-Spec Tender: Failed opening the Excel file C:\Bot Input\Spec Tender Release\Input~$input template prod CHG 2.xlsm. Possible reasons: the file is corrupt, the file is already used by another process or you don’t have permissions to open the file.

Thank you

[Raymond_Hui]

seems like you are using looping to open excel files?

From your folder, view, could you click hide items so that you can see some cache about your excel files.

[Yoichi]

HI,

Do you use ForEachFile activity or GetFiles method etc.?
If so, can you try to add IF activity for exclude temp file for excel, as the following?

Regards,

[victoryv4569]

HI @Yoichi

This is the actual path

“C:\Bot Input\Spec Tender Release\Input\input template prod CANCEL Sample 2.xlsm”

i was try to remove ~$ to but its not supporting

Past one month its working fine but today only getting this issue

[Raymond_Hui]

could you try to use kill process to kill excel first

[Yoichi]

Hi,

Can you try to add IF activity as the following?

not System.IO.Path.GetFileName(FilePath).StartsWith("~$")

Regards,

[victoryv4569]

By using this its not reading the file

[Yoichi]

Hi,

Can you check if the target file exists at the folder?
Also Can you share how you get content of FilePath variable?

Regards,

[victoryv4569]

@Yoichi

thanks for you response,

every thing is fine but still getting this error.

so i just delated entire folder and recreated it and Now its working.