Select todays excel file from specific location uipath

Help Activities
,
1

Hello Guys , I’m trying to get the most recent excel file in a specific folder .
i tried using the Method " Out_filepath = Directory.GetFiles(“yourFolderPath”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) ) "in Excel Application Scope File path but it gave me error .
any advice ?

2

Hi @Abx9 ,

What is the error message you are getting.

Try with below expression and let us know. Thanks.

str_filepath = Directory.GetFiles(yourfolder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Tolist(0)

1 Like
3

it gave an error the “str_filepath” is not declared and couldn’t reach because of security permition

4

Hi @Abx9 ,

Could you pls create variable str_filepath as string type.

With the above expression you will get latest xlsx file path into str_filepath

After that you could use this str_filepath in the excel application scope and try to open that file and let us know.

One more thing put this str_filepath in log message and see if you are getting latest excel file path. Thanks

1 Like
5

Hi @Abx9

First create a directory variable with DirectoryInfo type ex directorylocation

directorylocation = new DirectoryInfo("your excel file directory")

Then you have to create a another array variable with FileInfo type. ex newly_created_files

newly_created_files = directorylocation.GetFiles(".xlsx").Where(function(file) file.LastWriteTime.Date=DateTime.Now.Date).OrderByDescending(function(d) d.LastWriteTimeUtc).ToArray

Today created files are stored in newly_created_files

Pass this array variable inside a for each activity incase if multiple excel files was created today

Or else

If you have single excel

Create a variable with Genericvalue Type ex MyExcelFile

MyexcelFile = newly_created_files(0).ToString

Hope it solves your issue

And update us whether you got your desired solution or not

Thanks
Robin

3 Likes
6

image
image1628×1314 212 KB

it gave an Error that 1-dimentionales Array of system Io not defined

7

please find the attached xaml file for more reference

TodaysNewestFileIinDirectory.xaml (9.9 KB)

Thanks,
Robin

2 Likes
8

thanks for the help

1 Like
9

Your welcome

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.