How to create an excel file with a file directory?

Help Studio
, , ,
#1

Hi All
How to create an excel file with a file directory As an example?

Screenshot_1
there are several such folders

Screenshot_2

Screenshot_3
Screenshot_3814Ă—406 77.2 KB

It needs to look like this as a result

I will be happy if you help me :slightly_smiling_face:

#2

@Aibek_Abubakirov From where will we get the Values of Name and Gost Columns ?

#3
  1. Build a Datatable with the column you have as in Excel
  2. Directory.GetFiles(“FilesPath”) will give you list of Files . Loop and get the FileNames .
  3. Add Datarow will help to add data in to DT. Add datarow value as a Array item . Increment the intCount
    Eg:- {LTD+intCount ,Path,Path1} .
  4. After loop ends write the DT to Excel.

Hope this helps you .

#4

Its a mail directory Name i believe

#5

@karthick Then the “LTD Name” is a Constant term that needs to be used?

#6

These are the files that are in the folder.

In each folder, the names are different

#7

@Aibek_Abubakirov Yes, I feel we can make the automation possible :sweat_smile: , Have you tried what @karthick suggested, that should work

#8

LTD just wrote for example, folders of different names
Will it find the folder if there is another folder in it?

will he find the files in it?

#9

@Aibek_AbubakirovI Is it possible for you to Show us How the Folders are located in your System ?

#10

Screenshot_4
Screenshot_4473Ă—712 81.7 KB

Inside folders

#11

@Aibek_Abubakirov What’s inside of the Folder “essil town new”?

#12

same files

#13

@Aibek_Abubakirov But i couldn’t find the “LTD Name” folder :sweat_smile:

#14

:grinning:

#15

As per his excel sheet LTD Name is incrementing