{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["概要","機能","サンプルコード実行"],"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":"概要","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,0,13,0]]}
["項目","本文"]
["呼称","正規表現抽出クラス"]
["URL","https://it.sifr.me/product/vba-extractor-class/"]
["最終更新日","2023-03-25"]
["クラス名","ClassExtractor"]
["目的","Excel, Access, Outlookでの文字列抽出効率化"]
["前提："]
["　利用元","Excel, Access, Outlook 2016"]
["　利用ライブラリ","Microsoft VBScript Regular Expressions 5.5\n（要VBA参照設定追加）"]
["　構成","クラスとして配置。外部からインスタンス化して利用"]
["方針："]
["　処理速度","バッチ的利用が出来れば問題なし\n※がっつり速度チューニングする気なし"]
["　処理方式","初期処理→｛設定→抽出→｝＊ｎ→終了処理　の流れ"]
[null,"途中過程を保持しないシーケンシャルなフローでの利用"]
["　キャッシュ","しない　※直前の判定結果のみ"]

{"sheet":"機能","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["状態","項目","関数","本文"]
["実装済","設定初期化","Configure","正規表現パターン、\n大文字小文字の区別（True：する）、\n複数行対応（True：する）の設定を初期化"]
["実装済","一致確認","Test","一致するか確認"]
["実装済","一致件数確認","Count","一致件数確認"]
["実装済","単数抽出","Match","パターン初回ヒット文字列を取得"]
["実装済",null,"MatchPartial","パターン初回ヒット文字列の最初のグループを取得"]
["実装済",null,"UnmatchHead","パターン初回ヒット文字列不一致の文字列頭部分を取得"]
["実装済",null,"UnmatchTail","パターン初回ヒット文字列不一致の文字列尻尾部分を取得"]
["実装済","複数抽出","Matches","パターンヒット文字列を配列として取得"]
["実装済",null,"MatchesPartial","パターンヒット文字列の最初のグループを配列として取得"]
["未実装",null,"Unmatches","パターンヒット文字列不一致の文字列を配列として取得"]
["実装済","単数置換","ReplacePartial","パターン初回ヒット文字列を置換した文字列を取得"]
["実装済","複数置換","ReplaceAll","パターンヒット文字列を置換した文字列を取得"]

{"sheet":"サンプルコード実行","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ボタンをクリックするとModuleTest　の　Sub Run()　を実行します。"]