How to get excel last saved by file details in uipath studio

[Ambika_Singh1 (Ambika Singh)]

Hi all, if anyone knows how to get last saved by detail for excel file.

I have tried this method but this is giving me machine name instead and not he last saved by detail: System.IO.File.GetAccessControl(file
Path).GetOwner(GetType(System.Se
curity.Principal.NTAccount)).ToString

[lrtetala (Lakshman Reddy)]

Hi @Ambika_Singh1

Please check the below

How to get "Last saved by" of a file

@pondyondaime, Okay, then try with the below query, it will give you the username of the last modified file in a directory Directory.GetFiles("yourDirectoryPath").[Select](Function(f) New FileInfo(f)).OrderByDescending(Function(fi) fi.LastWriteTime).First.GetAccessControl().GetOwner(GetType(System.Security.Principal.NTAccount)).ToString()

Word or Excel Last Modified by

If you have the filepath to the file in a string, then you can use this code in an assign activity. System.IO.File.GetAccessControl(filePath).GetOwner(GetType(System.Security.Principal.NTAccount)).ToString.Split("\"c).Last Reason I used a split and Last was because it gives you the user with the domain. Regards.

Regards,

[vrdabberu (Varunraj Dabberu)]

Hi @Ambika_Singh1

Check out the thread

Word or Excel Last Modified by

If you have the filepath to the file in a string, then you can use this code in an assign activity. System.IO.File.GetAccessControl(filePath).GetOwner(GetType(System.Security.Principal.NTAccount)).ToString.Split("\"c).Last Reason I used a split and Last was because it gives you the user with the domain. Regards.

Regards

[Ambika_Singh1 (Ambika Singh)]

As mentioned in the post itself i have used this method already. It gives me the machine name and not the last saved by detail of excel.

[rlgandu (Rajyalakshmi Gandu)]

@Ambika_Singh1

How to extract Excel file last saved by name and datetime?

Hi You can use this activity to get the file info like Input: Size (in bytes), Name (file name including extension), Full Name (includes full path) , Folder (full path to the folder containing the file), Last modified date , Last accessed date , Created date (dates including time), IsReadOnly (TRUE or FALSE), Size in KB . https://docs.uipath.com/activities/other/latest/workflow/get-file-info-x To get the name str_name = System.IO.File.GetAccessControl(path).GetOwner(GetType(System.Security.…

[Ambika_Singh1 (Ambika Singh)]

Hi everyone I got the solution.

Here is the link of the youtube video

Extracting Excel Properties with UiPath Using VBA Script | Automate with Ambika

Thanks,
Ambika