{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Shortcut Keys","Sheet1","ExcelDemy","Power Query","All File Names","File Names with Extension"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Shortcut Keys","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Shortcut Keys",null,"Try Yourself"]
[]
[null,"File Names",null,"File Names"]
[null,"Project C.xlsx"]
[null,"Project D.docx"]
[null,"Project E.docx"]
[null,"Project A.xlsx"]
[null,"Project B.xlsx"]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using FILES Function",null,"Try Yourself"]
[]
[null,"File Path",null,"File Path"]
[null,"C:\\Users\\user\\Desktop\\ExcelDemy\\*"]
[]
[null,"File Names",null,"File Names"]
[null,{"$f":"IFERROR(INDEX(FileNames,ROW()-7),\"\")","v":"Project A.xlsx"}]
[null,{"$f":"IFERROR(INDEX(FileNames,ROW()-7),\"\")","v":"Project B.xlsx"}]
[null,{"$f":"IFERROR(INDEX(FileNames,ROW()-7),\"\")","v":"Project C.xlsx"}]
[null,{"$f":"IFERROR(INDEX(FileNames,ROW()-7),\"\")","v":"Project D.docx"}]
[null,{"$f":"IFERROR(INDEX(FileNames,ROW()-7),\"\")","v":"Project E.docx"}]

{"sheet":"ExcelDemy","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Name"]
["Project A.xlsx"]
["Project B.xlsx"]
["Project C.xlsx"]
["Project D.docx"]
["Project E.docx"]

{"sheet":"Power Query","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Power Query"]

{"sheet":"All File Names","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA",null,"Try Yourself"]
[]
[null,"File Path",null,"File Path"]
[null,"C:\\Users\\user\\Desktop\\ExcelDemy"]
[]
[null,"File Names",null,"File Names"]
[null,{"$f":"IFERROR(INDEX(GetNames($B$5),ROW()-7),\"\")","v":"Project A.xlsx"}]
[null,{"$f":"IFERROR(INDEX(GetNames($B$5),ROW()-7),\"\")","v":"Project B.xlsx"}]
[null,{"$f":"IFERROR(INDEX(GetNames($B$5),ROW()-7),\"\")","v":"Project C.xlsx"}]
[null,{"$f":"IFERROR(INDEX(GetNames($B$5),ROW()-7),\"\")","v":"Project D.docx"}]
[null,{"$f":"IFERROR(INDEX(GetNames($B$5),ROW()-7),\"\")","v":"Project E.docx"}]

{"sheet":"File Names with Extension","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA",null,"Try Yourself"]
[]
[null,"File Path",null,"File Path"]
[null,"C:\\Users\\user\\Desktop\\ExcelDemy"]
[null,"File Extension",null,"File Extension"]
[null,"xlsx"]
[]
[null,"File Names",null,"File Names"]
[null,{"$f":"IFERROR(INDEX(GetNamesbyExt($B$5,$B$7),ROW()-9),\"\")","v":"Project A.xlsx"}]
[null,{"$f":"IFERROR(INDEX(GetNamesbyExt($B$5,$B$7),ROW()-9),\"\")","v":"Project B.xlsx"}]
[null,{"$f":"IFERROR(INDEX(GetNamesbyExt($B$5,$B$7),ROW()-9),\"\")","v":"Project C.xlsx"}]
[]
[]
[]
[]
[]
[null,{"$f":"IFERROR(INDEX(GetNames_byExt($B$5,$B$7),ROW()-17),\"\")","v":""}]