{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["表紙","資料一覧","ファイル一覧","除外Dir"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"表紙","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"↓検索Dir ","(最右端の\\は有っても無くても可）",null,null,"C:\\Users\\hitos\\OneDrive\\ドキュメント\\Excel Work\\"]
[]
[]
[null,null,"CNT","CNTDir"]
[null,"処理 Dir ↓",51,2]
[]
[]
[]
[]
[]
[]
[]
[null,false]
[]
[]
[1,"vbArchive　32　対応","2011-09-06"]
[2,"DateLastModified 追加","2012-11-07"]
[3,"資料一覧シート作成追加","2014-07-03"]
[4,"Dir空白の時はThisWorkbook.pathセット","2015-11-13"]
[5,"Dir関数でエラーになるDirを除外して記録する","2016-04-27"]
[6,"更新ボタンを押した時に最終更新日を表示","2016-06-29"]
[7,"検索Dir を最初の状態に戻す\n（空白の時は空白にする）","2016-07-06"]
[8,"フォルダのDateLastModified 追加","2017-10-23"]
[8,"下層表示オプション 追加","2017-10-23"]
[9,"資料が無い時のBUG対応","2017-10-30"]
[null,"（maxrowをrows.countとend(xlUP).rowで求める）"]
[10,"File属性が変わって11bit目が付いたので、5bitだけをbit演算で判定するようにした（vbDirectory）","2018-04-27"]
["※","oneDriveのせいか、コピーを保存（自動保存オンの時）で名前を変えた後に 「資料一覧作成」を実行すると、ThisWorkbook.Path　に　https://d.docs.live.net/～が入って ファイル一覧や資料一覧が作成されなくなった。B6の処理Dirにも　https://d.docs.live.net/～が表示される。\n自動保存をオフにして名前を付けて保存にしても同じ現象になる。\n上書き保存では、この現象は起きない。\nこの回避方法はB2に対象のpathを入力するか、一度Bookを閉じてエクスプローラから開きなおすと、正しく処理される。\n今のところ、この現象を回避する仕様変更を行う予定はない。","2018/4/27\n13:31"]

{"sheet":"資料一覧","index":1,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["No","Link","ファイル名","ファイルＳＩＺＥ","フォルダSIZE","Ａｔｔ","Dir","Full path","DateLastModified","Link\\","フォルダ"]
[{"$f":"ROW()-1","v":1},{"$f":"HYPERLINK(H2,\"●\")","v":"●"},null,null,null,null,null,null,null,{"$f":"HYPERLINK(G2,\"￥\")","v":"￥"},{"$f":"RIGHT(G2,LEN(G2)-LEN(Ｄｉｒ_path指定))","v":{"$error":"#VALUE!"}}]

{"sheet":"ファイル一覧","index":2,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No","ファイル名","ファイルＳＩＺＥ","フォルダSIZE","Ａｔｔ","Dir","Full path","DateLastModified",null,null,null,null,13]

{"sheet":"除外Dir","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No","除外Dir"]