{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["menu","result","uncheck","check1","check2","param"],"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":"menu","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Excelシート セル比較ツール"]
[]
[]
[]
[]
[]
["①","『メニュー表示』ボタンをクリックし、メニューを表示。"]
["②","比較するCSVファイル名を設定。"]
["③","『CSVファイル読込』ボタンをクリックし、読み込む。"]
[null,"データをすべてテキストとして読み込む。（頭にシングルコートを付与）「0」と「000」などの比較をする為。"]
["④","チェック範囲が③で自動設定されるので、範囲を変えたい場合は修正する。"]
["⑤","比較対象外にしたい列がある場合は『シート：uncheck』に『*』を入力する。"]
[null,"（タイムスタンプが設定されている列 等）"]
["⑥","『比較処理開始』ボタンをクリックし、比較を実行する。"]
[null,"『シート：result』に結果が表示されるので確認する。"]
[]
[null,"差異がある行には『■』が表示され、薄橙色になる。",null,null,null,null,null,null,null,null,null,"差異 行"]
[null,"差異があるセルには『シート：check1のデータ<>シート：check2のデータ』で表示され、橙色になる。",null,null,null,null,null,null,null,null,null,"差異 セル"]
[null,"比較対象外の列は灰色になる。",null,null,null,null,null,null,null,null,null,"対象外 列"]

{"sheet":"result","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Check","番号","氏名","国語","英語","数学","出力日"]
[null,1001,"佐藤 一郎",90,85,70,"2021-06-30"]
["■",1002,"鈴木 太郎<>鈴木　太郎",81,"81<>80",78,"2021-06-30"]
[null,1003,"山本 次郎",92,89,75,"2021-06-30"]
["■","001004<>1004","松山 三郎",65,91,79,"2021-06-30"]
["■",1005,"菊池 四郎",78,78,"71<>72","2021-06-30"]

{"sheet":"uncheck","index":2,"n_rows":5,"n_cols":52,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},{"$f":"COLUMN()","v":46},{"$f":"COLUMN()","v":47},{"$f":"COLUMN()","v":48},{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50},{"$f":"COLUMN()","v":51},{"$f":"COLUMN()","v":52}]
["番号","氏名","国語","英語","数学","出力日"]
[null,null,null,null,null,"*"]
[]
["↑ 3行目に『*』を入力するとチェック対象外とする。"]

{"sheet":"check1","index":3,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["番号","氏名","国語","英語","数学","出力日"]
["001001","佐藤 一郎","90","85","70","2021/06/29"]
["001002","鈴木 太郎","81","81","78","2021/06/29"]
["001003","山本 次郎","92","89","75","2021/06/29"]
["001004","松山 三郎","65","91","79","2021/06/29"]
["001005","菊池 四郎","78","78","71","2021/06/29"]

{"sheet":"check2","index":4,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["番号","氏名","国語","英語","数学","出力日"]
["001001","佐藤 一郎","90","85","70","2021/06/30"]
["001002","鈴木　太郎","81","80","78","2021/06/30"]
["001003","山本 次郎","92","89","75","2021/06/30"]
["1004","松山 三郎","65","91","79","2021/06/30"]
["001005","菊池 四郎","78","78","72","2021/06/30"]

{"sheet":"param","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["シート名1","check1"]
["シート名2","check2"]
["結果表示","result"]
["範囲 行",6]
["範囲 列",6]
["CSV1","D:\\210629-成績.csv"]
["CSV2","D:\\210630-成績.csv"]