{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["超入門","フォーム入力","受注データ","請求書"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"受注データ"]
[null,"会社名","商品名","単価","個数","金額"]
["2017-01-01","VBA商事さん","オフィス用コーヒー",330,15,{"$f":"D3*E3","v":4950}]
["2017-01-02","エクセル運輸","オフィス用カフェラテ",360,21,7560]
["2017-01-03","VBA商事","コーヒー豆100g",300,10,3000]
["2017-01-04","関数カンパニー","オフィス用コーヒー",330,18,5940]
["2017-01-05","エクセル運輸","コーヒー豆100g",360,14,5040]
["2017-01-06","表計算コーポ","オフィス用カフェラテ",360,11,3960]
["2017-01-07","パワポ建設","オフィス用コーヒー",330,8,1320]
["2017-01-08","VBA商事","オフィス用カフェラテ",165,3,495]
["2017-01-09","エクセル運輸","コーヒー豆100g",165,5,825]
["2017-01-10","パワポ建設","オフィス用カフェラテ",165,2,330]
["2017-01-11","関数カンパニー","コーヒー豆100g",165,1,165]
["2017-01-12","エクセル運輸","オフィス用コーヒー",165,7,1155]
["2017-01-13","関数カンパニー","コーヒー豆100g",180,6,1080]
["2017-01-14","VBA商事","コーヒー豆100g",150,12,1800]
["2017-01-15","エクセル運輸","オフィス用コーヒー",165,14,2310]
["2017-01-16","VBA商事","オフィス用コーヒー",330,3,990]
["2017-01-17","表計算コーポ","オフィス用カフェラテ",360,9,3240]
["2017-01-18","エクセル運輸","コーヒー豆100g",300,13,3900]
["2017-01-19","VBA商事","コーヒー豆100g",360,11,3960]
["2017-01-20","表計算コーポ","オフィス用カフェラテ",360,7,2520]
["2017-01-21","関数カンパニー","オフィス用コーヒー",330,6,1980]
["2017-01-22","VBA商事","オフィス用カフェラテ",360,5,1800]
["2017-01-23","表計算コーポ","コーヒー豆100g",360,8,2880]
["2017-01-24","関数カンパニー","オフィス用コーヒー",330,9,2970]
["2017-01-25","VBA商事","コーヒー豆100g",360,7,2520]
["2017-01-26","表計算コーポ","オフィス用コーヒー",330,4,1320]
["2017-01-27","関数カンパニー","コーヒー豆100g",360,3,1080]
["2017-01-28","エクセル運輸","オフィス用カフェラテ",360,9,3240]
["2017-01-29","VBA商事","オフィス用カフェラテ",360,13,4680]
["2017-01-30","関数カンパニー","オフィス用コーヒー",330,14,4620]

{"sheet":"フォーム入力","index":1,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,0,3,5]]}
[]
[null,null,null,null,null,null,null,null,"仕入先リスト",null,"商品リスト"]
[null,null,null,null,null,null,null,null,"会社名",null,"商品ID","商品名","原価"]
["仕入れデータ",null,null,null,null,null,null,null,"VBA商事",null,1,"オフィス用コーヒー",2000]
["日付","仕入先","商品ID","商品名","単価","個数",null,null,"エクセル運輸",null,2,"オフィス用カフェラテ",3000]
["2017-12-11","仕入先",5,"緑茶",1500,1,null,null,"パワポ建設",null,3,"コーヒー豆",10000]
["2017-12-11","VBA商事",7,"紙製カップ",800,1,null,null,"関数カンパニー",null,4,"紅茶葉",2000]
["2017-12-11","VBA商事",5,"緑茶",1500,5,null,null,"表計算コーポ",null,5,"緑茶",1500]
["2017-12-11","パワポ建設",6,"特製クッキー",2500,5,null,null,null,null,6,"特製クッキー",2500]
["2017-12-11","表計算コーポ",7,"紙製カップ",800,9,null,null,null,null,7,"紙製カップ",800]
["2017-12-11","関数カンパニー",1,"オフィス用コーヒー",2000,7,null,null,null,null,8,"業務用ストロー",900]
[null,null,null,null,null,null,null,null,null,null,9,"業務用マドラー",1300]

