Paste the count of the files under the column

Help Studio
, , , ,
1

Hello!

I have removed the count of the each files from the folders and i want to paste that count in excel under the column of the folders name.

2

Hi @Priyesh_Shetty1

You can write it by using the expression

Directory.GetFiles(folderpath).Count.ToString

If you have a DataTable,
Loop using For each row in DataTable,
in there use an assign activity as below

CurrentRow(“FileCount”)= Directory.GetFiles(folderpath).Count.ToString

the folder path would be Directory + FolderName in your another column

Thanks

3

Hi @Priyesh_Shetty1

You can store the Count of column in a integer variable like Columncount.

Assign -> IntColumncount = Directory.getfiles(Folderpath).Count

Use write cell activity to write the columncount in the columns cell in excel.

Hope it helps!!

4

@adiijaiin

20230706_113852
20230706_1138521920×864 373 KB

I want ouput like this… i got the count and total count of files from the folder knw only i want to paste that count and total count under each column of the folder name like above image in excel.

5

@adiijaiin CVLKRA CAMS NDML these all are folder names inside that there are zip files…It should dynamically create data table there is no data table available the folder names are fix but some time there will be only 2 folders like CAMS KARVY,Sometime all folders like that so what can i do?