{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["管理表","Data","請求明細"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["顧客管理№","名称"]
[1,"株式会社A"]
[2,"B株式会社"]
[3,"A商店"]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]

{"sheet":"Data","index":1,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["顧客管理番号","出荷日","お問合せNO","届先社名","支店名称","品番","数量","請求金額"]
[1,20210120,123456990006,"株式会社E","黒部","A",1,1000]
[1,20210120,123456990010,"株式会社E","黒部","A",2,2000]
[1,20210120,123456990021,"株式会社E","黒部","A",3,3000]
[1,20210120,123456990032,"株式会社E","黒部","A",4,4000]
[1,20210120,123456990043,"株式会社E","黒部","A",5,5000]
[1,20210120,123456990054,"株式会社E","黒部","A",6,6000]
[1,20210120,123456990065,"株式会社E","黒部","A",1,1000]
[1,20210120,123456990076,"株式会社E","富山","A",2,2000]
[1,20210120,123456990080,"株式会社E","富山","A",3,3000]
[1,20210120,123456990091,"株式会社E","富山","A",4,4000]
[1,20210120,123456990102,"株式会社E","富山","A",5,5000]
[1,20210220,123456990113,"株式会社E","富山","A",6,6000]
[1,20210220,123456990124,"株式会社E","富山","B",1,1000]
[1,20210220,123456990135,"株式会社E","富山","B",2,2000]
[1,20210220,123456990146,"株式会社E","富山","B",3,3000]
[1,20210220,123456990150,"株式会社E","高岡","B",4,4000]
[1,20210220,123456990161,"株式会社E","高岡","B",5,5000]
[1,20210220,123456990172,"株式会社E","高岡","B",6,6000]
[1,20210220,123456990183,"株式会社E","高岡","B",1,1000]
[1,20210220,123456990194,"株式会社E","高岡","B",2,2000]
[1,20210220,123456990205,"株式会社F","高岡","B",3,3000]
[1,20210220,123456990216,"株式会社F","高岡","B",4,4000]
[1,20210220,123456990220,"株式会社F","高岡","B",5,5000]
[2,20210120,123456990231,"株式会社F","黒部","B",6,6000]
[2,20210120,123456990242,"株式会社F","黒部","B",1,1000]
[2,20210120,123456990253,"株式会社F","黒部","B",2,2000]
[2,20210120,123456990264,"株式会社F","黒部","B",3,3000]
[2,20210120,123456990275,"株式会社F","黒部","C",4,4000]
[2,20210120,123456990286,"株式会社F","黒部","C",5,5000]
[2,20210120,123456990290,"株式会社F","黒部","C",6,6000]
[2,20210120,123456990301,"株式会社F","黒部","C",1,1000]
[2,20210120,123456990312,"株式会社F","黒部","C",2,2000]
[2,20210120,123456990323,"株式会社F","黒部","C",3,3000]
[2,20210120,123456990334,"株式会社F","黒部","C",4,4000]
[2,20210120,123456990345,"株式会社F","黒部","C",5,5000]
[2,20210220,123456990356,"株式会社F","黒部","C",6,6000]
[2,20210220,123456990360,"株式会社G","黒部","C",1,1000]
[2,20210220,123456990371,"株式会社G","魚津","C",2,2000]
[2,20210220,123456990382,"株式会社G","魚津","C",3,3000]
[2,20210220,123456990393,"株式会社G","魚津","C",4,4000]
[2,20210220,123456990404,"株式会社G","魚津","D",5,5000]
[2,20210220,123456990415,"株式会社G","魚津","D",6,6000]
[2,20210220,123456990426,"株式会社G","魚津","D",1,1000]
[3,20210120,123456990430,"株式会社G","滑川","D",2,2000]
[3,20210120,123456990441,"株式会社G","滑川","D",3,3000]
[3,20210120,123456990452,"株式会社G","滑川","D",4,4000]
[3,20210120,123456990463,"株式会社G","滑川","D",5,5000]
[3,20210120,123456990474,"株式会社G","滑川","D",6,6000]
[3,20210120,123456990485,"株式会社G","滑川","D",1,1000]
[3,20210120,123456990496,"株式会社G","滑川","D",2,2000]
[3,20210120,123456990500,"株式会社G","滑川","D",3,3000]
[3,20210120,123456990511,"株式会社G","滑川","D",4,4000]
[3,20210120,123456990522,"株式会社G","滑川","D",5,5000]
[3,20210120,123456990533,"株式会社G","滑川","A",6,6000]
[3,20210120,123456990544,"株式会社G","滑川","A",1,1000]
[3,20210120,123456990555,"株式会社H","滑川","A",2,2000]
[3,20210220,123456990566,"株式会社H","滑川","A",3,3000]
[3,20210220,123456990570,"株式会社H","黒部","A",4,4000]
[3,20210220,123456990581,"株式会社H","黒部","A",5,5000]
[3,20210220,123456990592,"株式会社H","黒部","A",6,6000]
[3,20210220,123456990603,"株式会社H","黒部","A",1,1000]
[3,20210220,123456990614,"株式会社I","黒部","A",2,2000]
[3,20210220,123456990625,"株式会社I","黒部","A",3,3000]
[3,20210220,123456990636,"株式会社H","黒部","A",4,4000]
[3,20210220,123456990640,"株式会社H","黒部","A",5,5000]
[3,20210220,123456990651,"株式会社H","黒部","B",6,6000]
[3,20210220,123456990662,"株式会社H","黒部","B",1,1000]
[3,20210220,123456990673,"株式会社H","黒部","B",2,2000]
[3,20210220,123456990684,"株式会社H","黒部","B",3,3000]
[3,20210220,123456990695,"株式会社H","黒部","B",4,4000]
[3,20210220,123456990706,"株式会社H","黒部","B",5,5000]
[3,20210220,123456990710,"株式会社H","富山","B",6,6000]
[3,20210220,123456990721,"株式会社H","富山","B",1,1000]
[3,20210320,123456990732,"株式会社H","富山","B",2,2000]
[3,20210320,123456990743,"株式会社H","富山","B",3,3000]
[3,20210320,123456990754,"株式会社H","富山","B",4,4000]
[3,20210320,123456990765,"株式会社H","富山","B",5,5000]
[3,20210320,123456990776,"株式会社H","高岡","B",6,6000]
[3,20210320,123456990780,"株式会社H","高岡","B",10,10000]
[3,20210320,123456990791,"株式会社H","高岡","C",10,10000]
[3,20210320,123456990802,"株式会社H","高岡","C",10,10000]

{"sheet":"請求明細","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[1,{"$f":"VLOOKUP(A2,管理表!$A$2:$B$19,2,0)","v":"株式会社A"},null,null,2,"月度請求分"]
[]
["出荷日","注文番号","届先会社名","支店名","品名","数量","請求金額"]
[20210220,123456990113,"株式会社E","富山","A",6,6000]
[20210220,123456990124,"株式会社E","富山","B",1,1000]
[20210220,123456990135,"株式会社E","富山","B",2,2000]
[20210220,123456990146,"株式会社E","富山","B",3,3000]
[20210220,123456990150,"株式会社E","高岡","B",4,4000]
[20210220,123456990161,"株式会社E","高岡","B",5,5000]
[20210220,123456990172,"株式会社E","高岡","B",6,6000]
[20210220,123456990183,"株式会社E","高岡","B",1,1000]
[20210220,123456990194,"株式会社E","高岡","B",2,2000]
[20210220,123456990205,"株式会社F","高岡","B",3,3000]
[20210220,123456990216,"株式会社F","高岡","B",4,4000]
[20210220,123456990220,"株式会社F","高岡","B",5,5000]
[null,null,null,null,null,"合計",42000]