Get files count from each available folder's and paste it under column of a folder name

[Priyesh_Shetty1 (Priyesh Shetty -)]

Can anyone tell me how can i get the count’s of the file’s from each folder’s and i want the total count also.

let say there are 4 folder’s so basically i want the count of files which is present in the folder’s and i want the total count’s also.

And this count’s i want to paste it in the excel with column name of the folder’s?

[pravallikapaluri]

Hi @Priyesh_Shetty1

1.Assign the folder paths into an variable “Folderpaths” of type string[ ]
2.Initialize a int32 variables “cnt” and “Rcount”

The output will give the count of files present in the folder.

Hope it helps!!

[Priyesh_Shetty1 (Priyesh Shetty -)]

@pravallikapaluri it is giving wrong count it is giving only one folder count properly.

it should take count of each folder’s

[pravallikapaluri]

@Priyesh_Shetty1
Try with this
Move the assign activity cnt to inside of the loop

Hope it helps!!

[Priyesh_Shetty1 (Priyesh Shetty -)]

@pravallikapaluri this 2nd code is giving right output know i want the total files of all folder
what should i do for that?

[pravallikapaluri]

@Priyesh_Shetty1

The First Output will gives all the total number of files Present in all the folders.It is showing the correct output i.e,Older file Count+ newest filecount= messagebox …

Hope You got the answer!!

[Priyesh_Shetty1 (Priyesh Shetty -)]

I want to paste the ouput like this and i have to mail this to client.

How can i do this?

[pratik.pandya]

Hi @Priyesh_Shetty1

You have to use HTML for sending Excel Tables along with Email Body. It will surely work.

Thanks.

[Priyesh_Shetty1 (Priyesh Shetty -)]

@pratik.pandya can you just tell me the steps?

[Priyesh_Shetty1 (Priyesh Shetty -)]

@pratik.pandya or a code how can i do this i want to paste all the counts under the columns and total counts also.

[pratik.pandya]

@Priyesh_Shetty1

I Don’t know about the Exact code but you have to add Each Column and Rows one by one using loop into the HTML Code which is present inside the variable.

[postwick (Paul Ostwick)]

Read Range from Excel into a datatable.
Add Data Column “File Count” as Int32
For Each Row in Datatable

• Assign CurrentRow(“File Count”) = Directory.GetFiles(CurrentRow(“folderPath”).ToString).Count

//end for each
Write Range back to Excel.

To get the total:

yourDT.AsEnumerable.Sum(Function(a) Convert.ToDouble(a(“FolderCount”).ToString))