How to get excel file from a folder containing many files

[Kunal_Jain]

I have a folder named “ABCD” which contains 10 excel file whose initial name is same only after an underscore it can be differentiated.
Ex:- File name:-abcd_180398
File name2:- abcd_180399
I want to read the data from the latest file, as files are updated daily.
Only the point to differentiate the file is the date of modification
How to do that??

[arjunshenoy]

Hi @Kunal_Jain

First, get all the file names from the specified folder into an array like this:

fileList = Directory.GetFiles("Your Folder Path")

Then, determine the latest file like this:

latestFile = fileList.OrderByDescending(Function(x) New FileInfo(x).LastWriteTime).FirstOrDefault()

This will get you the latest created file.

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@Kunal_Jain

You can use this

Directory.Getfiles("Folderpath","abcd*.xlsx").OrderByDescending(function(x) New FileInfo(x).LastWriteTime).FirstOrDefault

Cheers

[adiijaiin (Aditya Jain)]

Hi @Kunal_Jain

This is the expression that’ll get you the latest one:

Directory.GetFiles(folderPath).[Select](Function(x) New FileInfo(x)).Where(Function(f) f.extension.equals(“.xlsx”)).OrderByDescending(Function(x) x.LastWriteTime).take(1).ToArray()(0).ToString()

Regards,

[Dilip_Wakdikar_1996 (Dilip Wakdikar)]

You can have order by set to Last Updated date newest first and then break the loop once you have process single file.

[Kunal_Jain]

Hey Thanks for your Help!
This worked for me