{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Method_1","Method_2","Method_3","Method_4","Method_5","Method_6","Method_7"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Method_1","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Method 1: Copy and paste from Mac Finder"]
[]
[null,"Thumbnail.xcf"]
[null,"List of all Files and Folders.docx"]
[null,"Thumbnail.jpg"]
[null,"Folder_1"]
[null,"Excel_Workbook.xlsx"]
[null,"filelist.txt"]
[null,"Directory.xlsx"]
[null,"Directory.xlsm"]
[null,"Directory_Word.docx"]
[null,"Directory_Graphics.pptx"]
[null,"Directory_Graphics_old.pptx"]

{"sheet":"Method_2","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Method 2: Use Named Ranges for Inserting Directories"]
[]
[null,"Folder path","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\*"]
[]
[null,"List"]
[null,{"$f":"INDEX(Folder_Path,ROW(B1))","v":"Directory.xlsm"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B2))","v":"Directory.xlsx"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B3))","v":"Directory_Graphics.pptx"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B4))","v":"Directory_Word.docx"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B5))","v":"Excel_Workbook.xlsx"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B6))","v":"Thumbnail.jpg"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B7))","v":"Thumbnail.xcf"}]
[null,{"$f":"INDEX(Folder_Path,ROW(B8))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDEX(Folder_Path,ROW(B9))","v":{"$error":"#REF!"}}]

{"sheet":"Method_3","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Method 3: Use Internet Browser for Inserting Directories"]
[]
[null,"Name","Size","Date Modified"]
[null,"Folder_1/",null,"5/12/21, 5:46:55 AM"]
[null,"Directory_Graphics.pptx","6.6 MB","5/11/21, 7:45:08 PM"]
[null,"Directory_Word.docx","542 kB","5/10/21, 7:55:26 PM"]
[null,"Directory.xlsm","13.0 kB","5/12/21, 6:34:44 AM"]
[null,"Directory.xlsx","12.9 kB","5/12/21, 6:34:35 AM"]
[null,"Excel_Workbook.xlsx","8.5 kB","5/11/21, 7:17:57 PM"]
[null,"Thumbnail.jpg","156 kB","5/11/21, 7:42:38 PM"]
[null,"Thumbnail.xcf","11.7 MB","5/11/21, 7:40:26 PM"]

