{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["销售收据"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"销售收据","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[7,1,7,2],[7,4,7,6],[8,1,8,2],[8,4,8,6]]}
[{"$nulls":7}," "]
[null,"买家","名称",null,null,"发票编号","发票编号"]
[null,null,"公司名称",null,null,"日期","发票日期"]
[null,null,"街道地址"]
[null,null,"省/直辖市/自治区，市/县 邮政编码"]
[null,null,"电话 | 传真"]
[]
[null,"付款方式",null,"支票编号","工作"]
[]
[]
[null,"数量","项目编号","说明","单价","折扣","行合计"]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[]
[{"$nulls":5},"总折扣"]
[null,"如对此发票有疑问，使用以下联系人信息：",{"$nulls":3},"小计",{"$f":"SUM(Table_SalesReceiptDetails[行合计])","v":{"v":0,"d":"¥0.00"}}]
[null,"联系人姓名、电话号码、电子邮件",{"$nulls":3},"销售税",{"v":0,"d":"0.00%"}]
[null,"谢谢惠顾！",{"$nulls":3},"汇总",{"$f":"(G26-(G26*G25))*(1+G27)","v":{"v":0,"d":"¥0.00"}}]