{"sheet":"受注データ","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"受注データ"]
[null,"会社名","商品名","単価","個数","金額"]
[1,"VBA商事","オフィス用コーヒー",330,15,{"$f":"D3*E3","v":4950}]
[2,"エクセル運輸","オフィス用カフェラテ",360,21,{"$f":"D4*E4","v":7560},null,null,null,"▼請求書作成"]
[3,"VBA商事","コーヒー豆100g",300,10,3000,null,null,null,"関数カンパニー"]
[4,"関数カンパニー","オフィス用コーヒー",330,18,5940]
[5,"エクセル運輸","コーヒー豆100g",360,14,5040]
[6,"表計算コーポ","オフィス用カフェラテ",360,11,3960]
[7,"パワポ建設","オフィス用コーヒー",330,8,2640]
[8,"VBA商事","オフィス用カフェラテ",360,3,1080]
[9,"エクセル運輸","コーヒー豆100g",300,5,1500]
[10,"パワポ建設","オフィス用カフェラテ",360,2,720]
[11,"関数カンパニー","コーヒー豆100g",360,1,360]
[12,"エクセル運輸","オフィス用コーヒー",330,7,2310]
[13,"関数カンパニー","コーヒー豆100g",360,6,2160]
[14,"VBA商事","コーヒー豆100g",300,12,3600]
[15,"エクセル運輸","オフィス用コーヒー",330,14,4620]
[16,"VBA商事","オフィス用コーヒー",330,3,990]
[17,"表計算コーポ","オフィス用カフェラテ",360,9,3240]
[18,"エクセル運輸","コーヒー豆100g",300,13,3900]
[19,"VBA商事","コーヒー豆100g",360,11,3960]
[20,"表計算コーポ","オフィス用カフェラテ",360,7,2520]
[21,"関数カンパニー","オフィス用コーヒー",330,6,1980]
[22,"VBA商事","オフィス用カフェラテ",360,5,1800]
[23,"表計算コーポ","コーヒー豆100g",360,8,2880]
[24,"関数カンパニー","オフィス用コーヒー",330,9,2970]
[25,"VBA商事","コーヒー豆100g",360,7,2520]
[26,"表計算コーポ","オフィス用コーヒー",330,4,1320]
[27,"関数カンパニー","コーヒー豆100g",360,3,1080]
[28,"エクセル運輸","オフィス用カフェラテ",360,9,3240]
[29,"VBA商事","オフィス用カフェラテ",360,13,4680]
[30,"関数カンパニー","オフィス用コーヒー",330,14,4620]

{"sheet":"請求書","index":3,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,4],[32,1,32,4],[33,1,33,4],[34,1,34,4]]}
[null,null,null,"発行日：",{"$f":"TODAY()","v":"2017-12-25"}]
[null,null,null,"請求書番号：","A0001",null,null,"デスクトップ出力ファイル名"]
[null,"請求書",null,null,null,null,null,"請求書（VBA商事様）"]
[null,"関数カンパニー",null,null,"株式会社エクセル兄さん"]
[null,"ご担当者","様",null,"〒234-0000"]
[null,"平素は格別のご高配を賜り厚く御礼申し上げます。",null,null,"神奈川県横浜市●●●"]
[null,"下記のとおりご請求申し上げます。"]
[null,"商品名","単価","個数","金額"]
[null,"オフィス用コーヒー",330,18,5940]
[null,"コーヒー豆100g",360,1,360]
[null,"コーヒー豆100g",360,6,2160]
[null,"オフィス用コーヒー",330,6,1980]
[null,"オフィス用コーヒー",330,9,2970]
[null,"コーヒー豆100g",360,3,1080]
[null,"オフィス用コーヒー",330,14,4620]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"税抜 合計",{"$f":"SUM(E9:E28)","v":19110}]
[null,null,null,"消費税(10%)",{"$f":"E29*10%","v":1911}]
[null,null,null,"総額",{"$f":"SUM(E29:E30)","v":21021}]
[]
[null,"＜振込先＞　下記の口座にお振り込み下さい。尚、振込手数料は御社でご負担願います。"]
[null,"エクセル兄さん銀行　●●支店"]
[null,"普通口座　ＸＸＸＸＸＸＸＸ　口座名義　ＸＸＸＸＸ"]
[]
[null,"備考："]