CSV To Xlsx

[km81 (Km)]

How to get latest file in folder using uipath

Hey Here is a detailed article on that

Hi,
I have referred to the above post for fetching latest csv file and converting it into Excel workbook
But i am geting the CSV extension every time which is causing issue for me

Input Argument : String.Join(" ",Directory.GetFiles(Folder_Path,”*.csv”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1))

Output Argument : String.Join(" ",Directory.GetFiles(Folder_Path,”*.csv”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1)) + “xlsx”

Please help

[ptrobot]

You can use Path.GetFileNameWithoutExtension(fileName) to get the filename without the extension.

Path.GetFileNameWithoutExtension(String.Join(" ",Directory.GetFiles(Folder_Path, "*.csv").OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1))) + ".xlsx"

[km81 (Km)]

Thx @ptrobot
I tried this but the output is saving in different directory, i dont want to move files from one place to other.

Pls help

[ptrobot]

Sorry, you are correct. It only returns the filename without the path. Path.ChangeExtension() is the function you should be using instead.

Path.ChangeExtension(String.Join(" ",Directory.GetFiles(Folder_Path,”*.csv”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1)), “.xlsx”)

[km81 (Km)]

@ptrobot

Path.ChangeExtension(String.Join(" ",Directory.GetFiles(Folder_Path,”*.csv”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1)), “.xlsx”)

Thx a lot it worked