Save attachment (EXCEL) and read cell value

Help Studio
, ,
1

I have a for each loop to save attachments from Outlook to a destination folder.
Now, I want to open the attachment (Excel) and get the details.
I don’t know the excel file name. Is there a way to open the excel?

2

@Cari

Try below expression to fetch the excel filename.

       filename = Directory.GetFiles("Destination Folder Path","*.xlsx")(0)
3

It works!! Thank you.
Can I check what does (0) means at the back? Is it to fetch the latest excel in the folder?

1 Like
4

Hi @Cari ,

Here is another solution just to broaden your perspective.
If you want to retrieve the latest file from a given directory(str_downloadPath in this case), you can use this to achieve it → 

Directory.GetFiles(str_downloadPath).OrderByDescending(Function(o) New FileInfo(o).LastModifiedDate).First()

Kind Regards,
Ashwin A.K

5

@Cari

The above expression will give output as array of string. I.e. it will read all excel files from that folder. So, we are passing index as (0) to fetch the first file.

6

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