{"sheet":"Method_4","index":3,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Method 4: PowerQuery"]
[]
[null,"Folder Path","Name","Extension","Date accessed","Date modified","Date created","Attributes.Content Type","Attributes.Kind","Attributes.Size","Attributes.ReadOnly","Attributes.Hidden","Attributes.System","Attributes.Directory","Attributes.Archive","Attributes.Device","Attributes.Normal","Attributes.Temporary","Attributes.SparseFile","Attributes.ReparsePoint","Attributes.Compressed","Attributes.Offline","Attributes.NotContentIndexed","Attributes.Encrypted","Attributes.ChangeTime","Attributes.SymbolicLink","Attributes.MountPoint"]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Directory.xlsm",".xlsm","2021-05-12T17:43:46.591","2021-05-12T06:56:35","2021-05-12T06:34:44.634","application/vnd.ms-excel.sheet.macroEnabled.12","Excel File",29396,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.738733692131,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Directory.xlsx",".xlsx","2021-05-12T06:34:52","2021-05-12T06:34:35","2021-05-12T06:21:01.553","application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","Excel File",13213,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.274217534723,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Directory_Graphics.pptx",".pptx","2021-05-12T14:33:15.521","2021-05-12T06:57:10","2021-05-12T05:46:55.916","application/vnd.openxmlformats-officedocument.presentationml.presentation","File",8426034,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.737382303239,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Directory_Word.docx",".docx","2021-05-12T05:48:33","2021-05-10T19:55:26","2021-05-12T05:46:55.919","application/vnd.openxmlformats-officedocument.wordprocessingml.document","File",555041,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242058483796,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Excel_Workbook.xlsx",".xlsx","2021-05-12T06:05:28.879","2021-05-11T19:17:57","2021-05-12T05:46:55.914","application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","Excel File",8663,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.253939814815,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Thumbnail.jpg",".jpg","2021-05-12T05:48:33","2021-05-11T19:42:38","2021-05-12T05:46:55.875","image/jpeg","File",160138,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242049548608,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\","Thumbnail.xcf",".xcf","2021-05-12T17:44:10.559","2021-05-11T19:40:26","2021-05-12T05:46:55.875","application/octet-stream","File",12225030,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.73901109954,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\","Test_File_1.rtf",".rtf","2021-05-12T05:48:34","2021-05-11T19:15:41","2021-05-12T05:46:55.891","application/msword","File",406,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242063101854,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\","Test_File_2.rtf",".rtf","2021-05-12T05:48:34","2021-05-11T19:15:41","2021-05-12T05:46:55.891","application/msword","File",406,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242062916666,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\","Test_File_3.rtf",".rtf","2021-05-12T05:48:34","2021-05-11T19:15:41","2021-05-12T05:46:55.908","application/msword","File",406,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242062916666,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\","Test_File_4.rtf",".rtf","2021-05-12T05:48:33","2021-05-11T19:15:41","2021-05-12T05:46:55.891","application/msword","File",406,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242058946758,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\","Test_File_5.rtf",".rtf","2021-05-12T05:48:33","2021-05-11T19:15:41","2021-05-12T05:46:55.891","application/msword","File",406,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.24205641204,false,false]
[null,"C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder2\\","books-1281581.jpg",".jpg","2021-05-12T05:48:37","2021-05-11T19:35:53","2021-05-12T05:46:55.911","image/jpeg","File",5986036,false,false,false,false,true,false,false,false,false,false,false,false,false,false,44328.242097141207,false,false]

{"sheet":"Method_5","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Method 5: Excel Add-In Professor Excel Tools"]
[]
[null,"File Name","File Path","Date Saved","Date Created","File Type","File Size [Byte]"]
[null,"Directory.xlsm","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Directory.xlsm","2021-05-12T06:56:35","2021-05-12T06:34:44","Microsoft Excel Macro-Enabled Worksheet",29396]
[null,"Directory.xlsx","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Directory.xlsx","2021-05-12T06:34:35","2021-05-12T06:21:01","Microsoft Excel Worksheet",13213]
[null,"Directory_Graphics.pptx","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Directory_Graphics.pptx","2021-05-12T06:57:10","2021-05-12T05:46:55","Microsoft PowerPoint Presentation",8426034]
[null,"Directory_Word.docx","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Directory_Word.docx","2021-05-10T19:55:26","2021-05-12T05:46:55","Microsoft Word Document",555041]
[null,"Excel_Workbook.xlsx","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Excel_Workbook.xlsx","2021-05-11T19:17:57","2021-05-12T05:46:55","Microsoft Excel Worksheet",8663]
[null,"Thumbnail.jpg","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Thumbnail.jpg","2021-05-11T19:42:38","2021-05-12T05:46:55","JPG File",160138]
[null,"Thumbnail.xcf","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Thumbnail.xcf","2021-05-11T19:40:26","2021-05-12T05:46:55","GIMP 2.10.24",12225030]
[null,"Test_File_1.rtf","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\Test_File_1.rtf","2021-05-11T19:15:41","2021-05-12T05:46:55","Rich Text Format",406]
[null,"Test_File_2.rtf","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\Test_File_2.rtf","2021-05-11T19:15:41","2021-05-12T05:46:55","Rich Text Format",406]
[null,"Test_File_3.rtf","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\Test_File_3.rtf","2021-05-11T19:15:41","2021-05-12T05:46:55","Rich Text Format",406]
[null,"Test_File_4.rtf","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\Test_File_4.rtf","2021-05-11T19:15:41","2021-05-12T05:46:55","Rich Text Format",406]
[null,"Test_File_5.rtf","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder1\\Test_File_5.rtf","2021-05-11T19:15:41","2021-05-12T05:46:55","Rich Text Format",406]
[null,"books-1281581.jpg","C:\\Users\\hschi\\OneDrive\\Professor Excel\\Articles\\210511_Example_Directory\\Folder_1\\Subfolder2\\books-1281581.jpg","2021-05-11T19:35:53","2021-05-12T05:46:55","JPG File",5986036]

{"sheet":"Method_6","index":5,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Method 6: Windows PowerShell"]
[]
[]
[]
[null,"Directory:","C:\\Users\\hschi\\OneDr","ive\\Professor"]
[null,"Excel\\Artic","les\\210511_Example_D","irectory"]
[]
[]
[null,"Mode","LastWriteTime","Length","Name"]
[null,"----","-------------","------","----"]
[null,"d----l","2021-05-12T05:46:00",null,"Folder_1"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-12T17:48:00",32310,"Directory.xlsm"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-12T06:34:00",13213,"Directory.xlsx"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-12T21:06:00",9037428,"Directory_Graphics.pptx"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-10T19:55:00",555041,"Directory_Word.docx"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:17:00",8663,"Excel_Workbook.xlsx"]
[null,"-a----","2021-05-13T07:04:00",0,"filelist.txt"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:42:00",160138,"Thumbnail.jpg"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:40:00",12225030,"Thumbnail.xcf"]
[]
[]
[null,"Directory:","C:\\Users\\hschi\\OneDr","ive\\Professor"]
[null,"Excel\\Artic","les\\210511_Example_D","irectory\\Folder","_1"]
[]
[]
[null,"Mode","LastWriteTime","Length","Name"]
[null,"----","-------------","------","----"]
[null,"d----l","2021-05-12T05:48:00",null,"Subfolder1"]
[null,"d----l","2021-05-12T05:48:00",null,"Subfolder2"]
[]
[]
[null,"Directory:","C:\\Users\\hschi\\OneDr","ive\\Professor"]
[null,"Excel\\Artic","les\\210511_Example_D","irectory\\Folder","_1\\Subfolder1"]
[]
[]
[null,"Mode","LastWriteTime","Length","Name"]
[null,"----","-------------","------","----"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:15:00",406,"Test_File_1.rtf"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:15:00",406,"Test_File_2.rtf"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:15:00",406,"Test_File_3.rtf"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:15:00",406,"Test_File_4.rtf"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:15:00",406,"Test_File_5.rtf"]
[]
[]
[null,"Directory:","C:\\Users\\hschi\\OneDr","ive\\Professor"]
[null,"Excel\\Artic","les\\210511_Example_D","irectory\\Folder","_1\\Subfolder2"]
[]
[]
[null,"Mode","LastWriteTime","Length","Name"]
[null,"----","-------------","------","----"]
[null,{"$f":"-a---l","v":{"$error":"#NAME?"}},"2021-05-11T19:35:00",5986036,"books-1281581.jpg"]

{"sheet":"Method_7","index":6,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Directory.xlsm"]
["Directory.xlsx"]
["Directory_Graphics.png"]
["Directory_Graphics.pptx"]
["Directory_Word.docx"]
["Excel_Workbook.xlsx"]
["filelist.txt"]
["Thumbnail.jpg"]
["Thumbnail.xcf"]