{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["売上","取引先マスタ","請求書"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["取引先CD","取引先名","商品名","数量","税抜単価","税抜金額"]
["T0001","株式会社取引先01","商品名01",9,314,{"$f":"D2*E2","v":2826}]
["T0001","株式会社取引先01","商品名02",28,1643,{"$f":"D3*E3","v":46004}]
["T0001","株式会社取引先01","商品名03",21,1359,28539]
["T0001","株式会社取引先01","商品名04",19,534,10146]
["T0001","株式会社取引先01","商品名05",21,1804,37884]
["T0001","株式会社取引先01","商品名06",18,813,14634]
["T0002","株式会社取引先02","商品名02",15,1643,24645]
["T0002","株式会社取引先02","商品名03",17,1359,23103]
["T0002","株式会社取引先02","商品名05",11,1804,19844]
["T0003","株式会社取引先03","商品名01",7,314,2198]
["T0003","株式会社取引先03","商品名02",19,1643,31217]
["T0003","株式会社取引先03","商品名03",15,1359,20385]
["T0003","株式会社取引先03","商品名05",30,1804,54120]
["T0003","株式会社取引先03","商品名06",29,813,23577]
["T0003","株式会社取引先03","商品名07",8,1518,12144]
["T0003","株式会社取引先03","商品名08",22,1169,25718]

{"sheet":"取引先マスタ","index":1,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["取引先CD","取引先名","郵便番号","住所1","住所2"]
["T0001","株式会社取引先01","001-0001","○○県××市△△1","□□ビル1階"]
["T0002","株式会社取引先02","001-0002","○○県××市△△2"]
["T0003","株式会社取引先03","001-0003","○○県××市△△3","□□ビル2階"]

{"sheet":"請求書","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["請求書"]
["株式会社取引先01",null,null,null,"請求№：","xxx-xxxxx"]
["〒001-0001",null,null,null,"請求日：","2021-01-31"]
["○○県××市△△1"]
["□□ビル1階",null,null,null,"VBA100本ノック"]
[null,null,null,null,"日本のどこかにあるかも"]
["ご請求金額",{"$f":"E27","v":154036},null,null,"TEL:xx-xxxx-xxxx"]
[]
["品名",null,"数量","単価","金額","摘要"]
["商品名01",null,9,314,{"$f":"C10*D10","v":2826}]
["商品名02",null,28,1643,{"$f":"C11*D11","v":46004}]
["商品名03",null,21,1359,28539]
["商品名04",null,19,534,10146]
["商品名05",null,21,1804,37884]
["商品名06",null,18,813,14634]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,"小計",{"$f":"SUM(E10:E24)","v":140033}]
[null,null,null,0.1,{"$f":"ROUNDDOWN(E25*D26,0)","v":14003}]
[null,null,null,"合計",{"$f":"E25+E26","v":154036}]