Read CSV: Could not find file erro

[Guilherme_Silva]

Hey guys.

I’m developing a robot that takes the last downloaded download from a folder and converts this file into xls (original file is in csv)

I created a variable that brings the most recent file. (new DirectoryInfo(foldername").GetFiles().OrderByDescending(Function(f) f.LastWriteTime).First().ToString.

I took this variable created and put it in the READ CSV function, for it to read the path and created the variable (excelformat)
but the error appears

Read CSV: Could not find file ‘C:\Users\guilherme.silva\Documents\UiPath\testsrename file\excelsalvo’.

what went wrong, can you help me?

I just wanted to turn csv into xls, and rename the last file just downloaded, as mentioned above.

sorry for the long text

[prasath17 (Guru)]

@Guilherme_Silva - In the Read CSV activity … Remove the " " from the excelsalvo, Because the excelsalvo is variable, not a string.

[Guilherme_Silva]

still with the error

[prasath17 (Guru)]

@Guilherme_Silva - Good…now its looking for the CSV file…

please show the screenshot of that file from the folder??

[Guilherme_Silva]

Yes true thank you! yeah, i wanted to read this latest recent file and turn it into xls

(arquivos valores separados) = csv

[prasath17 (Guru)]

@Guilherme_Silva - I see the below file sitting here…But is the path in the error message is same as it looking??

In your query, you mentioned that you are downloading it to the Downloads folder…but in the error message path, i don’t see any “Downloads” at all…

Please check this post for reference…

Move CSV file to different location

@Sahil_J_Patel - Say if only one file gets created everyday which you wants to move from downloads to different folder…here is the code… [image] StrCSV = Path.GetFullPath(Directory.GetFiles(Environment.ExpandEnvironmentVariables("%USERPROFILE%\Downloads"),"*.csv").OrderByDescending(Function(d) New FileInfo(d).LastWriteTime).First) above code pull the very recent file from the downloads folder which you can pass it to Move File activity… In the example above I am moved to my desktop… Envir…

[Guilherme_Silva]

wow thank you very much, i had done it that way, is that why the csv is not being read?

I wanted to transform this csv into xlsl

[prasath17 (Guru)]

@Guilherme_Silva - For Converting CSV to XLS

[Raluca_Laic]

Hey @Guilherme_Silva , just wanted to check here if you had any further questions regarding this issue or it has been resolved.