Could you advise on how can I get the folder and file names with multiple levels into excel?
Folder & File Structure:
Excel to show it as:
Lvl1Folder Lvl2Folder Lvl3Folder Lvl4Files.pdf
Lvl1Folder Lvl2Folder Lvl3Files.txt
I tried the following:
- Create data table
- for each and use Directory.GetFileSystemEntries to get folder and file name
Any advice how should i go about this? Thanks.