Find Last Saved Date of an excel file

[m.harfouch (M Har)]

Hello everyone,

I need to get the last saved date of an excel file from UiPath Studio.

I was able to get it using python and vba but I need a .net solution.

Please advise.

[nithyac]

Hi,

Can get the Last modified file info by using assign activity, mention the below code to get the value as string.

new FileInfo(“FilePath”).LastModifiedDate.ToString

Hope this may help you.

[Gokul001 (Gokul Balaji)]

Hi @m.harfouch

Step 1 : GoTo Activity panel → Filter → Enable StudioX
Step 2 : Search For Each File in Folder Activity

Step 3: Refer to the screenshot you can order by the requirement

CurrentFile.LastModifiedDate

Regards
Gokul

[m.harfouch (M Har)]

Hello @nithyac please note that the last modified date is different from the last saved date as you can see in the below:

[ppr (Peter Preuss)]

@m.harfouch
give a try on lastWriteTime

also have a look on following for retrieving extended metadata

UiPath Marketplace | Error

[m.harfouch (M Har)]

@ppr thank you for your reply!

I tried this method as well, it will return the last modified date not the last saved date.

[ppr (Peter Preuss)]

@m.harfouch

I tried this method as well,

had you tried metadata reader?