{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Menu","Interface","Config","Validation","OutputLayout","ImportData","OutputData","Help","MasterLookup_1","MasterLookup_2","MasterLookup_3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Interface","index":1,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["対象シート","対象列","参照元列","入力タイプ","選択肢/ロジックキー",null,null,"対象シート","参照元キー","対象列","入力タイプ","選択肢"]
["shSysConfig","2","1","LIST_REF","",null,null,"shSysConfig","System","3","LIST",""]
["shSysConfig","3","2","DETAIL","",null,null,"shSysConfig","InitialDir","3","PATH",""]
["shMstValidation","4","","LIST","Require,Length,FixedLength,SpecificValue,TodayCompare,DateCompare,CharType_Half,UNIQUE,None",null,null,"shSysConfig","AllowExportWithErrors","3","LIST","All,ValidOnly,Stop"]
["shMstValidation","5","4","DETAIL","",null,null,"shSysConfig","TargetExtensions","3","FREE",""]
["shMstValidation","6","4","DETAIL","",null,null,"shSysConfig","CsvExport","3","LIST",""]
["shSysOutputLayout","3","","LIST","DIRECT,FIXED,CURRENTDATE,PRCONCAT,LOOKUP,LEFT,RIGHT,EXTRACTRIGHT,EXTRACTLEFT",null,null,"shSysConfig","Encoding","3","LIST","Shift-JIS,UTF-8,UTF-8-BOM"]
["shSysOutputLayout","4","3","DETAIL","",null,null,"shSysConfig","InclHeader","3","LIST","True,False"]
[null,null,null,null,null,null,null,"shSysConfig","HeaderRows","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","AutoOpenFolder","3","LIST","True,False"]
[null,null,null,null,null,null,null,"shSysConfig","EncloseQuotes","3","LIST","True,False"]
[null,null,null,null,null,null,null,"shSysConfig","AllowCsvWithErrors","3","LIST","All,ValidOnly,Stop"]
[null,null,null,null,null,null,null,"shSysConfig","DefaultFileName","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","MasterLookup","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","SheetName","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","Description","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","ImportData","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","Output","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","OutputLayout","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","TargetSheetName","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","TargetStartRow","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","TargetStartCol","3","FREE",""]
[null,null,null,null,null,null,null,"shSysConfig","System","2","LIST","InitialDir,TargetExtensions,AllowExportWithErrors"]
[null,null,null,null,null,null,null,"shSysConfig","CsvExport","2","LIST","Encoding,InclHeader,HeaderRows,AllowCsvWithErrors,DefaultFileName,AutoOpenFolder,EncloseQuotes"]
[null,null,null,null,null,null,null,"shSysConfig","MasterLookup","2","LIST","SheetName,Description"]
[null,null,null,null,null,null,null,"shSysConfig","ImportData","2","LIST","TargetSheetName,TargetStartRow,TargetStartCol"]
[null,null,null,null,null,null,null,"shSysConfig","Output","2","LIST","TargetSheetName,TargetStartRow,TargetStartCol"]
[null,null,null,null,null,null,null,"shSysConfig","OutputLayout","2","LIST","TargetSheetName,TargetStartRow,TargetStartCol"]
[null,null,null,null,null,null,null,"shMstValidation","SpecificValue","5","FREE",""]
[null,null,null,null,null,null,null,"shMstValidation","SpecificValue","6","LIST","=,<>,>,<,>=,<="]
[null,null,null,null,null,null,null,"shMstValidation","TodayCompare","5","LIST","<,<=,=,>=,>"]
[null,null,null,null,null,null,null,"shMstValidation","TodayCompare","6","LIST","=,<>,>,<,>=,<="]
[null,null,null,null,null,null,null,"shMstValidation","DateCompare","5","FREE",""]
[null,null,null,null,null,null,null,"shMstValidation","DateCompare","6","LIST","=,<>,>,<,>=,<="]
[null,null,null,null,null,null,null,"shMstValidation","Length","5","FREE",""]
[null,null,null,null,null,null,null,"shMstValidation","Length","6","FREE",""]
[null,null,null,null,null,null,null,"shMstValidation","FixedLength","5","FREE",""]
[null,null,null,null,null,null,null,"shMstValidation","FixedLength","6","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","Require","5","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","Require","6","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","None","5","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","None","6","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","CharType_Half","5","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","CharType_Half","6","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","UNIQUE","5","DISABLED",""]
[null,null,null,null,null,null,null,"shMstValidation","UNIQUE","6","DISABLED",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","DIRECT","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","FIXED","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","CURRENTDATE","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","PRCONCAT","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","LOOKUP","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","LEFT","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","RIGHT","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","EXTRACTRIGHT","4","FREE",""]
[null,null,null,null,null,null,null,"shSysOutputLayout","EXTRACTLEFT","4","FREE",""]

{"sheet":"Config","index":2,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["カテゴリ1","カテゴリ2","値"]
["System","InitialDir","F:\\Development\\Antigravity\\ExcelVBA\\ExcelVBA_FlexibleDataRefiner\\_sampleCSV"]
["System","TargetExtensions","csv"]
["System","AllowExportWithErrors","ALL"]
["ImportData_加入","TargetSheetName","ImportData"]
["ImportData_加入","TargetStartRow",10]
["ImportData_加入","TargetStartCol",2]
["Output_加入","TargetSheetName","OutputData"]
["Output_加入","TargetStartRow",10]
["Output_加入","TargetStartCol",2]
["OutputLayout_加入","TargetSheetName","OutputLayout"]
["OutputLayout_加入","TargetStartRow",1]
["OutputLayout_加入","TargetStartCol",1]
["CsvExport","Encoding","Shift-JIS"]
["CsvExport","InclHeader",true]
["CsvExport","HeaderRows",1]
["CsvExport","AllowCsvWithErrors","ALL"]
["CsvExport","DefaultFileName","テスト用アウトプット"]
["CsvExport","AutoOpenFolder",true]
["CsvExport","EncloseQuotes",false]
["MasterLookup_1","SheetName","MasterLookup_1"]
["MasterLookup_1","Description","汎用読替表1"]
["MasterLookup_2","SheetName","MasterLookup_2"]
["MasterLookup_2","Description","汎用読替表2"]
["MasterLookup_3","SheetName","MasterLookup_3"]
["MasterLookup_3","Description","汎用読替表3"]

{"sheet":"Validation","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["No","対象シート名","対象項目名","ルール種別","パラメータ1","パラメータ2","エラーメッセージ"]
["1","ImportData","顧客ID","FixedLength","4","","顧客IDは4桁です"]
["2","ImportData","注文ID","None","","",""]
["3","ImportData","商品CD","None","","","値のチェックは行いませんが必須項目です"]
["4","ImportData","数量","SpecificValue","0",">","数量は1以上である必要があります"]
["5","ImportData","注文日","TodayCompare","<","","注文日は本日より前の日付である必要があります"]
["6","OutputData","注文日","Require","","","注文日は必須です。"]
["7","OutputData","氏名","None","","",""]
["8","OutputData","商品コード","None","","",""]
["9","OutputData","注文ID2","None","","",""]
["10","OutputData","顧客ID2","None","","",""]
["11","OutputData","商品CD2","None","","",""]
["12","OutputData","商品名","SpecificValue","#N/A","<>","商品名が不正です。"]
["13","OutputData","注文ID","Require","","","ユーザーIDは出力必須です"]
["14","OutputData","顧客ID","Require","","","顧客IDは必須です。"]
["15","OutputData","商品コード","Require","","","商品コードは必須です。"]
["16","OutputData","商品名","Require","","","商品名は必須です。"]
["17","OutputData","数量","Require","","","数量は必須です。"]

{"sheet":"OutputLayout","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["No","出力項目名","変換種別","パラメータ1","パラメータ2","パラメータ3","パラメータ４"]
[1,"注文ID","DIRECT","注文ID"]
[2,"顧客ID","DIRECT","顧客ID"]
[3,"氏名","LOOKUP","MasterLookup_2","顧客ID","氏名"]
[4,"商品コード","DIRECT","商品CD"]
[5,"商品名","LOOKUP","MasterLookup_1","商品コード","商品名","商品CD"]
[6,"数量","DIRECT","数量"]
[7,"注文日","DIRECT","注文日"]
[8,"注文ID2","EXTRACTRIGHT","注文ID","-"]
[9,"顧客ID2","RIGHT","顧客ID",1]
[10,"商品CD2","LEFT","商品CD",2]

{"sheet":"ImportData","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["バリデーションチェック結果","注文ID","顧客ID","商品CD","数量","注文日"]
[null,"ORD-001","1001","P001","1","2026/02/20"]
[null,"ORD-002","1001","P002","1","2026/02/20"]
[null,"ORD-003","1002","P005","2","2026/02/25"]

{"sheet":"OutputData","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["バリデーションチェック結果","注文ID","顧客ID","氏名","商品コード","商品名","数量","注文日","注文ID2","顧客ID2","商品CD2"]
[null,"ORD-001","1001","山田 太郎","P001","高性能ノートPC","1","2026/02/20","001","1","P0"]
[null,"ORD-002","1001","山田 太郎","P002","ワイヤレスマウス","1","2026/02/20","002","1","P0"]
["エラーあり","ORD-003","1002","鈴木 花子","P005","#N/A","2","2026/02/25","003","2","P0"]

{"sheet":"Help","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["各シートの目的と使い方"]

{"sheet":"MasterLookup_1","index":8,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["商品コード","商品名","価格","カテゴリ"]
["P001","高性能ノートPC","150000","PC"]
["P002","ワイヤレスマウス","5000","周辺機器"]
["P003","27インチモニター","35000","周辺機器"]

{"sheet":"MasterLookup_2","index":9,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["顧客ID","氏名","年齢","登録日"]
["1001","山田 太郎","35","2026/1/15"]
["1002","鈴木 花子","28","2026/2/1"]
["1003","佐藤 一郎","42","2026/2/10"]

{"sheet":"MasterLookup_3","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}