Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

[hagen (Lorenzo)]

The output should look something like this:

File path	File name	File creation date
C:\Users\HagenL\Documents\	File A	23.07.2023
C:\Users\HagenL\Documents\Folder 1	File B	23.07.2023
C:\Users\HagenL\Documents\Folder 2	File C	23.07.2023
C:\Users\HagenL\Documents\ Folder 3	File D	23.07.2023
…	…	…

I already got the output in three Arrays (except for the dates), but I need the output in a data table.
GetFoldersAndSubFolders.xaml (14.3 KB)

[Anil_G (Anil Gorthi)]

@hagen

You only need a for each file in folder activity…use include sub folders in it…and inside loop use currentfile.FullName for path …currentfile.Name for name and currentfile.ModifiedDate for date …use all of thse in add data row array row field…

After loop use write range to write the datatable which was build using add data row

Cheers

[lrtetala (Lakshman Reddy)]

Hi @hagen

Please find the below xaml.

GetFoldersAndSubFolders.xaml (19.6 KB)

Regards,

[lrtetala (Lakshman Reddy)]

Hi @hagen

Please find the below xaml total changes are done.

GetFoldersAndSubFolders.xaml (28.0 KB)

O/P Excel File:
Files Details.xlsx (6.5 KB)

Regards,

[lrtetala (Lakshman Reddy)]

@hagen

If you got the solution for your question. Please mark it as solution to close the thread and others also helped.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards,

[hagen (Lorenzo)]

I’m unable to open your xaml files. Error: document invalid
Never had this issue in this forum (I’m sure the xaml files you sent work perfectly though and I am very thankful for them)

If sb else can open them pls give notice, so I can mark Irtetala’s answer as correct.
Also Irtetala I will mark yours as soon as I find out what the problem is. Hope that is okay for you. Otherwhise just write me here Also thanks again

[lrtetala (Lakshman Reddy)]

@hagen

Is it okay

[hagen (Lorenzo)]

You’re an endboss! Thanks a lot

[lrtetala (Lakshman Reddy)]

@hagen

Please find the below xaml

Creation of Files in Excel.zip (156.2 KB)

Regards,