{"text_format":"1","workbook":"xlsx","n_sheets":2,"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":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["品番","品名","単価","個数","金額",null,"Concatenation"]
[1,{"$f":"IFERROR(VLOOKUP(A2,商品!A:C,2,FALSE),\"\")","v":"りんご"},{"$f":"IFERROR(VLOOKUP(A2,商品!A:C,3,FALSE),\"\")","v":100},10,{"$f":"IFERROR(C2*D2,0)","v":1000},null,null,"※各行を改行（Chr$(13)）で結合"]
[2,{"$f":"IFERROR(VLOOKUP(A3,商品!A:C,2,FALSE),\"\")","v":"バナナ"},{"$f":"IFERROR(VLOOKUP(A3,商品!A:C,3,FALSE),\"\")","v":80},15,{"$f":"IFERROR(C3*D3,0)","v":1200}]
[3,{"$f":"IFERROR(VLOOKUP(A4,商品!A:C,2,FALSE),\"\")","v":"みかん"},{"$f":"IFERROR(VLOOKUP(A4,商品!A:C,3,FALSE),\"\")","v":50},20,1000,null,null,"※各行をラインフィード（Chr$(10)）で結合"]
[4,{"$f":"IFERROR(VLOOKUP(A5,商品!A:C,2,FALSE),\"\")","v":"グレープ"},{"$f":"IFERROR(VLOOKUP(A5,商品!A:C,3,FALSE),\"\")","v":120},25,3000]
[5,{"$f":"IFERROR(VLOOKUP(A6,商品!A:C,2,FALSE),\"\")","v":"ストロベリー"},{"$f":"IFERROR(VLOOKUP(A6,商品!A:C,3,FALSE),\"\")","v":150},30,4500]
[6,{"$f":"IFERROR(VLOOKUP(A7,商品!A:C,2,FALSE),\"\")","v":"パイナップル"},{"$f":"IFERROR(VLOOKUP(A7,商品!A:C,3,FALSE),\"\")","v":200},35,7000]
[7,{"$f":"IFERROR(VLOOKUP(A8,商品!A:C,2,FALSE),\"\")","v":"メロン"},{"$f":"IFERROR(VLOOKUP(A8,商品!A:C,3,FALSE),\"\")","v":300},40,12000]
[8,{"$f":"IFERROR(VLOOKUP(A9,商品!A:C,2,FALSE),\"\")","v":"キウイ"},{"$f":"IFERROR(VLOOKUP(A9,商品!A:C,3,FALSE),\"\")","v":90},45,4050]
[9,{"$f":"IFERROR(VLOOKUP(A10,商品!A:C,2,FALSE),\"\")","v":"パイチャート"},{"$f":"IFERROR(VLOOKUP(A10,商品!A:C,3,FALSE),\"\")","v":180},50,9000]
[10,{"$f":"IFERROR(VLOOKUP(A11,商品!A:C,2,FALSE),\"\")","v":"マンゴー"},{"$f":"IFERROR(VLOOKUP(A11,商品!A:C,3,FALSE),\"\")","v":160},55,8800]
[null,{"$f":"IFERROR(VLOOKUP(A12,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A12,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A13,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A13,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A14,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A14,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A15,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A15,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A16,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A16,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A17,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A17,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A18,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A18,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A19,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A19,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A20,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A20,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A21,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A21,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A22,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A22,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A23,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A23,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A24,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A24,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A25,商品!A:C,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A25,商品!A:C,3,FALSE),\"\")","v":""},null,0]
[null,null,null,null,0]

{"sheet":"商品","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["品番","品名","単価"]
[1,"りんご",100]
[2,"バナナ",80]
[3,"みかん",50]
[4,"グレープ",120]
[5,"ストロベリー",150]
[6,"パイナップル",200]
[7,"メロン",300]
[8,"キウイ",90]
[9,"パイチャート",180]
[10,"マンゴー",160]
[11,"ピーチ",130]
[12,"レモン",70]
[13,"ライチ",110]
[14,"オレンジ",60]
[15,"アプリコット",140]
[16,"キウイフルーツ",170]
[17,"グレープフルーツ",190]
[18,"ブルーベリー",220]
[19,"クランベリー",250]
[20,"パッションフルーツ",280]