{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["表紙","資料一覧","X-Ref","ファイル一覧","除外Dir"],"not_rendered":{"charts":0,"images":1,"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":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"↓検索Dir ","(最右端の\\は有っても無くても可）",null,null,"C:\\Users\\hitos\\OneDrive\\ドキュメント\\web_info\\www\\gdb_neo\\"]
[]
[]
[null,null,"CNT","CNTDir"]
[null,"処理 Dir ↓",445,444]
[]
[]
[]
[]
[]
[]
[]
[null,true]
[]
[]
[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演算で判定するようにした","2018-04-27"]
["※","oneDriveのせいか、コピーを保存すると https://d.docs.live.net/～ が処理Dir （B6セル）に表示されるようになった。この場合は一度閉じて、エクスプローラから開きなおすとDir検索が正しく行えるようになる。この件の仕様変更は未対応！！"]
[]
[]
[]
["X-Ref版"]
[10,"手順１）検査したいフォルダの資料一覧を作成する","2018-06-20"]
[null,"手順２）X-Refシートに検索したい文字列を記入（d4セル）"]
[null,"手順３）X-Refシートに対象ファイルの拡張子を記入（d6,d7,d8セル）"]
[null,"手順４）X-Refシートも文字列検索ボタンで実行する"]
[null,"  　　　　UTF-8のファイルは漢字が文字化けします"]
[11,"UTF-8対応","2020-04-10"]
[null,"件数カウント項目の倍精度対応 （integer → long）（d3セル）","2020-04-30"]
[12,"大文字小文字区別のtrue/false 指定追加","2020-05-08"]
[null,"_1 andキーワード　追加","2020-05-12"]

{"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":"X-Ref","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"code","utf-8"]
[null,null,"大小区別",false]
[null,null,"探す文字列"]
[null,null,{"$f":"\"andキーワード \"&LEN(D5)","v":"andキーワード 0"}]
[null,null,"対象拡張子","php"]
[null,null,"（右３文字）","tpl"]
[null,null,"（最大３個）","xml"]
[]
["No","ファイル名","行No","対象テキスト　（UTF-8の漢字はcodeにutf-8を設定すること）","資料一覧のrow","フォルダ","Link","full path"]

{"sheet":"ファイル一覧","index":3,"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":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No","除外Dir"]