{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["结算单"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"结算单","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[6,1,6,7],[8,2,8,3],[8,6,8,7],[9,2,9,3],[9,6,9,7],[10,2,10,3],[10,6,10,7],[11,6,11,7],[12,1,12,2],[12,3,12,4],[12,6,12,7],[22,1,22,7],[23,1,23,7],[24,1,24,7],[25,1,25,2],[26,1,26,2],[26,3,26,7],[27,1,27,2],[27,3,27,7],[28,1,28,2],[28,3,28,7],[29,1,29,2],[30,1,30,2]]}
[null,"Stems and Sage Florist"]
[]
[null,"地址：","5678 Mountain Drive",null,"电话：","(333) 333-3333"]
[null,null,"Building A",null,"传真：","(333) 333-3334"]
[null,null,"Denver, CO 12345",null,"电子邮件：","stems@interestingsite.com"]
[]
[null,"结算单"]
[]
[null,"结算编号：",777,null,null,"收单方：","Kai Carter"]
[null,"日期：","2022-11-05",{"$nulls":3},"Partner Wedding Planners"]
[null,"客户 ID：",100123,{"$nulls":3},"432 1st Avenue"]
[{"$nulls":6},"Denver, CO 12345"]
[null,"所附汇款金额：",null,{"v":375,"d":"¥375.00"}]
[]
[null,"日期","类型","账单编号","说明","金额","付款","余额"]
[null,"2022-10-28","花卉布置",201,"10 枝",{"v":375,"d":"¥375.00"},null,{"$f":"IFERROR(IF(F16>0,F16-G16,\"\"), \"\")","v":375}]
[{"$nulls":7},{"$f":"IFERROR(IF(F17>0,F17-G17,\"\"), \"\")","v":""}]
[{"$nulls":7},{"$f":"IFERROR(IF(F18>0,F18-G18,\"\"), \"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":6},"汇总",{"$f":"SUBTOTAL(109,发票[余额])","v":375}]
[]
[null,"提醒：请在支票上附上结算编号。"]
[null,"条款：应付余额期限为 30 天。"]
[]
[null,"汇款"]
[null,"客户姓名：",null,{"$f":"客户_姓名","v":"Kai Carter"}]
[null,"客户 ID：",null,{"$f":"客户_ID","v":100123}]
[null,"结算编号：",null,{"$f":"结算_编号","v":777}]
[null,"日期：",null,{"$f":"结算_日期","v":"2022-11-05"}]
[null,"应付金额：",null,{"$f":"应付款_总额","v":{"v":375,"d":"¥375.00"}}]
[null,"所附金额：",null,{"$f":"汇款_金额","v":{"v":375,"d":"¥375.00"}}]