{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Early","Dir","Late","Early2","Dir2","Late2","Hyperlink","Specific","Nonrecursive"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Early","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using File System Object Early Binding"]
[]
[null,"File Name","Type","Size"]
[null,"Readme.txt","Text Document",0]
[null,"Sample Data.png","PNG File",26279]
[null,"Sample Output.mp4","MP4 File",212689]
[null,"User Defined Function-2.zip","WinRAR ZIP archive",17231245]
[null,"User Defined Function.xlsx","Microsoft Excel Worksheet",34489]

{"sheet":"Dir","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Dir Function"]
[]
[null,"File Name","File Type","Size (KB)"]
[null,"Readme.txt","txt",0]
[null,"Sample Data.png","png",26279]
[null,"Sample Output.mp4","mp4",212689]
[null,"User Defined Function-2.zip","zip",17231245]
[null,"User Defined Function.xlsx","xlsx",34489]

{"sheet":"Late","index":2,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["E:\\Softeko\\UDF\\"]
["E:\\Softeko\\UDF\\Images"]
["E:\\Softeko\\UDF\\Images\\User-Defined-Function (1).png"]
["E:\\Softeko\\UDF\\Images\\User-Defined-Function (3).png"]
["E:\\Softeko\\UDF\\Images\\User-Defined-Function(2).png"]
["E:\\Softeko\\UDF\\New folder"]
["E:\\Softeko\\UDF\\New folder\\Extras"]
["E:\\Softeko\\UDF\\New folder\\Extras\\New Workbook.xlsm"]
["E:\\Softeko\\UDF\\New folder\\Extras\\UDF (New).mp4"]
["E:\\Softeko\\UDF\\New folder\\Extras\\UDF10.png"]
["E:\\Softeko\\UDF\\New folder\\Extras\\User Defined.xlsx"]
["E:\\Softeko\\UDF\\Readme.txt"]
["E:\\Softeko\\UDF\\Sample Data.png"]
["E:\\Softeko\\UDF\\Sample Output.mp4"]
["E:\\Softeko\\UDF\\User Defined Function-2.zip"]
["E:\\Softeko\\UDF\\User Defined Function.xlsx"]
["E:\\Softeko\\UDF\\Videos"]
["E:\\Softeko\\UDF\\Videos\\Output (3).mp4"]
["E:\\Softeko\\UDF\\Videos\\Output(1).mp4"]
["E:\\Softeko\\UDF\\Videos\\Output(2).mp4"]

{"sheet":"Early2","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using File System Object Early Binding to List Subfolder Files"]
[]
[null,"File Name","Type","Size (KB)"]
[null,"E:\\Softeko\\UDF\\Images\\User-Defined-Function (1).png","PNG File",26279]
[null,"E:\\Softeko\\UDF\\Images\\User-Defined-Function (3).png","PNG File",25949]
[null,"E:\\Softeko\\UDF\\Images\\User-Defined-Function(2).png","PNG File",19743]
[null,"E:\\Softeko\\UDF\\New folder\\Extras\\New Workbook.xlsm","Microsoft Excel Macro-Enabled Worksheet",12847]
[null,"E:\\Softeko\\UDF\\New folder\\Extras\\UDF (New).mp4","MP4 File",550756]
[null,"E:\\Softeko\\UDF\\New folder\\Extras\\UDF10.png","PNG File",37018]
[null,"E:\\Softeko\\UDF\\New folder\\Extras\\User Defined.xlsx","Microsoft Excel Worksheet",34489]
[null,"E:\\Softeko\\UDF\\Videos\\Output (3).mp4","MP4 File",213711]
[null,"E:\\Softeko\\UDF\\Videos\\Output(1).mp4","MP4 File",212689]
[null,"E:\\Softeko\\UDF\\Videos\\Output(2).mp4","MP4 File",348088]
[null,"E:\\Softeko\\UDF\\Readme.txt","Text Document",0]
[null,"E:\\Softeko\\UDF\\Sample Data.png","PNG File",26279]
[null,"E:\\Softeko\\UDF\\Sample Output.mp4","MP4 File",212689]
[null,"E:\\Softeko\\UDF\\User Defined Function-2.zip","WinRAR ZIP archive",17231245]
[null,"E:\\Softeko\\UDF\\User Defined Function.xlsx","Microsoft Excel Worksheet",34489]

{"sheet":"Dir2","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Dir Function to List Subfolder Files"]
[]
[null,"File Name","File Type","File Size (KB)"]

{"sheet":"Late2","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using File System Object Late Binding to List Subfolder Files"]
[]
[null,"File Name","Type","Size (KB)"]
[null,"User-Defined-Function (1).png","PNG File",26279]
[null,"User-Defined-Function (3).png","PNG File",25949]
[null,"User-Defined-Function(2).png","PNG File",19743]
[null,"New Workbook.xlsm","Microsoft Excel Macro-Enabled Worksheet",12847]
[null,"UDF (New).mp4","MP4 File",550756]
[null,"UDF10.png","PNG File",37018]
[null,"User Defined.xlsx","Microsoft Excel Worksheet",34489]
[null,"Output (3).mp4","MP4 File",213711]
[null,"Output(1).mp4","MP4 File",212689]
[null,"Output(2).mp4","MP4 File",348088]
[null,"Readme.txt","Text Document",0]
[null,"Sample Data.png","PNG File",26279]
[null,"Sample Output.mp4","MP4 File",212689]
[null,"User Defined Function-2.zip","WinRAR ZIP archive",17231245]
[null,"User Defined Function.xlsx","Microsoft Excel Worksheet",34489]

{"sheet":"Hyperlink","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Listing Files in Folder and Subfolder with Hyperlink"]
[]
[null,"File Name"]
[null,"Readme.txt"]
[null,"Sample Data.png"]
[null,"Sample Output.mp4"]
[null,"User Defined Function-2.zip"]
[null,"User Defined Function.xlsx"]
[null,"User-Defined-Function (1).png"]
[null,"User-Defined-Function (3).png"]
[null,"User-Defined-Function(2).png"]
[null,"Output (3).mp4"]
[null,"Output(1).mp4"]
[null,"Output(2).mp4"]

{"sheet":"Specific","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Listing Files in Folder with Specific Extension"]
[]
[null,"File Name","File Type","File Size (KB)"]
[null,"Sample Data.png","PNG File",26279]
[null,"User Defined Function.xlsx","Microsoft Excel Worksheet",34489]
[null,"User-Defined-Function (1).png","PNG File",26279]
[null,"User-Defined-Function (3).png","PNG File",25949]
[null,"User-Defined-Function(2).png","PNG File",19743]
[null,"User-Defined-Function (1).png","PNG File",26279]
[null,"User-Defined-Function (3).png","PNG File",25949]
[null,"User-Defined-Function(2).png","PNG File",19743]

{"sheet":"Nonrecursive","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Listing Files in Folders and Subfolder Using Non-recursive Method"]
[]
[null,"File Name","Type"]
[null,"Readme.txt","Text Document"]
[null,"Sample Data.png","PNG File"]
[null,"Sample Output.mp4","MP4 File"]
[null,"User Defined Function-2.zip","WinRAR ZIP archive"]
[null,"User Defined Function.xlsx","Microsoft Excel Worksheet"]
[null,"User-Defined-Function (1).png","PNG File"]
[null,"User-Defined-Function (3).png","PNG File"]
[null,"User-Defined-Function(2).png","PNG File"]
[null,"Output (3).mp4","MP4 File"]
[null,"Output(1).mp4","MP4 File"]
[null,"Output(2).mp4","MP4 File"]