How to fetch recent excel file from folder

[Priti_Patil]

folder path : C:\Users\A454946\OneDrive \x 2024 templates
Excel file name: xyz.xlsm
there are multiple excel files in given folder path .How to fetch recent excel file using VB expression or any function using assign activity.

[vrdabberu (Varunraj Dabberu)]

Hi @Priti_Patil

Try this:

Directory.GetFiles("C:\Users\A454946\OneDrive\x 2024 templates", "*.xlsm").OrderByDescending(Function(f) New FileInfo(f).LastWriteTime).First()

Regards

[Sanjit_Pal]

Have a look at this

Get Latest File | Delete Multiple File | Get Specific Type of File

Get Latest File When we download a file from the browser or some application, we might need to have the downloaded file to proceed further. So, how to get the latest file from a folder? *Implementation using UiPath Step 1: Drag “Assign” activity into the designer panel and supply the “Folder Path” to it. Example : our_FolderPath = “C:\Users\Sanjit.Pal\Downloads” [image] Step 2: Drag “Message Box” activity into the designer panel and supply the below-mentioned code to it. Str…

[Priti_Patil]

When I am running same function, I get output Properly with different flowchart. but I run from main sequence file , I am getting file name “desktop.inn” . is there any specific Reason?

[Sanjit_Pal]

Try this method once, Change the extension as per your requirement, below code will work for .xlsx and .xls
Directory.GetFiles(“YourFolderPath”, “.xlsx")
.Concat(Directory.GetFiles(“YourFolderPath”, ".xls”))
.OrderByDescending(Function(f) New FileInfo(f).CreationTime)
.FirstOrDefault()

[pikorpa (Piotr Kołakowski)]

Hey @Priti_Patil
try this:
allExcelFiles = Directory.GetFiles("C:\Users\A454946\OneDrive\x 2024 templates", "*.xlsm")

recentExcel = allExcelFiles.OrderByDescending(Function(file) New FileInfo(file).LastWriteTime).FirstOrDefault()

allExcelFiles type String
recentExcel type String

[postwick (Paul Ostwick)]

Using DirectoryInfo.GetFiles instead of Directory.GetFiles, advanced filtering

Most times it’s recommended to use Directory.GetFiles to get the files in a folder. I’ve found DirectoryInfo.GetFiles to be more useful. It gets the files as an IEnumerable of FileInfo, which makes filtering easier and gives you more info about the files. You can later For Each through it and get any of the attributes of the file you want: filename (currentItem.Name); extension (currentItem.Extension), full path and filename (currentItem.FullName) etc. Here is the full definition of FileInfo …

[Gayathri_Mk]

–use a assign activity and mention like this
out_filepath = Directory.GetFiles(“yourfilepath”,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).ToList(0)