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

{"sheet":"帐单","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[1,2,1,3],[1,6,1,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,6,8,7],[9,6,9,7]]}
[null,"公司名称"]
[null,"街道地址",{"$nulls":3},"电话："]
[null,"地址 2",{"$nulls":3},"传真："]
[null,"省/市/自治区，市/县 邮政编码",{"$nulls":3},"电子邮件："]
[null,"结算单"]
[null,"结算编号：",null,null,"受票方：","姓名"]
[null,"日期：",{"$nulls":3},"公司名称"]
[null,"客户 ID：",{"$nulls":3},"街道地址"]
[{"$nulls":5},"地址 2"]
[{"$nulls":5},"省/市/自治区，市/县 邮政编码"]
[]
[null,"日期","类型","发票编号","说明","金额","付款","余额"]
[null,{"$f":"TODAY()","v":"2022-08-17"},"销售",123,"产品",{"v":200,"d":"¥200.00"},{"v":100,"d":"¥100.00"},{"$f":"IF(数据[[#This Row],[金额]]>0,数据[[#This Row],[金额]]-数据[[#This Row],[付款]],\"\")","v":{"v":100,"d":"¥100.00"}}]
[{"$nulls":7},{"$f":"IF(数据[[#This Row],[金额]]>0,数据[[#This Row],[金额]]-数据[[#This Row],[付款]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(数据[[#This Row],[金额]]>0,数据[[#This Row],[金额]]-数据[[#This Row],[付款]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(数据[[#This Row],[金额]]>0,数据[[#This Row],[金额]]-数据[[#This Row],[付款]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(数据[[#This Row],[金额]]>0,数据[[#This Row],[金额]]-数据[[#This Row],[付款]],\"\")","v":""}]
[{"$nulls":6},"汇总",{"$f":"SUBTOTAL(109,数据[余额])","v":{"v":100,"d":"¥100.00"}}]
[null,"提醒：请在支票上附上结算编号。"]
[null,"条款：应付余额期限为 30 天。"]
[null,"汇款"]
[null,"客户姓名："]
[null,"客户 ID："]
[null,"结算编号："]
[null,"日期："]
[null,"应付金额：",{"$f":"数据[[#Totals],[余额]]","v":{"v":100,"d":"¥100.00"}}]
[null,"所附金额："]