{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["請求書","請求書 (2)","商品T","mail形式","顧客リスト"],"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":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,1,13,2],[32,0,32,6],[0,0,0,6],[1,0,2,3],[10,0,11,0],[10,1,11,3],[7,0,8,0]]}
["請　求　書"]
["らくだ株式会社 御中",null,null,null,null,"No",1001]
[null,null,null,null,null,"請求日","2022-04-30"]
[]
["下記のとおり、御請求申し上げます。",null,null,null,null,"らくだ株式会社"]
["件名","PDF作成からメール送信",null,null,null,"〒100-0001"]
["支払期限","2022-05-31",null,null,null,"東京都千代田区千代田1-1-1"]
["振込先","らくだ銀行 本店 普通 1111111",null,null,null,"らくだビル3階"]
[null,"らくだ（カ",null,null,null,"TEL：03-0000-0000"]
[null,null,null,null,null,"担当：らくだ太郎"]
["合計",{"$f":"G31","v":10252}]
[]
[]
["商品コード","摘要",null,"数量","単位","単価","金額"]
[1,{"$f":"IF(A15=\"\",\"\",VLOOKUP(請求書!A15,商品T!$A:$C,2,0))","v":"りんご"},null,10,"個",{"$f":"IF(A15=\"\",\"\",VLOOKUP(請求書!A15,商品T!$A:$C,3,0))","v":100},{"$f":"IF(AND(D15<>\"\", F15<>\"\"),D15*F15,\"\")","v":1000}]
[3,{"$f":"IF(A16=\"\",\"\",VLOOKUP(請求書!A16,商品T!$A:$C,2,0))","v":"みかん"},null,2,"個",{"$f":"IF(A16=\"\",\"\",VLOOKUP(請求書!A16,商品T!$A:$C,3,0))","v":80},{"$f":"IF(AND(D16<>\"\", F16<>\"\"),D16*F16,\"\")","v":160}]
[5,{"$f":"IF(A17=\"\",\"\",VLOOKUP(請求書!A17,商品T!$A:$C,2,0))","v":"ぶどう"},null,65,"個",{"$f":"IF(A17=\"\",\"\",VLOOKUP(請求書!A17,商品T!$A:$C,3,0))","v":120},7800]
[6,{"$f":"IF(A18=\"\",\"\",VLOOKUP(請求書!A18,商品T!$A:$C,2,0))","v":"キウイ"},null,4,"個",{"$f":"IF(A18=\"\",\"\",VLOOKUP(請求書!A18,商品T!$A:$C,3,0))","v":90},360]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(請求書!A19,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A19=\"\",\"\",VLOOKUP(請求書!A19,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(請求書!A20,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A20=\"\",\"\",VLOOKUP(請求書!A20,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(請求書!A21,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A21=\"\",\"\",VLOOKUP(請求書!A21,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(請求書!A22,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A22=\"\",\"\",VLOOKUP(請求書!A22,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(請求書!A23,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A23=\"\",\"\",VLOOKUP(請求書!A23,商品T!$A:$C,3,0))","v":""},{"$f":"IF(AND(D23<>\"\", F23<>\"\"),D23*F23,\"\")","v":""}]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(請求書!A24,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A24=\"\",\"\",VLOOKUP(請求書!A24,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(請求書!A25,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A25=\"\",\"\",VLOOKUP(請求書!A25,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(請求書!A26,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A26=\"\",\"\",VLOOKUP(請求書!A26,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(請求書!A27,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A27=\"\",\"\",VLOOKUP(請求書!A27,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(請求書!A28,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A28=\"\",\"\",VLOOKUP(請求書!A28,商品T!$A:$C,3,0))","v":""},""]
[null,null,null,null,null,"小計",{"$f":"SUM(G15:G28)","v":9320}]
[null,null,null,null,null,"消費税",{"$f":"G29*0.1","v":932}]
[null,null,null,null,null,"合計",{"$f":"G29+G30","v":10252}]
[]
["備考"]

