Temp files interfering with for each file in directory


#1

Hello there.

I had this XAML where I have a for each files in a directory, and it worked perfectly as of yesterday, the loop started to take the ~ files, these are temp files, Excel files, saved as a backup. Previously it didn't "count it" for the iteration but now it is and it's not working because I use the current file to append data, so it says that I can't save the file obviously for the ~ at the beginning of the file name. I’m thinking to use an if, but I would like to know if you guys have some other ideas. Happy automation!!!


#2

Directory.GetFiles(“MyPath”).Where(Function(fname) Not fname.StartsWith("~$"))


#3

Hello vvaidya,

Could you provide an sample workflow for reference?


#4

Actually what I am doing is looping through the excel files in a folder, then append the data from sheet1 to a new excel workbook.
But after doing this there will have same number of temp files starting with ~ hidden in the folder. If I run the RPA again, it will also loop through the temp file which cause error. Instead of only read the files Not starting with ~, is it possible to remove the ~$ file after append the data? Coz I will reuse the folder and save other new files in it


#5

@Haha,files

Thanks,
Sreekanth.k


#6

I guess the temp file is still a xlsx or xls file, just it is starting with ~$ , and it is hidden in the folder even I choose to display hidden files in window folder setting.
However, when I use directory.getfiles().length, it will also Count the hidden files, so is there any ways to remove those hidden files instead?
Thanks!