I need a utility that can read through a disk directory structure starting at a user selected directory/sub-directory and populate an Excel file with the
Directory Name
Number of immediate sub-directories
Number of total files in the direcorty
Number of total bytes in the files
This information would be placed in the spreadsheet named? "Tree Details"? under directory level columns that match the depth of the directory (up to 20 levels deep).
Column 1 will contain a line count so that the spreadsheet can be sorted back to its original form
A second worksheet called "Tree Stats" will contain
The name of the starting folder
Lowest directory level used (depth of tree)
Total Number of Folders
Total Number of Files
Total Size (in bytes)
## Deliverables
I have attached two files for reference :
A sample explorer view of a directory structure
An Excel file showing the requred output format