{"sheet":"請求書 (2)","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,6],[0,0,0,6],[1,0,2,3],[7,0,8,0],[10,0,11,0],[10,1,11,3],[13,1,13,2]]}
["請　求　書"]
["らくだ株式会社 御中",null,null,null,null,"No",1001]
[null,null,null,null,null,"請求日","2022-04-30"]
[]
["下記のとおり、御請求申し上げます。",null,null,null,null,"らくだ株式会社"]
["件名","PDF作成からメール送信",null,null,null,"〒100-0001"]
["支払期限","2022-05-31",null,null,null,"東京都千代田区千代田1-1-1"]
["振込先","らくだ銀行 本店 普通 1111111",null,null,null,"らくだビル3階"]
[null,"らくだ（カ",null,null,null,"TEL：03-0000-0000"]
[null,null,null,null,null,"担当：らくだ太郎"]
["合計",{"$f":"G31","v":10252}]
[]
[]
["商品コード","摘要",null,"数量","単位","単価","金額"]
[1,{"$f":"IF(A15=\"\",\"\",VLOOKUP('請求書 (2)'!A15,商品T!$A:$C,2,0))","v":"りんご"},null,10,"個",{"$f":"IF(A15=\"\",\"\",VLOOKUP('請求書 (2)'!A15,商品T!$A:$C,3,0))","v":100},{"$f":"IF(AND(D15<>\"\", F15<>\"\"),D15*F15,\"\")","v":1000}]
[3,{"$f":"IF(A16=\"\",\"\",VLOOKUP('請求書 (2)'!A16,商品T!$A:$C,2,0))","v":"みかん"},null,2,"個",{"$f":"IF(A16=\"\",\"\",VLOOKUP('請求書 (2)'!A16,商品T!$A:$C,3,0))","v":80},{"$f":"IF(AND(D16<>\"\", F16<>\"\"),D16*F16,\"\")","v":160}]
[5,{"$f":"IF(A17=\"\",\"\",VLOOKUP('請求書 (2)'!A17,商品T!$A:$C,2,0))","v":"ぶどう"},null,65,"個",{"$f":"IF(A17=\"\",\"\",VLOOKUP('請求書 (2)'!A17,商品T!$A:$C,3,0))","v":120},7800]
[6,{"$f":"IF(A18=\"\",\"\",VLOOKUP('請求書 (2)'!A18,商品T!$A:$C,2,0))","v":"キウイ"},null,4,"個",{"$f":"IF(A18=\"\",\"\",VLOOKUP('請求書 (2)'!A18,商品T!$A:$C,3,0))","v":90},360]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP('請求書 (2)'!A19,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A19=\"\",\"\",VLOOKUP('請求書 (2)'!A19,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP('請求書 (2)'!A20,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A20=\"\",\"\",VLOOKUP('請求書 (2)'!A20,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP('請求書 (2)'!A21,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A21=\"\",\"\",VLOOKUP('請求書 (2)'!A21,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP('請求書 (2)'!A22,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A22=\"\",\"\",VLOOKUP('請求書 (2)'!A22,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A23=\"\",\"\",VLOOKUP('請求書 (2)'!A23,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A23=\"\",\"\",VLOOKUP('請求書 (2)'!A23,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP('請求書 (2)'!A24,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A24=\"\",\"\",VLOOKUP('請求書 (2)'!A24,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP('請求書 (2)'!A25,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A25=\"\",\"\",VLOOKUP('請求書 (2)'!A25,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP('請求書 (2)'!A26,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A26=\"\",\"\",VLOOKUP('請求書 (2)'!A26,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP('請求書 (2)'!A27,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A27=\"\",\"\",VLOOKUP('請求書 (2)'!A27,商品T!$A:$C,3,0))","v":""},""]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP('請求書 (2)'!A28,商品T!$A:$C,2,0))","v":""},null,null,"個",{"$f":"IF(A28=\"\",\"\",VLOOKUP('請求書 (2)'!A28,商品T!$A:$C,3,0))","v":""},""]
[null,null,null,null,null,"小計",{"$f":"SUM(G15:G28)","v":9320}]
[null,null,null,null,null,"消費税",{"$f":"G29*0.1","v":932}]
[null,null,null,null,null,"合計",{"$f":"G29+G30","v":10252}]
[]
["備考"]

{"sheet":"商品T","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["商品コード","商品名","価格"]
[1,"りんご",100]
[2,"ばなな",150]
[3,"みかん",80]
[4,"いちご",200]
[5,"ぶどう",120]
[6,"キウイ",90]
[7,"メロン",300]
[8,"パイナップル",180]
[9,"マンゴー",250]
[10,"スイカ",150]

{"sheet":"mail形式","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["会社コード","会社名","宛先"]
[1,{"$f":"IF(A2=\"\",\"\",VLOOKUP(A2,顧客リスト!$A:$C,2,0))","v":"イマジナリテック株式会社"},{"$f":"IF(A2=\"\",\"\",VLOOKUP(A2,顧客リスト!$A:$C,3,0))","v":0}]
["件名","請求書の送付"]
["本文","お世話になっております。\nご担当者様へ請求書の送付についてご連絡いたします。\n\n添付ファイルにて、請求書のPDFをお送りいたします。ご確認いただき、\nお支払い手続きをお願いいたします。\n\n請求書の詳細についてご不明点やご質問がございましたら、お気軽にお知らせください。\n引き続きご愛顧賜りますよう、よろしくお願い申し上げます。\n\n何卒、ご確認とご対応のほど、よろしくお願いいたします。\n\n敬具\n$会社名\n\n\n\n"]

{"sheet":"顧客リスト","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["会社コード","会社名","宛先"]
[1,"イマジナリテック株式会社"]
[2,"ファンタシーコーポレーション"]
[3,"ビジョンレアリティグループ"]