Can anyone help me with this Read Range problem？

[491979546 (Vegeta)]

I have only 2 documents in my folder directory, but I don’t know why I use GetFiles() method，then it will read out 3 files and then cause Read Range: file contains corrupt data.

[Yoichi]

Hi,

~$ means temporary file.
Can you try the following expression? This returns files except starting with “~$”

files = System.IO.Directory.GetFiles(yourPath).Where(Function(f) not System.IO.Path.GetFileName(f).StartsWith("~$")).ToArray()

Regards,

[491979546 (Vegeta)]

thank you , bro. But I just want to get the xlsx file , how do I filter other File expansion name that are not xlsx？

[Yoichi]

Hi,

@491979546

how do I filter other File expansion name that are not xlsx？

We can use 2nd argument of GetFiles method as the following. Can you try this?

System.IO.Directory.GetFiles(yourPath,"*.xlsx").Where(Function(f) not System.IO.Path.GetFileName(f).StartsWith("~$")).ToArray()

Regards,

[491979546 (Vegeta)]

@Yoichi

System.IO.Directory.GetFiles(yourPath,"*.xlsx").Where(Function(f) not System.IO.Path.GetFileName(f).StartsWith("~$")).ToArray()

you’re great UiPath master ! Thank you so much!